Hi

I must be missing something obvious. I'd like to write a query that
ranks the row containing the most unique keywords first, rather than
the row with the most keywords.

1) my user enters "red green blue"
2) my query include somthing like freetexttable (xxx,xxx, 'red green
blue'  )

I would like the top-ranked result to be

".. ... red.. green .. .. blue... .. "

not

"red red red green purple orange red"

Currently the density of the "red" keyword in the second row is giving
it top rank. This isn't right. What am I missing? Is there a way to
limit the impact of high keyword occurrency or change the ranking
method?

Thanks.