"Michael C" <xyz@abcdef.com> wrote in message
news:lr8vd.256$rM1.54@fe08.lga...
> Hi Mr. Celko,
>
> A few questions on your improved Soundex from SQL For Smarties, which I'm
> trying to implement on SQL Server 2K and .NET:
>
> 1) In step 2 you say to replace all non-leading vowels with "A". Does
that
> include "Y"?
>
> 2) At one step (5.0) you say to "perform cleanup functions"... is there
> anything specific that needs to be done here?
>
> 3) In step (5.1) I'm to "drop all terminal A and S characters"... does
> that mean all A's and S's on the end, in any combination? I.e., "SS",
"AA",
> "AS", "SASSA", etc.? Or just all A's *or* all S's occurring at the very
> end? If I'm reading correctly, we eliminate all A's (except leading A's)
in
> step 5.3 - so is it even necessary to first strip out all terminal A
> characters before this?
>
> 4) Finally, in step (5.4) "strip all but the first of repeating adjacent
> character substrings"... Don't get rid of the first repeating set
anywhere,
> or don't get rid of the first repeating characters if they occur at the
> beginning of the string?
>
> Sorry for all the questions, but I want to make sure I implement this
> correctly.
>
> Thanks,
> Michael C.
>
>

"Adam Machanic" <amachanic@hotmail._removetoemail_.com> wrote in message
news:eWRTWlM4EHA.4004@tk2msftngp13.phx.gbl...
> There are much better algorithms than SOUNDEX available; have you seen
> this
> article, on implementing Double Metaphone in T-SQL?
>
> http://www.winnetmag.com/SQLServer/Article/ArticleID/26094/SQLServer_26094.html
>
> I'm betting you'll have a lot better luck with it than with any SOUNDEX
> implementation, but YMMV as always :)
>
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
>
> "Michael C" <xyz@abcdef.com> wrote in message
> news:lr8vd.256$rM1.54@fe08.lga...
>> Hi Mr. Celko,
>>
>> A few questions on your improved Soundex from SQL For Smarties, which I'm
>> trying to implement on SQL Server 2K and .NET:
>>
>> 1) In step 2 you say to replace all non-leading vowels with "A". Does
> that
>> include "Y"?
>>
>> 2) At one step (5.0) you say to "perform cleanup functions"... is there
>> anything specific that needs to be done here?
>>
>> 3) In step (5.1) I'm to "drop all terminal A and S characters"... does
>> that mean all A's and S's on the end, in any combination? I.e., "SS",
> "AA",
>> "AS", "SASSA", etc.? Or just all A's *or* all S's occurring at the very
>> end? If I'm reading correctly, we eliminate all A's (except leading A's)
> in
>> step 5.3 - so is it even necessary to first strip out all terminal A
>> characters before this?
>>
>> 4) Finally, in step (5.4) "strip all but the first of repeating adjacent
>> character substrings"... Don't get rid of the first repeating set
> anywhere,
>> or don't get rid of the first repeating characters if they occur at the
>> beginning of the string?
>>
>> Sorry for all the questions, but I want to make sure I implement this
>> correctly.
>>
>> Thanks,
>> Michael C.
>>
>>
>
>