FTS final

We can also use weight

SELECT Rank, ProductModelID, Name
FROM Production.ProductModel pm
JOIN CONTAINSTABLE(Production.ProductModel, Name, ‘ISABOUT (Road WEIGHT (.2), Touring WEIGHT (.4), Mountain WEIGHT (.8) )’ ) ct
ON pm.ProductModelID = ct.[KEY]
ORDER BY Rank DESC

Noise word list is list of words which SQL server ignores.

The noise word list is, by default, stored in a text file in the path:
Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData

For U.S. English, the name of the file is noiseENU.txt.