Oracle APPS SQL : Match Patterns

Sometimes names will be written differently 

For example :Chendra,Chandra,Chondra',But the name is same .

How to identify these names using SQL statements .

The | pattern tells us to look for the letter "o", "e", or "a". 

The  Oracle REGEXP_LIKE condition example that we will look at involves using the | pattern.

SELECT last_name
FROM hr_contacts
WHERE REGEXP_LIKE (last_name, 'Ch(o|e|a)ndra');

By using above expression we can acheive the expected results