Btree partial matching works by starting at the beginning string and using each character as a lookup to decide which portions of the database are potentially relevant. This search only works when its done starting at the beginning. You can't get your access pattern from this feature.