Thank you! I had just been grousing about soundex and a better solution drops into my lap. I hope to use this in production ASAP.
A Question...
When I run:
select 'SCHUMAKER' as Name, dbo.udf_nysiis ('SCHUMAKER') as Result union all
select 'SHOEMAKER', dbo.udf_nysiis ('SHOEMAKER') union all
select 'SHEWMAKER', dbo.udf_nysiis ('SHEWMAKER') union all
select 'SCHUWMACKER', dbo.udf_nysiis ('SCHUWMACKER')
I get:
Name Result
----------- ---------------
SCHUMAKER SANAKAR
SHOEMAKER SANAKAR
SHEWMAKER SAENAKAR
SCHUWMACKER SAUNACKAR
The last two results bother me. Aren't all vowels supposed to be replaced with "A" or have I misread the algorithm?
I'm using the version of the code included in the install directory.
Thanks again