Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2016, 10:37 PM
paik1002 paik1002 is offline Find a fuzzy match of a sentence. Windows 7 64bit Find a fuzzy match of a sentence. Office 2010 64bit
Advanced Beginner
Find a fuzzy match of a sentence.
 
Join Date: Dec 2015
Posts: 63
paik1002 is on a distinguished road
Default Find a fuzzy match of a sentence.

I'd like to match and convert each sentence of the document to a dummy text in a given database (i.e. word file), that gives the closest hit probability. The dummy database can be a user generated list of texts, so it is neither definite nor set.

For example:
Sentence to be converted: Hello there, how are you doing?

A list of dummy (but not) text strings:
1. Hello here, how are you doing? (this is the closest match of course)
2. Hello ere, how are you doing?
3. ello here, how are you doing?



The converted result: Hello here, how are you doing?

Can it be done?
Reply With Quote
  #2  
Old 02-18-2016, 03:51 PM
macropod's Avatar
macropod macropod is offline Find a fuzzy match of a sentence. Windows 7 64bit Find a fuzzy match of a sentence. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

With enough code, almost anything's possible. Rather than trying to build this in VBA, you'd do better to look for a commercial application that's already be developed to do this kind of thing. A web search for "fuzzy matching software" will get you started.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find a fuzzy match of a sentence. End of sentence puncuation. nrsmd Word 2 07-04-2015 10:33 PM
Find a fuzzy match of a sentence. Delete does not bring second sentence closer to first sentence Andoheb Word 29 07-03-2014 01:48 PM
Find a fuzzy match of a sentence. First word of sentence IF and then awolf Word VBA 7 03-16-2014 02:40 PM
Find/Replace, Duplicating a word in a sentence to hundreds of sentences. DDDD Word 0 10-08-2013 10:48 AM
Find a fuzzy match of a sentence. Insert text at the end of a sentence Find/Replace AlmostFriday Word 6 06-17-2012 05:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft