• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 12 views
  • Users 0 members are here
Related

Code determining similarity of strings

Matthew Hoyt
$organization

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

 

 

 

  • $organization

    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

     

     

  • $organization in reply to Katie Lachance-Duffy

    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