When will my no fee transaction come back?
It generally "comes back" in a week or two. Actually the transaction gets discarded by the mining nodes from their memory pools. Until then, your transaction is stuck. 
However it depends on the wallet software as well if they let you spend it. 
I had complete control over the addresses I was using so it was easier for me to retrieve the funds.