Not really an answer, but perhaps a hint: check the manual for whether the is supported by MS SQL. If so it would replace the rightmost select with the group by and having clause, like this
[sql]
... unique (select substring(player from 1 for 3) from scores)
[/sql].
Hopefully it will be faster.