How can I sort by last word in the node title field?
This is probably not best solution, but it should work:

Try Views PHP. With this module you should be able to create sorting in view which will take only last word of given string (content of your title field) with PHP code (something like this example).


  This module allows the admin account (user 1) to add fields, filters and sorts to views which use PHP code.