c360 Forums / Data Quality Center / Version 3 Product Questions / Core Productivity Pack / What is soundex and how does it work in duplicate detection / Latest PostsInstantForum.NET v4.1.4c360 Forumshttp://www.c360.com/Forums/support@c360.comSat, 22 Nov 2008 14:32:50 GMT20What is soundex and how does it work in duplicate detectionhttp://www.c360.com/Forums/Topic1437-10-1.aspx<FONT face=Tahoma color=#0000ff>Soundex is a phonetic algorithm for indexing names by their sound when pronounced in English. The basic aim is for names with the same pronunciation to be encoded to the same string so that matching can occur despite minor differences in spelling.</FONT></P><P><FONT face=Tahoma color=#0000ff>For example: 'Jeremie' would soundex match with 'Jeremy'<BR>For more information on Soundex, please see <A href="http://en.wikipedia.org/wiki/Soundex">http://en.wikipedia.org/wiki/Soundex</A></FONT></P><P><FONT face=Tahoma color=#0000ff>Duplicate Detection uses the SQL server soundex function:<BR></FONT><FONT face=Tahoma color=#0000ff>For more details see<BR><A href="http://msdn2.microsoft.com/en-us/library/aa259235(SQL.80).aspx">http://msdn2.microsoft.com/en-us/library/aa259235(SQL.80).aspx</A></FONT></P><P><FONT face=Tahoma color=#0000ff>Using soundex functionality, you can identify more duplicate data (that may be missed using simple string comparison) and keep your system duplicate free.</FONT></P><P><FONT face=Tahoma color=#0000ff><BR> </P></FONT><P><P class=MsoNormal><FONT size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Tahoma"><A title=blocked::http://msdn2.microsoft.com/en-us/library/aa259235(SQL.80).aspx href="http://msdn2.microsoft.com/en-us/library/aa259235(SQL.80).aspx"><FONT color=#111111></FONT></A><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></FONT>Fri, 04 May 2007 11:26:08 GMTArvind Raman