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!

3 Answers 3


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

enter image description here enter image description here

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


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

FROM ethereum.transactions

See it in action on Flipside.


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?

  • 1
    It is better to create a new question if you have further doubts.
    – Ismael
    Commented Apr 5, 2022 at 3:12
  • If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review
    – Julissa DC
    Commented Apr 5, 2022 at 12:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.