**Env:**
 
 - MongoDB (3.2.0) with Mongoose


----------


**Collection:**

- users


----------


**Text Index creation:**


      BasicDBObject keys = new BasicDBObject();
      keys.put(&quot;name&quot;,&quot;text&quot;);
    
      BasicDBObject options = new BasicDBObject();
      options.put(&quot;name&quot;, &quot;userTextSearch&quot;);
      options.put(&quot;unique&quot;, Boolean.FALSE);
      options.put(&quot;background&quot;, Boolean.TRUE);
      
      userCollection.createIndex(keys, options); // using MongoTemplate


----------


**Document:**

- {&quot;name&quot;:&quot;LEONEL&quot;}


----------


**Queries:**

- `db.users.find( { &quot;$text&quot; : { &quot;$search&quot; : &quot;LEONEL&quot; } } )` =&gt; FOUND
- `db.users.find( { &quot;$text&quot; : { &quot;$search&quot; : &quot;leonel&quot; } } )` =&gt; FOUND (search caseSensitive is false)
- `db.users.find( { &quot;$text&quot; : { &quot;$search&quot; : &quot;LEON&#201;L&quot; } } )` =&gt; FOUND (search with diacriticSensitive is false)
- `db.users.find( { &quot;$text&quot; : { &quot;$search&quot; : &quot;LEONE&quot; } } )` =&gt; FOUND (Partial search)
- `db.users.find( { &quot;$text&quot; : { &quot;$search&quot; : &quot;LEO&quot; } } )` =&gt; NOT FOUND (Partial search)
- `db.users.find( { &quot;$text&quot; : { &quot;$search&quot; : &quot;L&quot; } } )` =&gt; NOT FOUND (Partial search)


Any idea why I get 0 results using as query &quot;LEO&quot; or &quot;L&quot;?

Regex with Text Index Search is not allowed.


    db.getCollection(&#39;users&#39;)
         .find( { &quot;$text&quot; : { &quot;$search&quot; : &quot;/LEO/i&quot;, 
                              &quot;$caseSensitive&quot;: false, 
                              &quot;$diacriticSensitive&quot;: false }} )
         .count() // 0 results

    db.getCollection(&#39;users&#39;)
         .find( { &quot;$text&quot; : { &quot;$search&quot; : &quot;LEO&quot;, 
                              &quot;$caseSensitive&quot;: false, 
                              &quot;$diacriticSensitive&quot;: false }} )
    .count() // 0 results


----------


**MongoDB Documentation:**

- [Text Search][1]
- [$text][2]
- [Text Indexes][3]
- [Improve Text Indexes to support partial word match][4]


  [1]: https://docs.mongodb.com/v3.2/text-search/
  [2]: https://docs.mongodb.com/manual/reference/operator/query/text/
  [3]: https://docs.mongodb.com/manual/core/index-text/
  [4]: https://jira.mongodb.org/browse/SERVER-15090

All Full Text-Indexing Solutions on Gang of Coders

Total of 1 Full Text-Indexing Solutions

MongoDB Full and Partial Text Search