You are not wrong to sing, “Jesus is the sweetest name I know,” even though Yahweh is.
God gave himself the name Yahweh. No man gave him this name. It is God’s chosen personal name. He loves to be known by this name. It is used over 5,000 times in the Old Testament. It is almost always translated by Lᴏʀᴅ (small caps). But it is not a title. It is a personal name, like James or Elizabeth.
You know the name Yahweh best from its shortened form Yah at the end of Hallelujah, which means “praise Yahweh.” I love to think about this when I sing. When I sing, “Hallelujah,” I love to really mean, “No! I don’t praise you Bel, or Nebo, or Molech, or Rimmon, or Dagon, or Chemosh. I turn fr…