Fuzzy Searching with Mongodb?

by

I believe that to do “fuzzy” search you will need to use regex. This should accomplish what you’re looking for (escapeRegex function source here):

function escapeRegex(text) {
    return text.replace(/[-[\]{}()*+?.,\\^$|#\s]/g, "\\$&");
};

router.get("https://stackoverflow.com/", function(req, res) {
    if (req.query.search) {
       const regex = new RegExp(escapeRegex(req.query.search), 'gi');
       Jobs.find({ "name": regex }, function(err, foundjobs) {
           if(err) {
               console.log(err);
           } else {
              res.render("jobs/index", { jobs: foundjobs });
           }
       }); 
    }
}

That being said, your application can experience performance issues when querying mongo by regex. Using a library like search-index for search could help optimize your application’s performance, with the added benefit of searching word stems (like returning “found” from “find”).

UPDATE: My original answer included a simple regular exression that would leave your application vulnerable to a regex DDoS attack. I’ve updated with a “safe” escaped regex.

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. Find document with array that contains a specific value
  3. Moongoose aggregate $match does not match id’s
  4. What’s Mongoose error Cast to ObjectId failed for value XXX at path “_id”?
  5. Node.js Mongoose.js string to ObjectId function
  6. Cascade style delete in Mongoose
  7. pushing object into array schema in Mongoose
  8. Mongoose Unique index not working!
  9. How to push an array of objects into an array in mongoose with one call?
  10. Find MongoDB records where array field is not empty
  11. How do you use Mongoose without defining a schema?
  12. How to access a preexisting collection with Mongoose?
  13. How do I query for distinct values in Mongoose?
  14. Creating Multifield Indexes in Mongoose / MongoDB
  15. Exception: can’t convert from BSON type EOO to Date
  16. MongoDB: output ‘id’ instead of ‘_id’
  17. How can I update multiple documents in mongoose?
  18. How to return just the nested documents of an array from all documents
  19. MongoDB: Calculate dwell time between every status value change
  20. Mongoose’s find method with $or condition does not work properly
  21. Image returned from REST API always displays broken
  22. Mongoose limit/offset and count query
  23. Can’t find documents searching by ObjectId using Mongoose
  24. Mongodb aggregation $group, restrict length of array
  25. Mongoose: deep population (populate a populated field)
  26. getting schema attributes from Mongoose Model
  27. querying a collection without passing schema in mongoose
  28. $project in $lookup mongodb
  29. MongoDB count() versus countDocuments()
  30. Mongodb, aggregate query with $lookup

Leave a Comment