You're right. SFML and Notepad don't render fonts identically.
Sometimes, though, SFML's way might just be better
That said, if you scale up the text inside the program (or just resize the window), gaps can appear between the characters.
Are you rendering at a size where the text's texture's pixels match the window's pixels? If you need to increase its size, try first rendering to a render texture and scaling that.