I guess you need to see the ticket condition and also the travel agent terms and conditions. that will tell you exactly what the possibilities of changing the name are and the fee to pay
Now travelling with a ticket with the wrong middle name. I guess that can go either ways. Depends of the airlines, the check in agent, security... also probably where you board. Some places are much more tolerant than others,