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 “medusa” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

246 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
medusa93629(None) 
medusae1044761medusae
medusal1035181medusal
medusan1044711medusan
medusas1036211medusas
cedula977642cedula
medaka1336342medaka
media84721712med_ia
medias93620782medias
medina94114092medina
medius93613282medius_
meds75735362med_s_
medulla1044712medulla
medusans1144142medusans
mensa75318662me_nsa
menus75822842menus_
meous76120062meous_
mesa67025482me__sa
mezuza1643532mezuza
modus85417202modus_
adust64117453_adust
aedes64625143aedes_
beaus75127113beaus_
beds75937783bed_s_
bedu75923693bedu__
beduin939713beduin
bedumb1335063bedumb
beluga936233beluga
bemuse1038943bemuse
cedes84927323cedes_
cedis84317083cedis_
cedulas1058503cedulas
ceruse83914523ceruse
cesura838763cesura
deduce1079253deduce
deduct10610793deduct
defuse105712723defuse
degust8310253degust
duma75524453__duma
dura55232113__dura
dusk95724153__dusk
dust57142533__dust
ecus65421463_ecus_
edema8610553_edema
edhs86212103_edhs_
eds46638923_ed_s_
educe84313453_educe
educt85017103_educt
emdash12244113emdash
emeus76913333emeus_
emus66821683_emus_
fecula113310053fecula
fedora1038593fedora
feds85234313fed_s_
ferula93011173ferula
fetus85816543fetus_
feuds95914883feuds_
feus75830753fe_us_
geds66730813ged_s_
genua64614153genu_a
genus65319833genus_
indusia845653indusia
jehus15488573jehus_
jejuna1243243jejuna
kudus104910803kudus_
lehua837953lehu_a
lehuas935943lehuas
leuds66214813leuds_
macula103013673macula
madras94316433madras
madrasa10387883madrasa
mads76845373mad_s_
maduro936983maduro
magus85318753magus_
makuta1236393makuta
manus75924933manus_
masa65034723m__asa
massa75518923m_assa
mauds85519273mauds_
mazuma1935603mazuma
meads85425323meads_
meals75933373meals_
means75831233means_
meats75034053meats_
meatus85112923meatus_
mecca1139933me_cca
meccas1239493meccas
med66146743med___
medakas1435763medakas
medal86221333med_al
medals94218053medals
meddle103312763meddle
medevac1553523medevac
medfly1535223medfly
mediad104313713mediad
mediae94217413mediae
medial93819863medial
median94117543median
medic104619653med_ic
medical12312513medical
medick154010133medick
medico113711163medico
medics114115353medics
medigap1374623medigap
medii84513493med_ii
medinas103411463medinas
medium113711623medium
mediums12308723mediums
medivac1554693medivac
medlar93010463medlar
medley1298333medley
medullae1143203medullae
medullar1143463medullar
medullas1144513medullas
medusoid1242603medusoid
meeds84920273meeds_
meets74224613meets_
mega77620873me__ga
megara9310093megara
megass9219443megass
megs75530633me_gs_
melds84822383melds_
melena81110473melena
melisma1146473melisma
mells75031333mells_
mels65941533me_ls_
melts74930103melts_
memes94927703memes_
memos95719113memos_
mems85931503me_ms_
mends84927693mends_
mensae84114043me_nsae
mensal84615653me_nsal
mensas85115853me_nsas
mense75025633me_nse
mensh105413553me_nsh
menta74424423me_nta
menu65130233menu__
menudo945793menudo
meou65325863meou__
meoued9118533meoued
meows104612683meows_
mercs96020453mercs_
merdes94518603merdes_
meres75143573meres_
merest84725113merest
merks114722403merks_
merls77423903merls_
mesas76823203me__sas
mesh96823003me__sh
meshuga1342993meshuga
mess65932433me__ss
messan83912063me_ssan
messy104913833me_ssy
meta65932413me__ta
metepa1066013metepa
metes74736213metes_
meths105320233meths_
metis75025903metis_
metump1235713metump
mewls105813233mewls_
mews96629333me_ws_
mezes167719263mezes_
mezuzah2041973mezuzah
mezuzas1743233mezuzas
midis85923413midis_
mids76541783mid_s_
midst85922553mid_st
mimosa1036363mimosa
minus75223933minus_
misuse83213643misuse
mizuna1734303mizuna
modes85537413modes_
modest93818453modest
modica11310063modica
modish123813543modish
mods77945053mod_s_
modular1087363modular
module93011033module
moduli9267963moduli
modulo9256983modulo
momus96116113momus_
morula8710473morula
mouse77133003m_ouse
mousy106716943m_ousy
mucosa10166273mucosa
mucus94015743mucus_
mudra83912433mud_ra
mudras94212253mudras
muds75530653mud_s_
mumus95517283mumus_
mura65633293m__ura
mus55946753m__us_
musca9311763m__usca
muse67136033m__use
mush94929123m__ush
musk104526193m__usk
muss64933763m__uss
must65145443m__ust
nebula857333nebula
negus64513563negus_
nevus84611393nevus_
nexus124710663nexus_
nidus65913573nidus_
nodus66315993nodus_
oedema936573oedema
pedes85327283pedes_
peds75835243ped_s_
perdus93711273perdus_
perusal939193perusal
peruse84016843peruse
predusk1443773predusk
radula749313radula
rebus75721113rebus_
recusal968673recusal
recuse85519163recuse
redds74617833redds_
redes65139123redes_
redia65524483red_ia
redias74523603redias
redos65126763redos_
redowa1038453redowa
reds56042863red_s_
redub84212413redu_b
redubs9358383redubs
reduce9713253reduce
redux133811103redu_x
refusal1056893refusal
refuse94817513refuse
remuda936823remuda
retuse66617223retuse
reuse56025363re_use
seduce9610023seduce
sedum84115573sedu_m
sedums93910483sedums
sensa54117473se_nsa
serosa6313023serosa
teds54932573ted_s_
tegua6109563tegu_a
teguas768013teguas
tendus75111183tendus_
venus84918903venus_
weds86628933wed_s_
xerus12313333xerus_
zebus164610053zebus_
zeds145821803zed_s_

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162465.86019234.8
3Display Results2462460.0763236.8
 (SQL Overall)1786912466.07929394.8
 
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.