FIltering out of text based on certain criteria ( Certain words, even if spelt wrongly )

[Joeygreedy]

For example, in Indonesian, the word is "Police" and various variations of the word, from Polis, Police, Muspika etc. Is there a way for Excel to recognize similar words based on the original word ( Such as being able to recognize Polis as a variation of Police ) based on the similar letters and automatically include it in an advanced filter searching for the word "Police".
Additionally, what about if the abbreviation is unrecognizable, such as it being shortened to "Police" or "Polrek" or other hard to recognize slang, ESPECIALLY if it's in a foreign language that google translate does not recognize due to it being slang.

 

[Peter_SSs]

Welcome to the MrExcel board!

This appears really to be the same concept question as to: Using Excel to find variable abbreviations and create a standardised document

Please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

Please continue in the linked thread.