Any ideas on how to implement fuzzy search in strapi (with mysql)?
My users will import through cut and paste a large string that will contain company names.
I’m looking to implement fuzzy search for a small PHP/MySQL application. Specifically, I have a database with about 2400 records (records added at a rate of about 600 per year, so it’s a small database). The three fields of interest are street address, last name and date. I want to be able to search by one of those fields, and essentially have tolerance for spelling/character errors. i.e., an address of “123 Main Street” should also match “123 Main St”, “123 Main St.”, “123 Mian St”, “123 Man St”, “132 Main St”, etc. and likewise for name and date.
I have two data frames with each having a different number of rows. Below is a couple rows from each data set