thanks a bunch... will implement it and check, hope this will work as you have mentioned :)

but the mis spelled words problem is still unresolved.

For this question it is about the unique value to be check with in-casesensitive. So that you can handle through the odoo constraint instead sql.

But for to check spell of word you need some library to work around this like 'textblob'

Example,

from textblob import TextBlob

a = "cmputr" # incorrect spelling

print("original text: "+str(a))

b = TextBlob(a)

# prints the corrected spelling

print("corrected text: "+str(b.correct()))

So you can use this kind of technique in odoo and use your custom development.

is there any spell check like module/library to prevent user from t his type of mistakes? at least we can inform him/her for this mistake.