In one of my current projects, I built a search API backed by a relational database with the dataset size of 2.5 million address records. the API is supposed to return a list of matching addresses given address details such as house number, street name, postcode, etc.