title: Multi-word CONTAINS full-text search only working partially in SQL Server
body: <p>I'm using SQL Server 2012 and have created full-text index for NAME column in COMPANY table. All the searches I've tested are of the following format (with variable number of words to search), matching by beginnings of words in any order:</p>
  
  <pre><code>select id, name from company where contains(name, '"ka*" AND "de*"')
  </code></pre>
  
  <p>The problem is that there are cases where this query doesn't return any results even though it should be perfect match. For example when company name is "ka de we oy", the example above returns a match but '"ka*" AND "de*" AND "we*"' does not and neither does searching with all the four 'words'.</p>
  
  <p>There are also other cases where, strangely enough, the search does not return results even with exact words. This seems related to very short (two-letter) words. There are also some issues with searching with many (6+) words.</p>
  
  <p>Is there some explicit restriction to the number of words in a single query or how short they can be? How can I fix or work around this?</p>
  
  <p>Edit: it seems to be certain common English words which are entirely excluded from the index (like 'we' in the example). This is an issue since it's a requirement that a few of the common words definitely should be searchable. Is there any way to change which words are not indexed or e.g. change the 'language' of the indexing to apply different set of common words that are left out?</p>