I hear you about wanting a perfect match, but you have an array of values - it’s not specified which field those values should match, so you’re trying several. Do the elements in the array have a particular field they should match? If not, then a “perfect match” does not seem well defined. Can you provide some sample documents that should and should not match? In general, full text search is not about a perfect or exact match but about relevancy, with the best matching documents at the top of the list.
You mentioned considering a SQL DB - how would that query be specified, out of curiosity?
It’s an interesting search challenge you have proposed, so I’m here to help as best I can. Thanks for your patience 