title: Postgresql: Combining similarity with tsvector
body: <p>I got a database table containing more than 50 million records
  which i need to full text search as fast as possible.</p>
  <p>On a smaller table i just had a index on the text column and i use the similarity function to get similar results. I was also able to sort by the result of similarity().</p>
  <p>Now, after my table is a lot bigger, i switched to tsvector. I created a column for the tsvector result and a trigger which updates the column before insert or update. After that i can search ultra fast (&lt;100ms).</p>
  <p>The problem is that i would like to use a combination of both tsvector and similarity.</p>
  <h2>Example</h2>
  <p>My table contains the following data.</p>
  <pre><code>| MyColumn |
  ------------
  | Apple    |
  | Orange   |
  | ...      |
  </code></pre>
  <p>But if i search for &quot;App&quot; i don't get &quot;Apple&quot; back.</p>
  <p>Any ideas on how to get a fast &quot;like/similar&quot; search with a &quot;score/similarity&quot; score ?</p>