Hi guys
quick question; I'm developing an app to allow users to create new items on our database. I want to do some fuzzy matching across the inputted name to help avoid near duplicates being added - is there any way to do this within WM?
Ideally I'd like to be able to search with substitutions as well, so ABC Pension Scheme would match with ABC Pension Sch / ABC Pen Scheme / ABC PS.
thanks for your help.
quick question; I'm developing an app to allow users to create new items on our database. I want to do some fuzzy matching across the inputted name to help avoid near duplicates being added - is there any way to do this within WM?
Ideally I'd like to be able to search with substitutions as well, so ABC Pension Scheme would match with ABC Pension Sch / ABC Pen Scheme / ABC PS.
thanks for your help.
RE: Fuzzy Matching
I think you will need to do this sort of checking on the database, as you will not want to extract all the records to then compare them.
This is not something that I have done before, but from a quick search there seem to be a few different options. Eg
http://stackoverflow.com/questions/921978/fuzzy-matching-using-t-sql
http://blog.hoegaerden.be/2011/02/05/finding-similar-strings-with-fuzzy-logic-functions-built-into-mds/
I think you will likely need to customize the built in capabilities to support the substitution capability you are looking for though.
Sorry I can+?+?+?t give any more specific advice on this, but please let me know how you get on.
Regards,
Gerard