I am using Freetext search in sqlserver 2008 r2 and iam getting unwanted results too which dont have my serching key word.. why is that
Is there anything with my indexes
If so how could i fix it..
- Moved by SathyanarrayananS Monday, April 07, 2014 6:43 AM Moving from T-SQL
There is likely nothing wrong with your indexes. However, you are using FREETEXT which is less precise than CONTAINS. FREETEXT effectively ORs the various words that you are searching for and does other transformations. Some things that happen are:
- Separates the string into individual words based on word boundaries (word-breaking).
- Generates inflectional forms of the words (stemming).
- Identifies a list of expansions or replacements for the terms based on matches in the thesaurus.
Therefore INFLECTIONS of words are also included. E.g. you could search for run and also get ran, running, etc.
If you need more precise answers, the look into using the CONTAINS operator rather than FREETEXT. (Or use CONTAINSTABLE rather than FREETEXTABLE.)
See this for more explanation: http://technet.microsoft.com/en-us/library/ms142583.aspx
Well, it is difficult to trouble-shoot a particular full text query remotely. What is your search string? And what words are you looking for?
There will always be a logical reason why a dataset is returned. Can you post your query and an example of the returned dataset (preferably a matching one and a non-matching result that was returned).
We can then see what's going on.