title: Dictionary-like search using SQL Server FULL-TEXT
body: <p>I am trying to create a dictionary for my website.
  Searching for 'server' using FREETEXTTable &amp; Rank DESC returns:</p>
  
  <ol>
  <li>name server - A program or server that maps human-readable names..</li>
  <li>server - One who serves; a waitress or waiter.</li>
  <li>server - A tray for dishes; a salver.
  4...</li>
  </ol>
  
  <p>'server' is obviously closer to 'server' than 'name server'. How do I fix the ranking?</p>
  
  <p>I can not just reverse to ASC because there are even worse matches.
  Top 3 results for 'God' are 'act of God', 'Lamb of God', 'Le God'..</p>
  
  <p>Edit: Sorry for any confusion. nameserver, server, server.. are in a single column called 'word' this is the column that is queried with full-text search. The definitions are in the next column 'definition' and returned as query results.</p>