January 19, 2011 at 2:14 am
Does anyone know of a good add on that will allow fuzzy text searches?
(sql server 2008)
Specifically, I'm building up a database of how much various items, eg second hand cameras sell for on eBay. I've already written the code to download the data. But to query the database is tricky, because people keep misspelling the names of the cameras. For example, a Canon IXUS 90 IS might be entered as Canon 9015. Or they might write Cannon instead of Canon. I want a search that is intelligent enough to recognise these as near misses.
Any advice on a suitable add on?
Edit/Delete Message
January 19, 2011 at 2:29 am
You could try the SSIS fuzzy lookup
January 19, 2011 at 2:59 am
Or else you can try the Soundex function.
select SOUNDEX('Canon IXUS 90 IS'),SOUNDEX('Canon 9015'),SOUNDEX('Cannon')
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 19, 2011 at 3:04 am
Just realised Soundex wont work if data is entered like this '9015 Canon' as soundex function does not works well on numeric identifiers
select SOUNDEX('Canon IXUS 90 IS'),SOUNDEX('Canon 9015'),SOUNDEX('9015 Canon'),SOUNDEX('Cannon')
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
January 19, 2011 at 5:51 am
Dave Ballantyne (1/19/2011)
You could try the SSIS fuzzy lookup
I've never heard of it. Can you give some information?
January 19, 2011 at 5:54 am
qwerty 87425 (1/19/2011)
Dave Ballantyne (1/19/2011)
You could try the SSIS fuzzy lookupI've never heard of it. Can you give some information?
Google is your friend 🙂 , though it may not be an option. SSIS has a steep learning curve
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply