"Terry Smith" <TerrySmith@discussions.microsoft.com> wrote in message
news:54F118BF-95F8-4E76-B469-113C46B2FA02@microsoft.com...
> There are some conflicting reports about this on the web, but as best as I
> can tell FREETEXTTABLE includes stemming and thesaurus features but not
> SoundEx abilities. I would appreciate any help on using FREETEXTTABLE and
> SoundEx together in a query, particularly in regards to doing searches on
> people's names where stemming and thesaurus methods are not very usefull.
> I've seen examples of using FREETEXT and SoundEx together; however, I need
> the ranking information that FREETEXTTABLE provides.
>
> I'm also aware, based on the reports of others on the web, that SoundEx in
> SQL Server has plenty of problems, but I will have to push out
> implementing
> one of the other algorithms as a future enhancement.
>
> Any assistance would be greatly appreciated.
>
> Thank you,
>
> Terry
>
> ______________________
> Terry Smith
> Senior Architect
> Insight Ecosystems
> http://www.insightecosystems.com

"Terry Smith" <TerrySmith@discussions.microsoft.com> wrote in message
news:8CF07A1C-E4C2-4109-B199-D0B6322B144E@microsoft.com...
> Hi Hilary,
>
> Thanks for your reply. Yes, I'm looking for exactly what you said,
> "Searches
> on Smith to match with Smyth, Smith, Smithe, Smythe".
>
> I was hoping for an innovative way of perhaps joining a SoundEx query
> together with FREETEXTTABLE in a single statement.
>
>
> Terry
> ______________________
> Terry Smith
> Senior Architect
> Insight Ecosystems
> http://www.insightecosystems.com
>
>
> "Hilary Cotter" wrote:
>
>> I believe Oracle and IBM support Soundex features in the SQL FTS
>> products.
>> SQL Server does not.
>>
>> However the fuzzy grouping function of SSIS does have this functionality.
>>
>> Exactly what are you trying to accomplish? Searches on Smith to match
>> with
>> Smyth, Smith, Smithe, Smythe?
>>
>> --
>> Hilary Cotter
>> Director of Text Mining and Database Strategy
>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>>
>> This posting is my own and doesn't necessarily represent RelevantNoise's
>> positions, strategies or opinions.
>>
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>>
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>>
>>
>> "Terry Smith" <TerrySmith@discussions.microsoft.com> wrote in message
>> news:54F118BF-95F8-4E76-B469-113C46B2FA02@microsoft.com...
>> > There are some conflicting reports about this on the web, but as best
>> > as I
>> > can tell FREETEXTTABLE includes stemming and thesaurus features but not
>> > SoundEx abilities. I would appreciate any help on using FREETEXTTABLE
>> > and
>> > SoundEx together in a query, particularly in regards to doing searches
>> > on
>> > people's names where stemming and thesaurus methods are not very
>> > usefull.
>> > I've seen examples of using FREETEXT and SoundEx together; however, I
>> > need
>> > the ranking information that FREETEXTTABLE provides.
>> >
>> > I'm also aware, based on the reports of others on the web, that SoundEx
>> > in
>> > SQL Server has plenty of problems, but I will have to push out
>> > implementing
>> > one of the other algorithms as a future enhancement.
>> >
>> > Any assistance would be greatly appreciated.
>> >
>> > Thank you,
>> >
>> > Terry
>> >
>> > ______________________
>> > Terry Smith
>> > Senior Architect
>> > Insight Ecosystems
>> > http://www.insightecosystems.com
>>
>>
>>