All Interzoid products and tools from a single launch point: Quickly solve data challenges - better ROI for everything your data flows into -> See it Now!

High-Performance Azure SQL Data Matching

Identify inconsistent, matching, and duplicate data across your Azure SQL tables in just a few clicks.

A guided, read-only analysis tool that works with Azure SQL Database, Azure SQL Managed Instance, and SQL Server wherever it runs.

Launch the Matching Wizard Read the Documentation
Built for Azure SQL and SQL Server SQL Database, Managed Instance, VMs, On-Premises, RDS, Cloud SQL

Better Data. Better Decisions. No Exports.

The Azure SQL Matching Wizard connects directly to your Azure SQL or SQL Server database in read-only analysis mode, wherever it is hosted. In a guided, step-by-step flow, you'll generate AI-enhanced match reports that surface inconsistent values, redundant records, and duplicate entries across any of your tables, see the cost before you run, and review the results in an interactive spreadsheet view. Parallel processing delivers maximum performance, even on large tables, and the similarity keys in every report load straight back into SQL Server for consolidation with ordinary T-SQL.

Open azure-match.interzoid.com

See It in Action

A quick look at the Matching Wizard experience, from connecting to Azure SQL through reviewing your match report.

Choose Matching Type

Choose Matching Type

Select the type of matching you want to perform: company names, individuals, addresses, and more.

Connect to Azure SQL

Connect to Azure SQL

Pick your deployment type, enter the server name and login or paste the connection string from the portal, and connect in read-only mode over an encrypted connection.

Select Tables and Columns

Select Tables and Columns

Pick a table and the wizard pre-selects the matching columns, previews the data, and counts the rows so you know the cost before you run.

Run and Review Results

Run and Review Results

Run the job and explore the match report in a searchable, sortable spreadsheet view with each match group highlighted, then save it as a file.

Why Teams Use the Matching Wizard

Effortless to Use

A guided wizard walks you through connecting to Azure SQL, choosing your data, and generating a match report. No T-SQL or scripting required.

Read-Only and Safe

The wizard operates entirely in read-only analysis mode. Your Azure SQL data is never modified, making it safe to run against any of your tables, including production databases and readable secondaries.

Connects to Any SQL Server

Presets for Azure SQL Database, Azure SQL Managed Instance, self-hosted SQL Server, Amazon RDS, and Google Cloud SQL fill in the port and SSL settings for you, or paste the connection string straight from the Azure portal. SQL authentication over validated TLS, the same way every major data integration tool connects.

Know the Cost Before You Run

Choose a table and the wizard counts its rows, shows the credit estimate against your balance, and previews the data with your match columns highlighted. No surprises on large tables.

AI-Enhanced Matching

Advanced AI-enhanced similarity algorithms cluster matching records and reveal duplicates and inconsistencies that exact-match queries, LIKE patterns, and SOUNDEX or DIFFERENCE comparisons miss entirely.

Better Data, Better Decisions

Cleaner data means more reliable reporting, better customer insights, accurate joins across systems, and fewer wasted cycles reconciling redundant records.

Parallel Processing for Maximum Performance

A multi-threaded, distributed cloud architecture processes large Azure SQL tables in parallel, delivering match reports fast, even at high data volumes.

Actionable Match Reports

Review results in an interactive spreadsheet view that shades each match group, with search, sorting, and paging across even the largest reports. Save the report as a file, or load the similarity keys back into SQL Server and consolidate with a single JOIN.

How It Works

From connection to match report in three simple steps.

1

Connect to Azure SQL

Choose your deployment type, enter the server name and login or paste a connection string, and connect. A dedicated read-only login is recommended, and the wizard can remember the connection on your browser.

2

Select Tables and Columns

Choose a table; the wizard pre-selects the columns to match on, previews the data, and shows the row count and credit estimate before you commit.

3

Run and Review Results

Run the matching job and explore the AI-enhanced report in an interactive spreadsheet view, with each cluster of matching, duplicate, and inconsistent records highlighted.

Data Matching Example

See the Matching Wizard in action, generating similarity keys to match company and organization name data directly from within Azure SQL tables.

Interzoid match report from a Azure SQL table showing company name variations grouped into clusters by similarity key

Resources

Everything you need to get started, from a sample report to step-by-step documentation.

Sample Match Report

See an example match report for company name data, showing how matching clusters are presented.

View Sample Report

Documentation

Read the complete documentation covering firewall setup, read-only logins, connection options, and matching options.

Read the Docs

Also for PostgreSQL, MySQL and Snowflake

The same guided matching experience is available for PostgreSQL and MySQL databases and Snowflake accounts.

PostgreSQL Matching Wizard

Works With Every SQL Server Deployment

If it accepts a standard SQL Server connection, the wizard can read from it. Azure SQL in every flavor, SQL Server on other clouds, and your own servers.

Azure SQL Database Single databases and elastic pools
Azure SQL Managed Instance Through the public endpoint
SQL Server on Azure VMs
SQL Server On-Premises Any reachable server
Amazon RDS for SQL Server
Google Cloud SQL for SQL Server
Every Current Version SQL Server 2016 and later
Tables and Views Match a filtered view of any size
Readable Secondaries Keep load off production
Encrypted Connections TLS always on, certificate validated
Connection Strings Paste the ADO.NET string from the portal
Read-Only Logins db_datareader is all it needs

No agent to deploy, no linked server to configure, and nothing running inside your database. Point the wizard at a database, schema, and table, and it reads only the columns you select.

What You Can Match

Four data types, plus combinations that raise precision when one field alone is too broad

Organization Names

Resolve Acme Corp, ACME Corporation, and Acme Inc. to a single organization, across the legal suffixes, punctuation, abbreviations, and spelling variations that make company names so inconsistent.

Individual Names

Match James Johnston, Jim Johnston, and J. Johnston as the same person, handling nicknames, initials, middle names, and name ordering.

Street Addresses

Reconcile 400 E Broadway St with 400 East Broadway Street, resolving directional abbreviations, street type variations, unit designations, and spacing.

General Text

Generate similarity keys for other text values, so product names, descriptions, and free-form fields cluster the same way that names and addresses do.

Combination Matching

Require two fields to agree at once: organization with address, organization with individual name, or address with individual name. This separates the Dallas branch from the Phoenix branch while still recognizing that both spell the parent company four different ways.

Similarity Keys and Clusters

Every value receives a key representing the entity behind the text rather than the characters themselves. Records sharing a key are grouped into clusters, which makes each match auditable instead of something to take on faith, and the keys join straight back to your tables.

Frequently Asked Questions

Which SQL Server deployments are supported?

All of them. Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure virtual machines or on-premises, Amazon RDS for SQL Server, and Google Cloud SQL for SQL Server are supported on SQL Server 2016 and later. Tables, views, and readable secondaries can all be matched. If the database accepts a standard SQL Server connection, the wizard can read from it.

Does Interzoid modify my Azure SQL data?

No. Processing issues SELECT statements against the table and columns you choose and nothing else. Nothing is written, updated, or deleted, and no tables, stored procedures, or triggers are created. Results are returned to your browser, and you decide what to do with them.

Do I need to export my data first?

No. Interzoid connects directly to your Azure SQL database and reads the columns you select. There is no CSV export, no staging area, and no copy of your data to secure, track, or delete afterward.

How are my Azure SQL credentials handled?

The wizard uses SQL authentication over a TLS-encrypted, certificate-validated connection, the same way every major data integration tool connects to Azure SQL. Credentials are sent to Interzoid over HTTPS only when a request is made and are never stored by Interzoid. Because processing is read-only, the recommended practice is a dedicated login in the db_datareader role that can be dropped at any time.

My server firewall blocks outside connections. Can I still use the wizard?

Yes, with a small change on your side. Add Interzoid's outbound addresses, listed in the documentation, as firewall rules on your Azure SQL logical server, or to the security group or authorized networks of another deployment. Interzoid connects from fixed addresses, so the rule is narrow and can be removed at any time.

Can I see what a run will cost before I start it?

Yes. When you choose a table, the wizard counts its rows and shows the number of records and the estimated credits alongside your current balance, before you click Run.

How is usage measured?

Each record processed consumes one Interzoid API credit. Trial credits are included with a new API account, so a first table can be matched at no cost, and high volume tables are supported for production workloads.

Can I run this from my own applications instead of the browser?

Yes. The same processing is available as a REST API that can be called from scripts, applications, and data pipelines, which allows Azure SQL matching jobs to be automated without using the browser wizard.

Ready to See What's Hiding in Your Azure SQL Data?

Generate your first match report in minutes. No installation, no code, no changes to your data.

Launch the Matching Wizard Read Documentation

Questions? Contact our team at support@interzoid.com