Only now I saw your comment.

Today the root חמד means lovely or cute or nice.. Quite a moderate meaning.

In the "Song of songs" you quoted the meaning (as it understood from the text and the context) is much more intensive and means attraction or passion or desire.

I was impressed from what you commented that in Arabic, the equivalent refers somehow to the God and to the love to him (I don't speak Arabic).

In this context - it isn't: the text talks about a love and attraction between a man and a woman, and the God is not mentioned in this book.

Of course, the Jewish religious tradition will say that this is just an allegory and it is about the love between the people of Israel and the Bible; but you can understand what do I think about it. :-)

You are right- in the Bible the God is treated many times in plural, mainly אלוהים & אדוני.

Those names (in plural) are used also in spoken language.

Apart of those two I don't remember other options, and all the verbs and adjectives related to them are in singular.

I am not sure I understood your question: what has the word מחמדים to do with the God?

I don't remember it as one of his (many) names.

The singular of מחמדים is מחמד as you said, this is a very literary word, so you might find it in expressions, verses from the Bible, etc.

@Geri