Fuzzy search in array of object.

lpnhox

Hello Com, I having an user table here with "Emails" field which is an array of object containing key "value" for storing the "email". But i cannot create index search for that field.

Question: Is there any other way to implement the Fuzzy search for that?
Thank you all.

soyashjain

If I understand it correctly, you have a table in which there is a field called "email" which is an array of objects, right?

My question to you would be, how long do you expect this list to get?

Imo, If this list is short, you might not even need fuzzy search. If its, long, probably the emails shouldn't be a list of objects. A seperate table for these emails would be ideal in that case.

But would like to get more context.