title: Fulltext search not returning expected results
body: <p>I am experimenting with SQL Server full text search. </p>
  
  <p>I have a simple Categories table with Id as the primary key:</p>
  
  <pre><code>CREATE TABLE [dbo].[Category](
   [Id] [int] IDENTITY(1,1) NOT NULL,
   [CategoryName] [varchar](100) NOT NULL,
  )
  </code></pre>
  
  <p>My Query is:</p>
  
  <pre><code>SELECT * 
  FROM
   FREETEXTTABLE (Category, CategoryName, 'music') AS F
   INNER JOIN  Category C ON F.[Key] = C.Id
  ORDER BY F.Rank DESC
  </code></pre>
  
  <p>This returns me several records with the word music in them, but it does NOT return any record with word ‘musical’.</p>
  
  <p>Although, it can be said that the string being searched is not very big and using the LIKE operator will resolve it. I would like to use fulltext search because this simple example is going to be extended to include other tables and fileds.</p>