Thanks for your response, Thad. I probably didn't frame my initial query very well (apologies).
I have been doing it the way you describe, but it is a manual process. For context, I work in a museum with natural history collection data. In the data I am working with, there are about 20,000 unique facets of the column I am working with. Often, we have a range of place names for specimens that are from the same place.
In the 20,000 unique strings there could upto 50 different iterations of the same place, example below for Grasmere Stream.
Cass, Grasmere Stream pond 1
Grasmere Stream, near Sarah Bridge 1
Grasmere Stream, tributary 1.2 kilometres north, Cass 1
Lower Bush and Middle Bush streams, Cass5
Middle Bush Stream, Lower, Cass4
Middle Bush Stream, south bridge, Cass4
Reservoir Bush and Middle Bush streams, Cass4
Reservoir and Middle Bush streams, Cass3
Middle Bush stream, north, Cass2
Middle Bush Stream, South branch, Cass2
Lower bush and Middle bush streams, Cass 1
Middle Bush Stream N, Cass 1
Middle Bush stream north, Cass 1
Middle Bush stream, Cass 1
Middle Bush stream, north branch, Cass 1
Cass Bush Stream 4
(this is a subset of all facets that are relevant to Grasmere Stream)
I am doing text filter searches for all the different iterations and click include on all the entries on the text facet, but it is not super-efficient manually clicking the include button for all searches (e.g. 'Middle Bush Stream', 'Grasmere Steam', 'Lower Bush Stream', 'Cass Stream', Cass Bush Stream').
Once I have all the relevant facets selected, I am adding geographic context data to all records in other columns. This may be the only way to do this, but I hope there may be a way to return different facet iterations using the text filter, or some other OpenRefine tool/mechanism.
If this is not possible, no worries at all. Just looking for ways to streamline the process where I can.