My friend, with whom we talk in English, had a misfortune, and I tried to think of something I could say to him to support him. I'm afraid my English level is not that good at the moment.

I also think that this is the most convenient and suitable option. In any case, I always look for different words, phrases on the Internet if I need to quickly find a suitable answer. I advise you this article https://promova.com/blog/comforting-words-what-to-say-in-tough-times. I think that this is the most ideal option for you in this situation.