Jaka Stavanja jstavanja

## fuzzy-search-postgres.md

      
              1 file
            
          
              5 forks
            
          
              4 comments
            
          
              12 stars
            
          
                nepsilon
                / fuzzy-search-postgres.md
            
            
              Last active
              December 13, 2023 14:16
            
              
                PostgreSQL: Native fuzzy search with levenshtein() — First published in fullweb.io issue #41
              
          
    PostgreSQL: Fuzzy search with levenshtein()

Ever wanted to implement a “Did you mean?” feature in your search results?
Google is said to have greatly increased its user engagement with it. Here is how to implement it simply in Postgres (v9.1+):
Install the extension:
CREATE EXTENSION fuzzystrmatch;

  
## gist:7360908

      
              1 file
            
          
              3671 forks
            
          
              1031 comments
            
          
              16822 stars
            
          
                rxaviers
                / gist:7360908
            
            
              Last active
              June 25, 2024 05:26
            
              
                Complete list of github markdown emoji markup
              
          
    People


 :bowtie:
😄 :smile:
😆 :laughing:


😊 :blush:
😃 :smiley:
☺️ :relaxed:


😏 :smirk:
😍 :heart_eyes:
😘 :kissing_heart:


😚 :kissing_closed_eyes:
😳 :flushed:
😌 :relieved:


😆 :satisfied:
😁 :grin:
😉 :wink:


😜 :stuck_out_tongue_winking_eye:
😝 :stuck_out_tongue_closed_eyes:
😀 :grinning:


😗 :kissing:
😙 :kissing_smiling_eyes:
😛 :stuck_out_tongue:
`:bowtie:`	😄 `:smile:`	😆 `:laughing:`
😊 `:blush:`	😃 `:smiley:`	☺️ `:relaxed:`
😏 `:smirk:`	😍 `:heart_eyes:`	😘 `:kissing_heart:`
😚 `:kissing_closed_eyes:`	😳 `:flushed:`	😌 `:relieved:`
😆 `:satisfied:`	😁 `:grin:`	😉 `:wink:`
😜 `:stuck_out_tongue_winking_eye:`	😝 `:stuck_out_tongue_closed_eyes:`	😀 `:grinning:`
😗 `:kissing:`	😙 `:kissing_smiling_eyes:`	😛 `:stuck_out_tongue:`