10

Does MongoDB support soundex or fuzzy matching? I want to spot dupes of basic contact name and address fields. I'm using the official C# driver. Thanks

Dori
  • 915
  • 1
  • 12
  • 20
Journeyman
  • 10,011
  • 16
  • 81
  • 129
  • read this article [How to perform fuzzy matching with mongo connector](https://www.mongodb.com/blog/post/how-to-perform-fuzzy-matching-with-mongo-connector) – sarfarazsajjad Dec 08 '18 at 13:08

1 Answers1

8

Mongodb doesn't support soundex matching, but it has Full Text Search.

Also,

You can always just store the soundex-encoded string in a separate field in mongo and search against that. Soundex is a really trivial algorithm and should only take a handful of lines.

-- from mongodb-user

Dan Dascalescu
  • 143,271
  • 52
  • 317
  • 404
Andrei Andrushkevich
  • 9,905
  • 4
  • 31
  • 42
  • 3
    MongoDB has no real fulltext search. Pattern matching is no fulltext search. –  Apr 13 '11 at 15:00
  • You should have quoted the followup of your quote...sorry but using soundex for this purpose is just a bad idea. –  Apr 13 '11 at 17:05
  • 3
    @AndreasJung: in the meantime MongoDB has implemented FTS. Let's delete our comments. – Dan Dascalescu May 13 '14 at 04:00