Search for Arabic text ignoring diacritics, alef hamza differences, and kashida in SQL Server and Oracle
Not sure but based on my understanding, this is related to the language/character set.

I use Oracle database and I do store arabic values within the database.

The character set I use is UTF8, I have also tried storing the different examples provided for the same word and I see it working fine.

I am sure SQL Server also supports such character set.