"Sounds-like" queries on full-text catalogs?

Hello, All.
I need to do queries agains full-text catalogs, but I need that be performed
using a "sounds-like" criteria. Is the full-text in SQL Server 2005 able to
do that kind of query?
Cesar
Not really. You probably need to incorporate a metaphone or sonudex
expansion to do this. You might be able to use the thesaurus features here.
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
"ronchese" <info(a)carsoftnet.com.br> wrote in message
news:Ocwr4Q6oHHA.3944@.TK2MSFTNGP02.phx.gbl...
> Hello, All.
> I need to do queries agains full-text catalogs, but I need that be
> performed using a "sounds-like" criteria. Is the full-text in SQL Server
> 2005 able to do that kind of query?
> Cesar
>
|||Ok, thanks. Do you think the Double Metaphone works well (off course, if you
know it)?
Double Metaphone URL:
http://www.codeproject.com/cs/algorithms/dmetaphone5.asp
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u1%231Rh6oHHA.4400@.TK2MSFTNGP03.phx.gbl...
> Not really. You probably need to incorporate a metaphone or sonudex
> expansion to do this. You might be able to use the thesaurus features
> here.
> --
> 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
> "ronchese" <info(a)carsoftnet.com.br> wrote in message
> news:Ocwr4Q6oHHA.3944@.TK2MSFTNGP02.phx.gbl...
>
|||Double Metaphone wouldn't be my first choice. I think the Thesaurus would
be gigantic if you tried to incorporate all of the possible phonetic
encodings into it. You might look into NYSIIS if you wanted to build your
own phonetic expansion. Here are several phonetic encoding algorithms, and
source code is also available:
http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart3.asp
Algorithms implemented there include Double Metaphone, Celko Soundex,
Daitch-Mokotoff, NYSIIS, plus a couple of edit distance algorithms.
Hey Hilary, let's build a phonetic word-breaker
"ronchese" <info(a)carsoftnet.com.br> wrote in message
news:eoVHwu6oHHA.4772@.TK2MSFTNGP05.phx.gbl...
> Ok, thanks. Do you think the Double Metaphone works well (off course, if
> you know it)?
> Double Metaphone URL:
> http://www.codeproject.com/cs/algorithms/dmetaphone5.asp
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u1%231Rh6oHHA.4400@.TK2MSFTNGP03.phx.gbl...
>