A dick that is non-erect and can not get hard. Also used as an insult to imply someone has a limp noodle or is in fact a giant limp dick.
Say that to my face you limp noodle. Yeah thats what I fucking thought.