Simple way to find the exact address / transaction by the part of the address / transaction hash?

Question

Imagine I have only a part of the address, for example, 0xa2793n. The rest of the address is unknown. Is there any indexer, that stores this information in any suitable format, so I can find the list of "used" addresses?

1. I know, that the way geth / parity stores the blockchain data doesn't allow such queries. So most likely I need some third party indexer software which maintains an SQL table with the addresses.
2. Also I know that there's a huge amount of theoretically correct addresses with the same beginning, so this software should only do a search in already used addresses.

The same question for transaction hash. Thanks in advance!

Answer 1

The good news is that Etherscan has an autocomplete feature for address search, check the screenshots below:

Still not sure if there are any existing solutions for transactions search.

Answer 2

You can write SQL query using LIKE syntax with wildcard character %.

SELECT *
FROM ethereum.transactions
WHERE TO_ADDRESS LIKE '0xa2793n%'

See it in action on Flipside.

Answer 3

It does autocomplete on etherscan but only when you write 7 or more of the first digits as I can see.

Is there a way/place to get full suggestions of addresses starting with only the first 6 digits or less?