Double Metaphone Phonetic Matching

• Mike C

  SSC-Insane

  Points: 23224

  More actions

  October 5, 2005 at 12:00 am

  #165038

  Comments posted to this topic are about the item Double Metaphone Phonetic Matching

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  October 5, 2005 at 3:15 am

  #595088

  For anyone who does not yet have SQL Server 2005, here's an article for achieving similar results using a UDF in SQL Server 2000...

  http://www.windowsitpro.com/Article/ArticleID/26094/26094.html?Ad=1 (written by Tim Pfeiffer)

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  March 2, 2012 at 9:14 am

  #1454257

  Don't use this code.

  I just tested, and names like "George" and "Sally" come up as exact matches.

  Other examples of "exact" (rank 3) matches:

  Beth, Stephanie

  Gus, Lisa

  Pie, Hello

  Not sure what's wrong with the algorithm, but it false-positives on its compare function pretty consistently.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon