"FuzzBox correctly matched millions of problematic records"
- Telecom CIO

Fuzzy Logic Matching

Algorithm Example Apps: Misspelled Fuzzy Lookup

Misspelled Fuzzy Lookup | Full Results Fuzzy Search Algorithm | Business Data Fuzzy Lookup | Genetic Sequence Fuzzy Search

Enter the name of any country in the world and FuzzBoxTM will match it
correctly with Fuzzy Lookup even if you completely misspell it!

Fuzzy Lookup - Countries

9United Arab Emirates
6United States
6United Kingdom
3Saudi Arabia

Why you need Fuzzy Logic/Approximate String Matching
If you have even just 100 records in your database or spreadsheet you need to clean up and it took a person just 10 seconds to compare one record against another manually to figure out what to do with it, it would take 1,000 seconds to deal with one single record (compare it against the other 99 records). So comparing all 100 records to each other would take 100,000 seconds - 27 hours. So if you have 1,000 records to clean up, that would take 2,777 hours! That would be one person working 69 weeks on it full time. This enormous amount of work is not obvious until you break it down like this. This is why you need fuzzy logic matching.

Problem 1. Your Database Has Dirty Data!
What happens when your database doesn't refer to the same item the same way? Your website, applications and systems do not work properly and you lose productivity and business. Our FuzzBoxTM fuzzy search application can help match and clean up dirty data.

Problem 2. You Have Slightly Different Duplicate Data!
Exact duplicates are easy to find but what about items which are just slightly different? These are much harder to deal with and cause many headaches. Your website, applications and systems will run much more efficiently and increase productivity when you remove slightly different duplicate data. Our FuzzBoxTM fuzzy lookup application can help you do this.

Problem 3. People Misspell Things!
It is a fact of life. What happens when someone (an employee or a customer) misspells an item when they search your website or database? Nothing shows up even when you do in fact have the item and you lose productivity and business. Our FuzzBoxTM fuzzy matching app can help match misspelled words.


FuzzBoxTM Works Everywhere! We can implement FuzzBoxTM on your website, within your app/system or in the cloud. We will help you identify the best way to get the job done.

FuzzBoxTM Is Flexible! FuzzBoxTM can work on any data, (e.g., a website, database fields, records, tables, Excel spreadsheet data, unstructured data, web pages, etc.) or any other data source. FuzzBoxTM can work on one or more fields/columns in a database and either change those fields to the correct data or create a new field/table with the correct or matching data.

FuzzBoxTM Supports Aliases! Sometimes data you are trying to match has no good logical relation and is usually impossible to match even with great fuzzy matching. This is where "user definable aliases come in." For example, in its most simple form you can tell FuzzBoxTM that "st" or "st." means "street" and it will match. However, in more complicated scenarios, aliases really shine. For example, you can tell FuzzBoxTM that "AB" means "after birth" or that "pre" means "pre-order." There is no limit to how many aliases you can use in FuzzBox.TM

FuzzBoxTM Supports Real-Time Substitution Lets say you want to change all occurrences of a given match to something else to clean up your data. In a simple example, you can tell FuzzBoxTM to replace all occurrences of "st." with "Street." In more complex scenarios, you can tell FuzzBoxTM to append or prepend a code to a match. For example, you can append prepend a code prefix such as ABC to all matches or add an "*" to certain matches to indicate a certain criteria for later use. Now, you can do this most databases however, when you do it in connection with fuzzy logic matching it becomes more powerful. FuzzBoxTM will even let you make substitutions on the fly when data is entered for cleaner data. No garbage in = no garbage out.

Better Than Excel Fuzzy Logic Formulas! We get customers all the time who have tried to do fuzzy logic matching with Excel and were not able to. FuzzBoxTM uses a better programming language than what Excel uses for pattern matching so the results are superior. Stop wasting time with a system that cannot do what you need!

FuzzBoxTM Works On Unstructured Data! Most databases and Excel work only on data inside a database or spreadsheet but what about data that is not in a database like text files, documents, web pages, etc? FuzzBoxTM will work on any data source whether the data is inside or outside of a database.

Imagine the increase in PRODUCTIVITY AND BUSINESS you would have with fuzzy search! To incorporate fuzzy matching in your application/Website and stop losing business Contact Us