> For the complete documentation index, see [llms.txt](https://docs.tonic.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tonic.ai/app/generation/database-view/identifying-similar-columns.md).

# Identifying similar columns

During sensitivity scans and schema change scans, Tonic Structural identifies groups of similar columns.

To identify similar columns, Structural uses a text embedding model to calculate the semantic similarity between any two column names in the database. When a column name's semantic similarity  to the name of a given column is above a specified threshold, then the column is similar to the given column.

If a column has similar columns, then the **Applied Generator** column contains an icon that includes the count of similar columns.

<figure><img src="/files/HNiTVFPmsHNiMAs7G6TW" alt=""><figcaption><p>Similar columns icon with the count of similar columns</p></figcaption></figure>

By default, the similar columns icon is hidden. To display the similar columns icon, hover over the column row.

When you assign a generator to a column, the similar columns icon for that column remains visible during your current session.

When you click the similar columns icon, Structural displays a panel with an option to filter the list to display the current column and its similar columns. To apply the filter, click **Filter**.&#x20;

<figure><img src="/files/P8Cxq1L0gD5EVngyBoBa" alt=""><figcaption><p>Similar columns panel with filter option</p></figcaption></figure>

The similar columns filter is applied, and other table and column filters are removed.

<figure><img src="/files/Jf5OGYeQvlALw0PXS4tk" alt=""><figcaption><p>Database View column list with a similar columns filter applied</p></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.tonic.ai/app/generation/database-view/identifying-similar-columns.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.