--- a/search_autosuggest.php
+++ b/search_autosuggest.php
@@ -7,7 +7,7 @@
 $aResults = array();
 $count = 0;
 if ($len) {
-    $query = 'SELECT MAX("supplierName"), MAX("supplierABN"), count(*) as count
+    $query = 'SELECT mode("supplierName"), MAX("supplierABN"), count(*) as count
 FROM contractnotice
 WHERE "supplierName" ILIKE :supplierName
 GROUP BY "supplierName"
@@ -47,9 +47,8 @@
         );
     }
         $query = "SELECT \"CNID\", description, value FROM contractnotice
-WHERE to_tsvector('english', description) @@ plaintoto_tsquery('english', :input)";
+WHERE to_tsvector('english', description) @@ plainto_tsquery('english', :input)";
     $query = $conn->prepare($query);
-    $agencyName = $input . '%';
     $query->bindParam(":input", $input);
     $query->execute();
     databaseError($conn->errorInfo());
@@ -84,3 +83,4 @@
     echo "</results>";
 }
 ?>
+