@@ -109,2 +123,4 @@
       end
     end
+
+    read :search do

@@ -111,0 +130,4 @@
+
+      prepare fn query, _ctx ->
+        q = Ash.Query.get_argument(query, :query) || ""
+        fields = Ash.Query.get_argument(query, :fields) || @default_fields

@@ -111,0 +131,4 @@
+      prepare fn query, _ctx ->
+        q = Ash.Query.get_argument(query, :query) || ""
+        fields = Ash.Query.get_argument(query, :fields) || @default_fields
+        threshold = Ash.Query.get_argument(query, :similarity_threshold) || 0.2

@@ -111,0 +137,4 @@
+          q2 = String.trim(q)
+          pat = "%" <> q2 <> "%"
+
+          # FTS as main filter and fuzzy search just fo first name, last name and strees

@@ -111,0 +151,4 @@
+                fragment("? % first_name", ^q2) or
+                fragment("? % last_name", ^q2) or
+                fragment("? % street", ^q2) or
+                fragment("word_similarity(?, first_name) > ?", ^q2, ^threshold) or

@@ -111,0 +153,4 @@
+                fragment("? % street", ^q2) or
+                fragment("word_similarity(?, first_name) > ?", ^q2, ^threshold) or
+                fragment("word_similarity(?, last_name) > ?", ^q2, ^threshold) or
+                fragment("word_similarity(?, street) > ?", ^q2, ^threshold) or

@@ -197,1 +195,3 @@
-      |> filter(expr(fragment("search_vector @@ plainto_tsquery('simple', ?)", ^search_query)))
+      |> Mv.Membership.Member.fuzzy_search(%{
+        query: search_query,
+        fields: [:first_name, :last_name, :street]

@@ -0,0 +31,4 @@
+      Mv.Membership.Member
+      |> Mv.Membership.Member.fuzzy_search(%{
+        query: "john",
+        fields: [:first_name, :last_name, :email]