Fuzzy search algorithm

D

dsc

Anybody know where I can get some info on a fuzzy search algorithm in VBA?

Thanks for any assistance.
 
P

Perry

What kind of search are we speaking about?

Searching for files?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/htm
l/deovrthebasicsoffilesearching.asp
or
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html
/deconreturningfilesfromfilesystem.asp

Searching in text a Word document?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd10/htm
l/woprofind.asp
or
http://www.mvps.org/word/FAQs/MacrosVBA/ReplceTextWithDoc.htm

Or are you looking for other search mechanisms/algorithms?

Krgrds,
Perry
 
D

dsc

Perry said:
What kind of search are we speaking about?

I call an Access database table from Word, search for a selected string,
then display results in a listbox.

I can search for exact matches, and using the "like" operator can do
wildcard searches.

That's not good enough for the boss. He wants a "true fuzzy search
capability," involving matches on chars in the string in the right order, in
the wrong order, matching 4 of 14 chars, 5 of 20 chars, etc.

For instance, if the selected string is, "When, in the course of human
events, it becomes necessary," he wants something that will return hits on:

When on a golf course
When necessary, self destruct
It is necessary when baffled to waffle
The magazine Human Events is not widely read

et cetera, et cetera, et cetera, and selectable so you can make the search
more or less permissive.

I'm not even sure this is doable in VBA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top