Guus2005
AWF VIP
- Local time
- Today, 12:06
- Joined
- Jun 26, 2007
- Messages
- 2,642
Tom van Stiphout created a (dll) library for the Simil function he wrote.
I can't use dll's with my customer so following the provided table i have concocted a VBA equivalent.
In the table the word "Pennsylvania" is matched with the word "Pencilvaneya" which is a 67% match. Pen(length 3), lvan(length 4) and a(length 1) appears in both strings. (3+4+1)*2/24 (total length)
The Simil function is case sensitive but if you convert both strings to lowercase you can circumvent that. You can also change Option Compare Binary into Option Compare Database in the VBA code.
Here's the sample database.
BTW it's a 2010 sample database. Look in de code repository for the code.
Share & Enjoy!
I can't use dll's with my customer so following the provided table i have concocted a VBA equivalent.
In the table the word "Pennsylvania" is matched with the word "Pencilvaneya" which is a 67% match. Pen(length 3), lvan(length 4) and a(length 1) appears in both strings. (3+4+1)*2/24 (total length)
The Simil function is case sensitive but if you convert both strings to lowercase you can circumvent that. You can also change Option Compare Binary into Option Compare Database in the VBA code.
Here's the sample database.
BTW it's a 2010 sample database. Look in de code repository for the code.
Share & Enjoy!
