Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Double Metaphone Phonectic Matching Expand / Collapse
Author
Message
Posted Monday, August 29, 2005 8:57 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/mcoles/doublemetaphonephonecticmatching.asp
Post #215141
Posted Wednesday, October 5, 2005 3:15 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 11:22 AM
Points: 1,755, Visits: 4,652

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.
Post #226161
Posted Friday, March 2, 2012 9:14 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #1260903
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse