Prev: Help in update
Next: sys.conversation_endpoints not purged
From: Goldeye on 9 Jun 2010 04:55
Hi Mike,

Would it be possible to email the codes to goldeye61(a)yahoo.com?.....greatly
appreciate the help!

"Mike C#" wrote:

>
> "Geoff Schaller" <geoffx(a)softwareobjectivesx.com.au> wrote in message
> news:4782cc23$1(a)dnews.tpgi.com.au...
> > Matija,
> >
> > I am not sure I really understand. Ultimately this needs to be a t-sql
> > statement that will be called from an application. To my limited
> > knowledge, soundex is the only thing available. Or are you suggesting
> > there is something else which generates t-sql to do something more?
> >
> > I guess initially I was disappointed that the soundex match was so poor.
> >
>
> AFAIK the SSIS fuzzy lookup suggestion is for data transformations that run
> through SSIS. You can use T-SQL or SQLCLR to create your own fuzzy
> matching. There are lots of examples of fuzzy matching algorithms available
> out there, but most are probably in C/C++ and may require conversion to run
> on SQL Server. Here's an example of a double metaphone implementation in
> SQLCLR:
> http://www.sqlservercentral.com/articles/.Net/doublemetaphonephonecticmatching/2063/
>
> It's slightly better than Soundex, but there are definitely better
> algorithms out there. I may have some beta SQLCLR and T-SQL implementations
> for other algorithms lying around if you'd like to try them. Let me know
> and I'll see if I can locate some source code for you. I assume your email
> is without the extra x's?
>
>
>
 | 
Pages: 1
Prev: Help in update
Next: sys.conversation_endpoints not purged