title: SQL ContainsTable is ranking higher if word is found multiple times. How do I stop this?
body: <p>We have a procedure that returns this:</p>
  
  <pre><code>SELECT TOP 15 SearchName, AlternateName, CountryName, StateProvince, Latitude, Longitude, Type, boost + k.Rank as Rank
  FROM SearchLocations
      INNER JOIN CONTAINSTABLE([SearchLocations], [SearchName], @Search) AS k
      ON SearchLocations.Id = k.[Key]
  ORDER BY Rank DESC
  </code></pre>
  
  <p>Basically, it full-text searches <code>[SearchLocations]</code> and orders the results based on full-text ranking and the boost column. Problem is, when I search for `ISABOUT("L*" WEIGHT(1.0))', which is what would be given to '@Search' as the input for "L", cities like</p>
  
  <ul>
  <li>Lagos Lagos Nigeria</li>
  <li>Lima Provincia de Lima Peru</li>
  </ul>
  
  <p>show up higher than <code>Los Angeles California United States</code>. While their boost is lower, full-text search gives them a higher ranking because they repeat the same word. This also happens in cases of places that don't repeat words but have the same sub-word multiple times.</p>
  
  <p>How do I disable/work around this?</p>