similarity between strings - sql server 2005
- by csetzkorn
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