Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “medusan” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

68 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
medusan104471(None) 
medusa936291medusa_
medusae1044761medusae
medusal1035181medusal
medusans1144141medusans
medusas1036211medusas
median94117542med_ian
messan83912062me_ssan
bedeman12168843bedeman
bedesman1345083bedesman
bedpan1137583bed_pan
beduin939713bedu_in
cedula977643cedula_
cedulas1058503cedulas
decuman1236573decuman
hexosan1744333hexosan
madman113712383mad_man
mean65538093me___an
meatman1137903meatman
medaka1336343medaka_
medakas1435763medakas
medal86221333med__al
medevac1553523medevac
media84721713med_ia_
mediad104313713med_iad
mediae94217413med_iae
medial93819863med_ial
medians103214213med_ians
mediant103516703med_iant
medias93620783med_ias
medical12312513medical
medicant13910833medicant
medigap1374623medigap
medina94114093medina_
medinas103411463medinas
medius93613283medius__
medivac1554693medivac
medlar93010463med_lar
meds75735363med_s__
medulla1044713medulla
medullae1143203medullae
medullar1143463medullar
medullas1144513medullas
medusoid1242603medusoid
mensa75318673me_nsa_
mensae84114053me_nsae
mensal84615663me_nsal
mensas85115863me_nsas
menus75822843menus__
meous76120063meous__
merman10513863me_rman
mesa67025483me__sa_
mesas76823203me__sas
mesian84315503me_sian
meson74118313me__son
messans92710463me_ssans
messman1137283messman
mezuza1643533mezuza_
mezuzah2041973mezuzah
mezuzas1743233mezuzas
modular1087363modular
modus85417203modus__
perusal939193perusal
recusal968673recusal
recusant1049463recusant
redan66125013red__an
refusal1056893refusal
sedan65620423sed__an

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.450397091.1
2DLD Change Limit134027686.95319276.1
3Display Results68680.0164250.0
 (SQL Overall)178691687.41924085.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.