Google like search query using Full Text Search in SQL Server

Question

I am running a small website wherein I would like to make a functionality like Related Links section.

For that I created fulltext catalog and index.

So far I tried many ways to create search query which behaves like google, but I would say i was not even 10% close to what google is doing. During my research what i found was only following query was pulling good records.

Select col1, col2
from MyTable
Where
FREETEXT(col1,  'User Passed Search Text')

Has anyone has good way to create a FullText Search Query which can help in getting better related records for given text?

Thanks

Answer 1

Seemsthe fulltext topic has been discussed quite a bit: Stackover Flow Pros and Cons of full text search types. I might suggest reading over that, as the query you're trying above doesn't even seem to be working that well.

Answer 2

Take a look at this article, you might find it useful

http://www.sqlservercentral.com/articles/Full-Text+Search+(2008)/64248/

Roger