"How Sweet the Name of Jesus Sounds" was written by John Newton. You might know him as the man who wrote Amazing Grace. Lutheran Service Book and its predecessor hymnals pair this text with the tune "Saint Peter." A quick youtube search reveals other tunes have been paired to this text throughout the years.
Tune: St. Peter
How sweet the Name of Jesus sounds
In a believer’s ear!
It soothes his sorrows, heals his wounds,
And drives away his fear.
Tune: St. Peter
It makes the wounded spirit whole,
And calms the troubled breast;
’Tis manna to the hungry soul,
And to the weary, rest.
Tune: St. Peter
Dear Name, the Rock on which I build,
My Shield and Hiding Place,
My never failing treasury, filled
With boundless stores of grace!
Tune: Shape Note Melody
By Thee my prayers acceptance gain,
Although with sin defiled;
Satan accuses me in vain,
And I am owned a child.
Tune: Edelweiss
[Yes, that "Edelweiss"]
Jesus! my Shepherd, Husband, Friend,
O Prophet, Priest and King,
My Lord, my Life, my Way, my End,
Accept the praise I bring.
Tune: St. Peter
Weak is the effort of my heart,
And cold my warmest thought;
But when I see Thee as Thou art,
I’ll praise Thee as I ought.
Tune: Shape Note Melody
Till then I would Thy love proclaim
With every fleeting breath,
And may the music of Thy Name
Refresh my soul in death!
Tune: St. Peter