@braghadish, it is absolutely not clear what you want to achieve.   In your first post you wrote:  "I need to remove the names if the name has a Same Sound ex ". Later you wrote:  " I need all the names to be pulled out".         And          : "The purpose of the duplicate logic is to bypass claims which have already been submitted/processed".   It will be helpfull if you post an example of your claims data - few lines with the most relevant variables,  and post the wanted output  for that example.    The soundex function is just a tool that helps to match similar names.  You have to clarify your input and wanted output dataset formats.   ... View more