I want to make a dictionary and I need to have a query that can find words with misspelling (I mean Typos / spelling error or typo), if the query could not find exact word then try to get with other spellings...
So what is Arabic: In Arabic there are some letter with (almost) same pronunciation but different letter, people sometimes don't know which one should use. For example there are 4 kind of Z in Arabic "ز / ظ / ذ / ض" pronunciation are different (a little) but people will forgot which one is the correct spelling. an example of one word with different using of "z" letter:
مریز / مریض / مریظ / مریذ
The correct is مریض
Here are other worlds that has more than one latter:
z: ض / ز / ذ / ظ
T: ت / ط /
S: ث / س / ص /
Gh: ق / غ
So what is your idea? How should be the query?
I want if a user searched for "مریز" instead of showing him an error of 404 (not found) search the database with other letter (all Z) then return result if I found anything.