How to create a view of duplicate entities based on title, showing the most recently created ones
I solved this using the modules


Flags
Rules
Views Rules
Rules links


with the following method:


Added a flag 'in bucket' connected to the entity
Created A views Rules display listing all entities
Created a rules link, which includes a rule with an action 'Views
loop' that performs an action on each entity in the views Rules
display. The action performed is a rules component that again uses a
views loop checking if a duplicate title is present. So for every
views list item, all views list items are compared.
If a duplciate title is found, the entity is flagged with the 'in
bucket' flag. The Rules link has as a last action the redirection to
the view that shows all entities in the bucket.
To make this more reliable, add as first action of the rules link, a
loop to remove all entities from the bucket (remove all flags).


In this way, with one click all entities are checked on duplicate titles, and the found duplciates are shown.

However, this is not the most efficient and performant way for large lists. For example when having 2000 entities, rules will need to process 2K x 2K = 4M times the comparison. 
I had to limit my list to 350 items in order to have processing time of 5 minutes.
I tried to implement batch processing of the views loops, but did not succeed yet.

A more efficient way would probably be to use the view as mentioned in the question, and use that list of titles as a filter for another view which should show the most recent entities having one of this titles.
I haven't figured out how to do this yet.