Fuzzy Matching In Access (1 Viewer)

VSCurtis

New member
Local time
Today, 10:53
Joined
Mar 8, 2021
Messages
5
Hi Guys,

I'm hoping someone here can help me with a "Fuzzy Matching" solution to my problem. I'm designing a Media Database. The source for my data is a data dump from iTunes imported into an Access table named Music. This table contains raw data that has not been scrubbed. The Name field contains the song title. Scrubbed song titles are contained in a lookup table named lkpSongTitle in the field named Description. These titles are similar but not exact matches. I have been able to match up a lot of them but there are still about 250 records that don't match up. The manual process I'm using is starting to wear my nerves thin. I would like to create a query that shows the unmatched title names from the Music table and then display the record from the lookup table that is the mostly likely match for that song title. Is this possible? I would appreciate any help you can provide. Thanks In Advance.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:53
Joined
May 7, 2009
Messages
19,169
Search soundex or lavenheight vba code.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 10:53
Joined
May 21, 2018
Messages
8,463
I did a few different versions, but found the most practical was a find as you type over the others.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 07:53
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to AWF!

I think Arnel meant Levenshtein Distance.
 

Users who are viewing this thread

Top Bottom