I'm trying to get a grip on the ranking that is returned from a fulltextsearch using CONTAINSTABLE.
My query looks like this at the moment

Code:
select TOP 20 K.rank, LocationId, CityNameAccented, L.CountryId
from Locations as L
INNER JOIN 
CONTAINSTABLE (Locations, CityName, 'ISABOUT ("Amster*")') as K ON L.LocationId = K.[KEY]
ORDER BY K.Rank DESC
This return the folowing rows: (Columns are: Rank, Id, Cityname, CountryId)

Code:
456	1648401	Amsterdamscheveld	123
456	1648403	Amsterdamseveld	123
456	2623761	Amsterdamhoek	159
339	892100	New Amsterdam	71
339	2197213	Fort Amsterdam	163
339	2197214	Fort Neu-Amsterdam	163
339	2197215	Fort New Amsterdam	163
339	2197458	Nieuw Amsterdam	163
339	1648400	Amsterdam	123
339	1652195	Klein Amsterdam	123
339	1653462	Nieuw-Amsterdam	123
I don't quite understand why the first three records get a higher ranking than the 9th record ('amsterdam').

Is there anyone who can clarify this, and maybe even show me how I would be able to the 9th record higher in the ranking?