title: How to search for similar words in SQL Server
body: <p>I am using <code>CONTAINS</code> and <code>FREETEXT</code> on SQL query to search for text in big text fields.</p>
  
  <p>What I noticed that the search returns result when the exact word match, but what if I want to search for similar words?</p>
  
  <p>For example, when I type <strong>Carlo</strong>, it did not display anything if what I have is <strong>Carlos</strong> (with an <strong>S</strong>)</p>
  
  <p>Below is a simple query similar to the one I use:</p>
  
  <pre><code>SELECT P.*                      
  FROM MyTable AS P
  WHERE(CONTAINS(P.*, 'Carlo') OR freetext(P.*, 'Carlo'))
  </code></pre>
  
  <p>How can I make the search bring similar words to <strong>Carlo</strong> such as <strong>Carlos</strong>, <strong>Carla</strong>, etc... without affecting the performance?</p>