# Searching for a duplicate in a database

**URL:** <https://air.tableforums.com/t/searching-for-a-duplicate-in-a-database/411>\
**Category:** Airtable Questions\
**Created:** [March 15, 2023, 1:11pm UTC](https://air.tableforums.com/t/searching-for-a-duplicate-in-a-database/411 "2023-03-15T13:11:39Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![bfrench](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/bfrench/32/46_2.png) [@bfrench](https://air.tableforums.com/u/bfrench)\
**Post date:** [March 15, 2023, 8:50pm UTC](https://air.tableforums.com/t/searching-for-a-duplicate-in-a-database/411/3 "2023-03-15T20:50:09Z")

</div>

> [@jhi](#):
>
> We’d like a streamlined process for completing a duplicate record check on our database, accounting for any possible data inaccuracies

We’re probably weeks away from some clever GPT-4 approach to ending the deduping madness that exists in all database systems worldwide.

Using [this basic approach](https://air.tableforums.com/t/suddenly-rows-can-now-have-meaning/386/5), I’d be willing to bet a nice sub sandwich that spotting records that are very close to duplicates is possible with very elegant code that doesn’t need to know anything about the fields or their values.

> [@jhi](#):
>
> The system should leverage fuzzy logic

Fuzzy logic is another way of saying “inference”. 😉

> [@jhi](#):
>
> We’re looking into creating a simple form and the framework searches through a database to find that name or very close names.

The beauty of embedding vectors is they represent a search index for things of likeness.

---

_[View the full topic](https://air.tableforums.com/t/searching-for-a-duplicate-in-a-database/411)._