fuzzy search

Hi, Anybody experience with setting up fuzzy search functionality? We need to compare names to identify potential matches/duplicates. We know of quite some database functionality to apply in these cases, but anyone implemented something like this in Mendix? Note that it is not required/necessary (would be nice in some situations) that the fuzzy search is incorporated in the standard mendix search functionality. Kind regards, Brian
1 answers


For this purpose I have used Lucene to index the data and allow the fuzzy searching. Lucene allows for fuzzy searches for example search for roam~ will return roam, foam, roams etc. This however takes quite some work to setup and integrate and can't be directly integrated into the standard search fields. We used it to display in screens and in the index.html (custom build widget & Mendix+Java work).

Hope this gives you an idea.