title: Full Text CONTAINS does not return expected results
body: <p>Using Full Text on a column which contains directory paths, I'm getting far less results from <code>CONTAINS</code> than from <code>LIKE</code>.</p>
  <p>I thought I was aware of the differences in how the indexes and searches work (word/phrase vs character/pattern), but I must be missing something.</p>
  <p>Here are two rows from the column, identical in form of the originals aside from the lorum ipsum swap.</p>
  <pre><code>100303               \\fq.dn.tld\lorem\ipsum\__sub.fq.dn.tld_dolor\sit\amet\lorem\consectetur\adipiscing\12345_sed1_SED-do_eiusmod-tempor_incididunt\
  
  100304               \\sub.fq.dn.tld\dolor\sit\amet\lorem\consectetur\adipiscing\12345_sed1_SED-do_eiusmod-tempor_incididunt\
  </code></pre>
  <p>Using a standard <code>LIKE</code> based query will return both rows as expected.</p>
  <pre><code>SELECT * 
  FROM DirectoryPath 
  WHERE Path LIKE '%sed%'
  </code></pre>
  <p>However using <code>CONTAINS</code>:</p>
  <pre><code>SELECT * 
  FROM FilePath 
  WHERE CONTAINS(Path, '&quot;sed1*&quot;')
  </code></pre>
  <p>Only returns the second row.</p>
  <p>To add to my confusion, I attempted to add the Lorem ipsum as above, and I get no results from Contains, and both from like.</p>
  <pre><code>INSERT INTO FilePath (Path)VALUES
      ('\\fq.dn.tld\lorem\ipsum\__sub.fq.dn.tld_dolor\sit\amet\lorem\consectetur\adipiscing\12345_sed1_SED1-do_eiusmod-tempor_incididunt\'), 
      ('\\sub.fq.dn.tld\dolor\sit\amet\lorem\consectetur\adipiscing\12345_sed1_SED1-do_eiusmod-tempor_incididunt\'); 
  GO; 
  
  ALTER FULLTEXT INDEX
  ON filepath START UPDATE POPULATION; 
  GO;
  
  SELECT  *
  FROM FilePath
  WHERE CONTAINS(Path, ' &quot;sed1*&quot; ');
  
  SELECT  *
  FROM FilePath
  WHERE path LIKE ' % sed1 % ';
  </code></pre>
  <pre><code>(0 rows affected)
  
  (2 rows affected)
  </code></pre>