title: Sql Server 2008 R2 Full-Text Search understand two words and better ranking
body: <p>Hi I'm trying to understand Full-Text Search in MS Sql Server.</p>
  
  <p>I got a simple search working</p>
  
  <pre><code>SELECT *
  FROM Product
  WHERE FREETEXT (*, 'stackoverflow' );
  </code></pre>
  
  <p>Even got some simple rank working.</p>
  
  <pre><code>SELECT
     *
  FROM
      Product
      INNER JOIN FREETEXTTABLE ( Product , * , 'stackoverflow' ) ft ON ( Product.ProductNo = ft.[Key] )
  ORDER BY
      ft.Rank DESC
  </code></pre>
  
  <p><em>My First Question is</em>
  How do I control the rank more. Ex. I want the <strong>products</strong>, <strong>name</strong> column to give a higher rank, than the <strong>description</strong> column if the search word is found there.
  and is it possible to make it search for only part of a word. ex. </p>
  
  <p><em><strong>overflow</em></strong> -> return <strong>stackoverflow</strong> </p>
  
  <p><strong>stack</strong> -> return <strong>stackoverflow</strong></p>
  
  <p><em>My Second Question</em>
  How do I make it possible to find the correct result when searching after <strong>stack overflow</strong> in two word.
  Since I'm going to have alot of products where some users are going to spell it in two words, when it is correctly spelled in one word.
  I got a dictonary installed for my Full Text Catalog, but it don't help with searchword in two words.</p>
  
  <h2>Product Table</h2>
  
  <ul>
  <li><p>Id </p></li>
  <li><p>Name </p></li>
  <li><p>Description</p></li>
  </ul>