MongoDB Full and Partial Text Search

by

As at MongoDB 3.4, the text search feature is designed to support case-insensitive searches on text content with language-specific rules for stopwords and stemming. Stemming rules for supported languages are based on standard algorithms which generally handle common verbs and nouns but are unaware of proper nouns.

There is no explicit support for partial or fuzzy matches, but terms that stem to a similar result may appear to be working as such. For example: “taste”, “tastes”, and tasteful” all stem to “tast”. Try the Snowball Stemming Demo page to experiment with more words and stemming algorithms.

Your results that match are all variations on the same word “LEONEL”, and vary only by case and diacritic. Unless “LEONEL” can be stemmed to something shorter by the rules of your selected language, these are the only type of variations that will match.

If you want to do efficient partial matches you’ll need to take a different approach. For some helpful ideas see:

There is a relevant improvement request you can watch/upvote in the MongoDB issue tracker: SERVER-15090: Improve Text Indexes to support partial word match.

More Related Contents:

  1. Group result by 15 minutes time interval in MongoDb
  2. Does MongoDB’s $in clause guarantee order
  3. $lookup on ObjectId’s in an array
  4. Moongoose aggregate $match does not match id’s
  5. Find in Double Nested Array MongoDB
  6. Return only matched sub-document elements within a nested array
  7. Converting string to date in mongodb
  8. Check if every element in array matches condition
  9. MongoDB nested lookup with 3 levels
  10. Get a count of total documents with MongoDB when using limit
  11. Include all existing fields and add new fields to document
  12. Matching ObjectId to String for $graphLookup
  13. mongodb count num of distinct values per field/key
  14. Mongodb Join on _id field from String to ObjectId
  15. Mongodb aggregation lookup with conditions
  16. How to get back the Original document back after aggregation
  17. MongoDB lookup when foreign field is an array of objects
  18. MongoDB: Calculate dwell time between every status value change
  19. Search on multiple collections in MongoDB
  20. Remove Duplicates from MongoDB
  21. Get n-th element of an array in MongoDB
  22. How to access overall document count during arithmetic aggregation expression
  23. How do I rename fields when performing search/projection in MongoDB?
  24. mongodb aggregation framework match by nested documents
  25. count array occurrences across all documents with mongo
  26. $project in $lookup mongodb
  27. Return actual type of a field in MongoDB
  28. Mongodb, aggregate query with $lookup
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. Return the last “true” value for each group

Leave a Comment