Full Text Search for Dummies!!
Posted on 2011-10-05
Is there a webpage somewhere that simply explains the uses of CONTAINS and FREETEXT with the RESULTS so I can see what these predicates actually do? I'm trying to lean the capabilities but the MS docs drive me nuts and I don't have the DBs installed to run most examples.
Also what does 2 words being "near" each other mean? Is that defined when you set up FTS?
Any "primer" would be appreciated.
We have an application where someone keys in an Organization Name and my boss wants to know what kind of "fuzzy" search can be done. If someone keys in:
Int'l Business Machine
International Business Machine
InterMachinal Business Machinee (spelling)
I would like to find our row "International Business Machine".
Thanks in advance