ACL vs SQL for fuzzy matching
-
We are discussing a new project that will do lots of word matching, including some fuzzy logic in the matching. We are deciding between using SQL and ACL for this job, and I've been told that SQL has more fuzzy logic facilities than ACL. Anyone know about this or what the additional fuzzy facilities are? Thanks in advance - Ben
-
We are discussing a new project that will do lots of word matching, including some fuzzy logic in the matching. We are deciding between using SQL and ACL for this job, and I've been told that SQL has more fuzzy logic facilities than ACL. Anyone know about this or what the additional fuzzy facilities are? Thanks in advance - Ben
That's a pretty broad assumption. What variant of SQL database are you talking about here, because different engines have different features?
*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington
"Mind bleach! Send me mind bleach!" - Nagy Vilmos
CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier
-
That's a pretty broad assumption. What variant of SQL database are you talking about here, because different engines have different features?
*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington
"Mind bleach! Send me mind bleach!" - Nagy Vilmos
CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier
Currently we're using Microsoft SQL Server 2008 but could upgrade to the latest for this project.
-
Currently we're using Microsoft SQL Server 2008 but could upgrade to the latest for this project.
At the most basic, you're talking about Soundex matching, which isn't great. You might want to consider Full Text Indexing, which will return misspelled items if they are close enough. Of course, you can always implement your own fuzzy logic inside SQL Server, using CLR functions.
*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington
"Mind bleach! Send me mind bleach!" - Nagy Vilmos
CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier