A cup of boiling water can transfer more heat simply because it has more heat than the tap water.
If you let them sit for a while at room temperature, a cup of tap water would have little change in temperature. Meanwhile, a cup of boiling water would have huge difference in temp because it will eventually be cooler until it has the same temp as the tap water. This means that more heat energy has been released by the boiling water than the tap water.