Introducing our Snowflake Data Cloud Native Application: AI-Driven Data Quality built into SQL statements! Learn More

Examples of Catching Duplicate, Inconsistent Company Name Data with an API

by Interzoid Team


Posted on January 14th, 2020


Examples of Catching Duplicate, Inconsistent Company Name Data

No great companies were ever built on a foundation of bad data assets. And since we have very little control over how customer, prospect, or other textual data is collected at its source, there is a good chance you are working within an organization on such a foundation where data quality could be significantly improved.

There are many examples of data quality challenges for an organization to overcome. One, our focus here, is the difficulty of dealing with inconsistent company/organizational name data, such as the following:

IBM, International Business Machines, ibm, I.B.M.
Forever 21, Forever Twenty-one, forever21
G.E., General Electric, Gen Electric
Johnson & More, Johnston and Moore Attys at Law
San Jose Memorial Hospital, Med Center of San Jose (Mem Hospital)

Inconsistent company/organization names like these in your databases can cause significant problems, such as:

- duplicate company records
- data and contacts spread across multiple records
- inaccurate data analysis
- difficult to match across data sources
- faulty-decision making
- increased data management costs
- inefficient business processes
- missed opportunities


Interzoid has created a similarity key generation capability that greatly simplifies and can even solve these challenging data issues.


Our API generates a similarity key from a company name that is algorithmically designed to eliminate the inconsistency in the data content. Here are some examples of generated similarity keys:

Similarity key generation example for a company name matching API


Then, data can be matched or sorted using these similarity keys rather than the data itself, resulting in dramatically higher match rates and identification of duplicate company names.

Using Interzoid's Company Name Match API, you can:

✔ Eliminate redundant and duplicate data from customer and important databases
✔ Leverage data content-specific matching algorithms for higher matching success rates
✔ Improve the accuracy of data analysis activities with better, more accurate foundational data
✔ Be more cost-effective with customer communications and marketing campaigns
✔ Utilize fuzzy matching to match company data across datasets
✔ Enable fuzzy searching for better, more comprehensive search results
✔ Achieve greater ROI with business intelligence investments
✔ Leverage growing AI-based knowledge bases of matching and ambiguous data identification
✔ Reduce costs associated with redundant, duplicate data
✔ API-based solution enables full customization of data matching strategies
✔ Similarity keys easily are leveraged within a broad range of applications
✔ Easy to get up-and-running with immediate results
✔ Pay-as-you-go pricing makes it easy to get started

Sign up for an Interzoid account and you will receive automatic trial credits to take the API for a test drive.



Sample Matches Found Using Similarity Keys:

U-Haul
Uhaul Trailers

Costco Stores
cost-co

McKeson Corp
Mackesson

San Jose Hospital
Regional Medical Center of San Jose
san jose med ctr

Well's Fargo Bank
Wells Fargo

Nationwide Insurance
Nation Wide Ins.

PFIZER INC
Fizer

Forever 21 Inc.
FOREVER TWENTY-ONE

Biogen Pharma
The Biogen Corp

7-11
7-eleven
Seven Eleven Stores

Arctic Flooring Inc
Artic Floors

USX Corp
United Steel

Glaxo Smith Klein
GSK Pharmaceuticals

San Deigo Chemical
SD Chem
San Diego Chemical Corp

10k investments
Ten K Investment

Jackson Wines
Jaxon Winery Inc.

5 Penn Plaza Inc.
Five Pennsylvania Plaza

Cranston Inc.
The Cransten Corp
Cranstin Company

Hilton Hotels
Hillton Resorts Inc.

Perez Telecommunications Inc
peres telcom

Mary's Cookies
Marys Cookie Shop

High Top Brewing
Hightop Breweries

The Johnson Rehab Center
Johnsen Rehabilitation

Midland Loan Services
Mid-land Savings & Loan
Midland Banking Svcs

Equity Real Estate Investments
$Equity Realtors

Saint Francis Mem (main)
St. Francis Memorial Hospital

See our Snowflake Native Application. Achieve Data Quality built-in to SQL statements.
Identify inconsistent and duplicate data quickly and easily in data tables and files.
More...
Connect Directly to Cloud SQL Databases and Perform Data Quality Analysis
Achieve better, more consistent, more usable data.
More...
Try our Pay-as-you-Go Option
Start increasing the usability and value of your data - start small and grow with success.
More...
Launch Our Entire Data Quality Matching System on an AWS EC2 Instance
Deploy to the instance type of your choice in any AWS data center globally. Start analyzing data and identifying matches across many databases and file types in minutes.
More...
Free Usage Credits
Register for an Interzoid API account and receive free usage credits. Improve the value and usability of your strategic data assets now.
Automate API Integration into Cloud Databases
Run live data quality exception and enhancement reports on major Cloud Data Platforms direct from your browser.
More...
Check out our APIs and SDKs
Easily integrate better data everywhere.
More...
Example API Usage Code on Github
Sample Code for invoking APIs on Interzoid in multiple programming languages
Business Case: Cloud APIs and Cloud Databases
See the business case for API-driven data enhancement - directly within your important datasets
More...
Documentation and Overview
See our documentation site.
More...
Product Newsletter
Receive Interzoid product and technology updates.
More...