|
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?
|
|
|
|
|
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.
|
|
|
|