Re: Keyword frequency skewing results

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello

I'm afraid it is right. Thats how the ranking is supposed to work.

Unfortunately there is no hitcount mechanism in full text to be able to rank in the way you want.

Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


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.



.

Relevant Pages

  • Re: Website is not ranking while work done very good
    ... ranking in Top 1000 in low rank keywords while it should rank. ... find out what your rank is for keywords that are actually sending ... This will let you know what search engines ARE ranking you for. ...
    (alt.internet.search-engines)
  • Re: Check keyword density for URL with https
    ... > with low keyword density beating out a site, in the rankings, that has ... > their site ranking better thataway. ... I had top positions at Google about 1-2 years ago. ... > those keywords when all they are doing is putting up essentially blank ...
    (alt.internet.search-engines)
  • RE: How EXACTLY does Indexing Service determine rank
    ... the point that they are adjacent becoming a phrase and raising the rank ... The ranking mechanism is weighted so that the more highly inflected ... the linguistic engine and ranking algorithm ... Indexing Service is based on ranking formulas that are used everywhere from ...
    (microsoft.public.inetserver.indexserver)
  • Re: Increasing your PAGE RANK
    ... >> Participating in link schemes is a way to increase page rank, ... so the site 'spam ranking' will ... I have a "useful links" page on one site for people who want ... > to do a link exchange. ...
    (alt.internet.search-engines)
  • Re: Integrating results from different pages? (No luck w/ INDEX &
    ... ranking for every player that has a ranking. ... Most of my source come in the format "Rank. ... Lastname" match a cell that is a formula that gives the same result? ... > Now you have all the names in sheet3 ...
    (microsoft.public.excel.misc)