title: Keyword search using PostgreSQL
body: <p>I am trying to identify observations from my data using a list of keywords.However, the search results contains observations where only part of the keyword matches. For instance the keyword <code>ice</code> returns <code>varices</code>. I am using the following code </p>
  
  <pre><code>select * 
  from mytab
  WHERE myvar similar to'%((ice)|(cool))%';
  </code></pre>
  
  <p>I tried the <code>_tsquery</code> and it does the exact match and does not include observations with <code>varices</code>. But this approach is taking significantly longer to query. (2 keyword search for similar to <code>'% %'</code> takes 5 secs, whereas <code>_tsquery</code>takes 30 secs for 1 keyword search.I have more than 900 keywords to search)</p>
  
  <pre><code>select * 
  from mytab
  where myvar @@ to_tsquery(('ice'));
  </code></pre>
  
  <p>Is there a way to query multiple keywords using the <code>_tsquery</code> and any way to speed the querying process. </p>