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 “medusae” 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.

95 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
medusae104476(None) 
medusa936291medusa_
medusal1035181medusal
medusan1044711medusan
medusas1036211medusas
mediae94217412med_iae
medullae1143202medullae
medusans1144142medusans
mensae84114052me_nsae
bedunce1235683bedunce
bemuse1038943bemus_e
cedula977643cedula_
cedulas1058503cedulas
ceruse83914523cerus_e
cesurae937703cesurae
deduce1079253dedu_ce
defuse105712723defus_e
educate10310213_educate
educe84313453_edu_ce
feculae12339203feculae
ferulae10309603ferulae
maculae113412863maculae
measle83513223me_asle
measure939033measure
medaka1336343medaka_
medakas1435763medakas
medal86221333med__al
meddle103312763med_dle
medevac1553523medevac
media84721713med_ia_
mediad104313713med_iad
medial93819863med_ial
median94117543med_ian
medias93620783med_ias
mediate103415213mediate
medical12312513medical
medicare1347483medicare
medicate13513243medicate
medigap1374623medigap
medina94114093medina_
medinas103411463medinas
meditate11310623meditate
medius93613283medius__
medivac1554693medivac
medlar93010463med_lar
meds75735363med_s__
medulla1044713medulla
medullar1143463medullar
medullas1144513medullas
medusoid1242603medusoid
megasse10266243megasse
mensa75318673me_nsa_
mensal84615663me_nsal
mensas85115863me_nsas
mense75025633me_ns_e
menus75822843menus__
meous76120063meous__
mesa67025483me__sa_
mesas76823203me__sas
mesne75116293me__sne
message1037833me_ssage
messan83912063me_ssan
messuage1144523messuage
metisse936503metisse
metopae1147743metopae
mezuza1643533mezuza_
mezuzah2041973mezuzah
mezuzas1743233mezuzas
misusage1145173misusage
misuse83213643misus_e
modiste1039283modiste
modular1087363modular
modulate1138593modulate
module93011033modu_le
modus85417203modus__
morulae958963morulae
mouse77133003m_ous_e
mousse84813033m_ousse
mucosae11155313mucosae
muscae10410673m__uscae
muse67136033m__us_e
nebulae955493nebulae
perusal939193perusal
peruse84016843perus_e
radulae837963radulae
recusal968683recusal
recuse85519163recus_e
rediae74221993red_iae
reduce9713253redu_ce
refusal1056893refusal
refuse94817513refus_e
retuse66617223retus_e
reuse56025363re_us_e
seduce9610023sedu_ce
serosae7310253serosae

Search took 7 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.390458182.1
2DLD Change Limit134027956.20321606.8
3Display Results95950.0462065.2
 (SQL Overall)178691956.63926915.3
 
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.