title: sql server full text search multiple value contains
body: <p>Im using full text search to find rows that have a word near another word, like:</p>
  
  <pre><code>select *
  from mytable where
  contains (mycolumn, 'someword1 near someword2')
  </code></pre>
  
  <p>From now on, my input will be a table, like:</p>
  
  <pre><code>declare @words table  
  ( 
      word varchar(100) not null 
  ) 
  
  insert into @words (word) values ('someword1') 
  insert into @words (word) values ('someword2') 
  insert into @words (word) values ('someword3') 
  </code></pre>
  
  <p>Is it possible to rewrite the query to get the same result, or I ll need to transform the @words rows in a single line of text?</p>