Hi Mike,
I wasn't the one who asked question.

>You should be able to create a calculated column on the SOUNDEX() function and index it. SQL Server will use the index if you reference the column in your query:
>
>CREATE TABLE temp (
> lastName nvarchar(60)
> ,s_lastName AS SOUNDEX(lastName)
> , ...
>)
>
>CREATE NONCLUSTERED INDEX temp_s_lastName ON temp(s_lastName)
>
>SELECT * FROM temp WHERE s_lastName = ...
>
>See the topic Creating Indexes on Computed Columns in the BOL. There are some configuration settings that MUST be set in order to create and maintain the index.
>
>-Mike