I am trying to use freetext to return "best match" results from a database
with movie titles, and it gives me a few different results than what I would
like it to.
I should properly mention that I have just looked at freetext in a few days,
so bare with my limited knowledge.
I have a query like this:
SELECT TOP 10 tblTitles.nvcTitle FROM tblTitles,
FREETEXTTABLE (tblTitles, nvcTitle, 'Big Mommas House') AS KEY_TBL
tblTitles.guid = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC
And the query works, I am just not happy with the result, properly because
the word "Big" gives a higher rank when it's located in the string more than
once, the results I get is the following (ordered):
1. Dragnet (1951/ Digiview Entertainment), Vol. 3: The Big Crime / The Big
Shoplift / The Big Girl
2. World's Famous Detectives, Vol. 2: Dragnet: Big Crime / Big Pair / Big
Producer / Big Break / Big September Man / ...
3. Big Momma's House (Widescreen)
4. Bear In The Big Blue House: Storytelling With Bear
5. Big Momma's House 2
6. Big Momma's House
7. Bear In The Big Blue House: Sense-Sational!
8. Bear In The Big Blue House: Tidy Time With Bear
9. Big Momma's House
10. Bear In The Big Blue House: Sleepy Time With Bear And Friends
Notice that instead of finding "Big Momma's House" title(s), it ranks two
other titles higher because the word "Big" is in there many times. Next, it
ranks "Big Momma's House 2" higher than "Big Momma's House" although I would
say the first title should be more accurate.
Can I in any way configure my freetext to only rank a word once, and perhaps
re-configure something to improve it for my purpose, or is the freetext
engine fixed to it's default ranking method?