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