Fuzzy Logic and Regex come to T-SQL in SQL Server 2008 R2 – available now!

re: Fuzzy Logic and Regex come to T-SQL in SQL Server 2008 R2 – available now!

Adam Machanic — Mon, 09 Nov 2009 22:40:23 GMT

Wow, that's excellent. Thanks for reporting!

re: Fuzzy Logic and Regex come to T-SQL in SQL Server 2008 R2 – available now!

Andy Clark — Tue, 10 Nov 2009 08:56:39 GMT

I'm sure this is a good thing, and is important for comparing data that is not people's names such as addresses or telephone numbers.

Soundex was developped for the US Census and hence is orientated towards people's names and the english pronciation of words.

The key issue I've seen with the Soundex is that it relies on the first letter being the same. It's also been commented that Soundex is not good in comparing non english names, however I've never seen that myself.

So for example are John Citson and John F. Kitson the same person?

re: Fuzzy Logic and Regex come to T-SQL in SQL Server 2008 R2 – available now!

dan — Tue, 10 Nov 2009 10:28:03 GMT

Very interesting, potentially lots of applications in anti money laundering etc, Master Data Services seems a good place to locate it.

re: Fuzzy Logic and Regex come to T-SQL in SQL Server 2008 R2 – available now!

Rob Farley — Tue, 10 Nov 2009 22:50:39 GMT

I can't believe I hadn't seen this. I didn't even get a Google Alert on my name. Hmm...

Thanks Jamie - now I just need to find the extra hours to get into all this (I feel another presentation's going to be prepared...)

re: Fuzzy Logic and Regex come to T-SQL in SQL Server 2008 R2 – available now!

Simon Sabin — Thu, 12 Nov 2009 03:13:40 GMT

This isn't all that it seems. These haven't been added to the language. Rather they are contained within a MDM database which you have to deploy.

I would be interested to know what redist there is on the database and the libraries.

re: Fuzzy Logic and Regex come to T-SQL in SQL Server 2008 R2 – available now!

Tonci Korsano — Wed, 18 Nov 2009 16:40:48 GMT

Hi there,

I got a google alert on this web page.

My keyword was ""fuzzy lookup".

I have other alerts like "fuzzy sql", "fuzzy grouping", etc.

Thank you for the heads-up.

Keep up this good work.

Best regards,

Tonci.

First sighting of SQL Server Master Data Services (MDS)

SSIS Junkie — Sat, 21 Nov 2009 16:47:50 GMT

I’m at SQLBits 5 today and I’ve just come out of Ian Marriott’s session where he talked about the forthcoming

re: Fuzzy Logic and Regex come to T-SQL in SQL Server 2008 R2 – available now!

wBob — Wed, 16 Jun 2010 15:26:02 GMT

See here for additional SQL 2008 R2 hidden function mdq.XmlTransform allowing you to use XSLT against XML in your database:

http://beyondrelational.com/blogs/wbob/archive/2010/05/05/sql-2008-r2-mds-easter-egg.aspx

re: Fuzzy Logic and Regex come to T-SQL in SQL Server 2008 R2 – available now!

Joe Wilkerson — Sun, 22 Aug 2010 19:24:10 GMT

I need fuzzy logic to find matches on distance (latitude, longitude) and dateTime stamp ... any thing within distance < x meters and with y seconds (of another entry) might be a match. For my situation this is a cross join on 100s of billions of rows in even the simplest cases!

I can code it easily with where clause functions as filters but I'm still trying to figure out how many 100s of hours it will run!

Ultimately, I assume I will have to recode in c# for efficiency, but trying to get a working prototype done first in sql only.

Fuzzy joins have many uses!