MStardict and QStarDict are just viewers for certain format dictionaries. They work perfect without data connection.
There are many different dictionaries for these viewers - some of them giving you meaning of a word(e.g. Oxford English dictionary) or giving you translation(e.g. German - English).
I am afraid you have to describe what exactly are you searching for. I think you just have to download the desired dictionary(type&language).