query seems to execute quite slow

[domino14]

This query took almost 11 seconds to execute on the OSPS42.db lexicon database.

SELECT word, alphagram FROM (
        SELECT alphagrams.alphagram
        FROM alphagrams
        WHERE alphagrams.length = 9 AND alphagrams.contains_update_to_lex = 1
        ORDER BY alphagrams.probability
        ) q
INNER JOIN words w using (alphagram)

If I execute this query directly in sqlite3, it is almost instantaneous! What is happening?