sqlnoobie (2/28/2011)
tfifield (2/28/2011)
I'm still interested to know how you're handling plurals, tradenames, abbreviations, etc.?
sqlnoobie,
I wouldn't use this technique if I had to handle abbreviations, trademarks, etc. This technique works very well for item/product descriptions in a controlled environment. The first case was item descriptions for wine and the second one was for item descriptions for auto parts. None of these had abbreviations or other shortened words.
The users would enter something like 'cabernet 2001' and expect to get all wines from 2001 that had the word cabernet in the descripton. Likewise a user would enter 'brake pads' and expect to see a list of all items with brake pads in the description.
Todd Fifield