You can also use some of the fuzzy matching expression.
Here an example using soundex:
As expression I am using $id = array_first(array_agg($id,soundex("name"))), which groups names by their soundex representation and only returns the first one (ordered by their feature id) of each group. To illustrate here a gif using select by expression:. However, this will not take the distance of features to each other into account, so one of two "Hospital" on the other side of the earth will be selected. For a solution taking this into account, see my Python solution.
Also take a look at hamming_distance, levenshtein or longest_common_substring:
