Hi all
I am looking for some code that will return the degree of correlation regarding the similarity of two strings in SQL. SOUNDEX and DIFFERENCE will not work for what I'm trying to do, unfortunately.
Does anybody have any code that does this kind of thing that they would be willing to share?
Thanks, Matt
Hi Matt,
I'm attaching the procedure I use to determine if two strings are similar. I mainly use it to see if pairs of names or addresses are just alternate spellings of each other. You could tweak it to whatever degree of similarity/dissimilarity you needed, including perhaps a percentage of similarity. Just a thought.
Normal 0 false false false MicrosoftInternetExplorer4
Katie Lachance-Duffy
Application Systems Analyst
Theatre Alliance of Greater Philadelphia
215-399-4904
catherine@theatrealliance.org
Hi Katie,
This looks like it could be helpful. I will take a look at it today. Thanks so much for responding!
This will definitely be an interesting job. I am trying to compare the names of works of music between two systems. Sometimes system a will use english, sometimes german, sometimes italian and likewise for the other. In the cases where both are using the same language, there are still issues with the way the words are sequenced within the name that is giving me a headache.
Thanks again!
Matt