Excel VBA, a kind of fuzzy match -

i want automate script in excel vba , stuck.

i have string = "the patient population x. this, lot of patients males. particular male patint has 3 deadly diseases." (the strings longer)

now want search how many times word "patient" appears in string if words have spell problems , how written.

my ideea let`s match confidence of 80% word "patient" words in string , result aiming .. there 3 matches , words in string :"patient","patients","patint ". there way this?

the concept looking called "full text search".

i'm not 100 % sure, think not native in excel nor vba. best knowledge not ms access supports this.

check out add-in suggested alex k or @ embedding real database in app.