I'm trying to check for duplicate bame in SQL Server.

Table **Company**:

```
   CompanyName            | Business
   -----------------------+----------
   Example Company INC    | Telecom 
   The Example Company    | Telecom

```

I want to get the both of the company name as duplicate. using the parameters "The Example Company INC".

When I use 

```
SELECT CompanyName 
FROM COMPANY 
WHERE CompanyName LIKE '%The Example Company INC%' 

```

it show no results. The query must return 2 records - is this possible?