No percentage ranking. So what to do with freetext search results?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andreas Bauer - 15 Nov 2006 10:14 GMT

Hi,

as I read in the SQL 2000 Server FAQ that free text search ranks aren't
suitable for calculating percentage values, what other ways are there
to get sensible results for presenting to a user?
Or are there none at all?

Thanks in advance.

Best regards,

Andreas

Reply to this Message

Hilary Cotter - 15 Nov 2006 12:05 GMT

Well...........they measure relevance. A higher score means more relevant
than a lower score. Most people either return results ordered by rank desc,
or they get the rank and then divide it by the highest rank. So the row with
the highest rank would have a value of 1. Then they would display 5 stars
for this. Ranks between .60 and .8 get 4 stars, etc.

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
[quoted text clipped - 8 lines]
>
> Andreas

Reply to this Message