If it is any 'comfort' to you, I've made the same mistake myself. = It might give you 'comfort' to know that I've made the same mistake myself.
When we went out for drinks together, I realized we were getting 'too close for comfort'. [=we were getting closer than I wanted to be]
Knowing that I can rely on your help is a 'comforting' thought. = It is 'comforting' to know that I can rely on your help.
(..) It was my fault he got shot. He's a fuckin' bloody mess. He's screamin'. I swear to God, I thought he was gonna die right then and there. I'm tryin' to comfort him, telling him not to worry... everything's going to be okay, I'm gonna take care of him. And he asked me what my name was. (..)1992 Reservoir Dogs