Goodness of Search

Question

Is there any kind of feature in SQL Server FTS that resembles a "goodness" metric?

We have a user requesting, "I want anything that matches two out of three words".

Thanks,

Josh

Answer 1

You can use CONTAINSTABLE

There are few good examples in the below link which you can try.

http://technet.microsoft.com/en-us/library/ms189760.aspx

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. - Kerobin

Answer 2

CONTAINSTABLE returns a ranking value - but the article doesn't say what that ranking specifies!

Well, I'll try it out shortly.

Aha, this tells the tale:

http://technet.microsoft.com/en-us/library/ms142524(v=SQL.105).aspx

... though at a brief reading it is not very clear.

Well, some more research and trials tomorrow should help.

Thanks!

Josh