title: Search for part of the word in the phrase with full text search in SQL Server 2016
body: <p>In the Microsoft SQL Server, our searches are limited to starting words when we use a full-text search to search for values. That is, we cannot search contains the word looks like the <code>LIKE</code> operator in the middle.</p>
  
  <p>I try to execute this query but the result is not my opinion.</p>
  
  <p>I want to search for the middle of the term. For example, if my term is "Microsoft" and my query is :</p>
  
  <pre><code>SELECT * 
  FROM dbo.SMS_Outbox 
  WHERE CONTAINS(MessageText, N'"*soft*"')  
  </code></pre>
  
  <p>There is no result returned!</p>