Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fuzzy Search

Status
Not open for further replies.

NormanCastle

Programmer
Nov 17, 2010
3
GB
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?
 
Depending on the version of SQL you have there is a soundex function.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top