Hi, we have a full text search query and we need the number of hits (if any). We use contains and FORMSOF INFLECTIONAL in order to get all the forms of a term. Is there a way to get it somehow? Our query is using fulltext search not only with words but with
phrases also (i.e. 'email address').
Since ranking is using hitcounts in it's formula we thought it may be available but seems it's not....
Moved byNaomi NWednesday, January 23, 2013 11:46 PMBetter answer can be here
The number of rows is returned of course and the rank if using the *TABLE functions, but not the number of hits that happened inside the row. Sorry. There are a couple of functions you can use to deduce more, but not everything. And the
functions will run slowly on a large corpus of text.
Returns the final tokenization result after applying a given word breaker, thesaurus, and stoplist combination to a query string input. The output is equivalent to the output if the specified given query string were issued to the Full-Text Engine.
Describes how full-text search generates the rank values returned by a query, including commonly used terms and statistical values that are important in calculating rank, rank computation issues, and the ranking of CONTAINSTABLE and FREETEXTTABLE functions