Database

You must Sign In to use this message board.

Search this forum
	Profile popups Spacing Noise Layout Per page

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
Sign In·Permalink

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
Sign In·Permalink

Currently we're using Microsoft SQL Server 2008 but could upgrade to the latest for this project.
Sign In·Permalink

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

General News Suggestion Question Bug Answer Joke Rant Admin

		9,890,640 members (45,427 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using