title: SQLite: Should LIKE 'searchstr%' use an index?
body: <p>I have a DB with several fields </p>
  
  <pre><code>word_id — INTEGER PRIMARY_KEY
  word — TEXT
  ...
  </code></pre>
  
  <p>..and ~150k rows.</p>
  
  <p>Since this is a dictionary, I'm searching for a word with mask <code>'search_string%'</code> using LIKE.
  It used to work just fine, taking 15ms to find matching rows. The table has an index for a field <code>'word'</code>. 
  Recently I've modified the table (some fields of that table which are out of the scope) and something happened — it's taking 400ms to execute query, so I understand that as it fails to use index now. 
  Straightforward query with = instead of like shows 10ms result. 
  Does someone have an idea what's happening here?</p>