Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Fuzzy search

Author  Topic 

Norman Castle
Starting Member

9 Posts

Posted - 2011-01-19 : 04:17:09
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

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-01-19 : 04:28:04
Look in to Full-text indexes: http://msdn.microsoft.com/en-us/library/ms142571.aspx

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com
Go to Top of Page
   

- Advertisement -