title: Full text search and domain names
body: <p>I stumbled accross an issue with full text search in columns which may contains domain names on a Microsoft SQL Server 2012.</p>
  
  <p>A table cell containing <code>example.com</code> is added to the full text catalog by the term <code>example</code> and <code>com</code>. The latter makes it impossible to search for a domain name, as any entry containing that tld will be found.</p>
  
  <p>What do you need to do in order to prevent urls from being broken?</p>
  
  <p>EDIT: The example query would be:</p>
  
  <pre><code>SELECT * FROM Test WHERE FREETEXT(test, 'example.com')
  </code></pre>
  
  <p>The Test table only contains two rows, containing <code>example.com</code>and <code>differenturl.com</code>, both are returned as a result. The Test database was created for this example.</p>