SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 .NET Clr Soundex
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ddamico
Yak Posting Veteran

76 Posts

Posted - 04/29/2013 :  14:13:06  Show Profile  Reply with Quote
Good afternoon. I am wondering if anyone can point me to an equivalent derivation of the SQL Server Soundex algorithm. I have written my own version of SOUNDEX based on research I have done, however there seems to be a slight nuance in my implementation that doens't quite give me 100% match when comparing to SQL implementation.

Thanks,
Dan

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 04/30/2013 :  04:36:56  Show Profile  Reply with Quote
this one is superior to SOUNDEX

https://sites.google.com/site/sqlblindman/fuzzysearchalgorithm

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Abu-Dina
Posting Yak Master

United Kingdom
206 Posts

Posted - 04/30/2013 :  09:58:12  Show Profile  Reply with Quote
quote:
Originally posted by ddamico

Good afternoon. I am wondering if anyone can point me to an equivalent derivation of the SQL Server Soundex algorithm. I have written my own version of SOUNDEX based on research I have done, however there seems to be a slight nuance in my implementation that doens't quite give me 100% match when comparing to SQL implementation.

Thanks,
Dan




You may want to consider Double Metaphone or even Metaphone3 which is not free but you can get it from the author's website for around $30

Also check out the following link: http://www.sqlservercentral.com/articles/.Net/doublemetaphonephonecticmatching/2063/
Go to Top of Page

ddamico
Yak Posting Veteran

76 Posts

Posted - 04/30/2013 :  10:23:11  Show Profile  Reply with Quote
This information is great. We are looking at other fuzzy matching like metaphone and double metaphone for new implementations.

Though currently we need to stick with Soundex for our matching since we have multiple versions of SQL Server that being 2008 and 2012 that we are using soundex for billions of rows of data.

2012 has introduced a change to soundex algorithm so in order to stay consistent we would need to use either copatability level 100 or use our own implementation. I notice that the implementation I used handle adjacent codes that are the same by collapsing the two codes into one.

Example: Morman
M=6 N=6 reduces to 60 at the end instead of SQL 66

I wasn't sure if there was more that is why i was going to trying and mimic one to one intead of having to change the compatability mode on 2012 instance.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000