Hi,
I am looking for a simple way (UDF?) to establish the similarity between strings. The SOUNDEX
and DIFFERENCE
function do not seem to do the job.
Similarity should be based on number of characters in common (order matters).
For example:
Spiruroidea sp. AM-2008
and
Spiruroidea gen. sp. AM-2008
should be recognised as similar.
Any pointers would be very much appreciated.
Thanks.
Christian