Select like and unlike record pattern SQL
Assuming that your file column is unique, you can do this:

SELECT
REPLACE(file, '.delete.', '') AS file
FROM your_table
GROUP BY REPLACE(file, '.delete.', '')
HAVING COUNT(*) = 1


You "delete" the ".delete." and then return only the rows that don't appear multiple times.