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

190 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
mediums1230872(None) 
medium113711621medium_
medius93613281mediu_s
tediums10266971tediums
bedims1149592bedi_ms
ceriums1139482ceriums
cesiums1136302cesiums
heliums12188302heliums
indiums1037142indiums
medials103914742medials
medians103214212medians
medias93620782medi_as
medicks16368412medicks
medicos12339832medicos
medics114115352medi_cs
medinas103411462medinas
miniums113910222miniums
modicums1543482modicums
odiums9337942_odiums
podiums12227632podiums
radiums10299322radiums
sedums93910482sed_ums
smeddums1441982smeddums
sodiums10177212sodiums
tedium9269872tedium_
aecium10410423aecium_
aediles83413903aediles
alliums957973alliums
atriums939063atriums
bariums1139153bariums
bedaubs1233693bedaubs
bedbugs13193503bedbugs
bedim10313833bedi_m_
bedlams1237053bedlams
bedrugs11194283bedrugs
beduins1039123beduins
bedumb1335063bed_umb
bedumbs1433633bed_umbs
begums11429493be_gums
cadmiums1544403cadmiums
caesiums1245533caesiums
cedis84317083cedi__s
centums11398783centums
cerium10313773cerium_
cesium1039583cesium_
coniums11311863coniums
curiums1138503curiums
degums10438623de_gums
deisms94411043de_isms
denims95214323deni_ms
dims75435033__di_ms
doums85417643__doums
drums85415873__drums
edicts94911703_edicts
ediles74016983_ediles
edits65819033_edi_ts
erbiums1135463erbiums
fermiums1544353fermiums
ferrums1265983ferrums
foliums1237173foliums
genius74512923geniu_s
geums85414113ge__ums
helium112311253helium_
hymeniums1973473hymeniums
idioms956413_idioms
imperiums1544583imperiums
indium939503indium_
iodisms10308483iodisms
ioniums938313ioniums
iridiums1144523iridiums
kaliums1336603kaliums
kelims1278913keli_ms
madams11310943mad_ams
madtoms1236923madtoms
magnums1234683magnums
maims96321793m_ai_ms
maxims17399673maxi_ms
maximums1842813maximums
meatus85112923meatu_s
meconiums1545293meconiums
medakas1435763medakas
medals94218063med_als
meddles113213253meddles
media84721713medi__a
mediacy1536143mediacy
mediad104313713medi_ad
mediae94217413medi_ae
medial93819863medi_al
median94117543medi_an
mediant103516703mediant
mediants11299493mediants
mediate103415213mediate
mediates112814063mediates
medic104619653medi__c
medical12312513medical
medicals1349363medicals
medick154010133medi_ck
medico113711163medi_co
medigap1374623medigap
medigaps1463883medigaps
medii84513493medi__i
medina94114093medi_na
mediumship2051293mediumship
medivac1554693medivac
medivacs1644003medivacs
medlars10259443medlars
medleys13115333medleys
meds75735373med___s
medusa936293med_usa
medusas1036213medusas
megilps1233563megilps
megohms1592863megohms
megrims1276103megrims
melisma1146473melisma
melismas1245713melismas
mems85931503me___ms
mendigos12425213mendigos
mendings12338303mendings
menials94015693menials
mentum104511713mentum_
menus75822843me_nu_s
meous76120063me_ou_s
merinos9311983merinos
merises93421423merises
merisis93213173merisis
merits8320873meri_ts
meseems1165603meseems
metiers93312843metiers
metis75025903meti__s
metump1235713me_tump
metumps1334133me_tumps
midguts11296013midguts
midis85923423midi__s
milium104712683milium_
minims104514813mini_ms
minimums11404603minimums
minium106014423minium_
modems114610763mod_ems
modicum1445073modicum_
modus85417203mod_u_s
momisms10308223momisms
monisms113512803monisms
mudbugs1342853mudbugs
mums85732773m___ums
muoniums1244723muoniums
museums1134573museums
mutisms11338453mutisms
neums75414253ne__ums
nudisms10305853nudisms
odeums9367313_odeums
odium83413033_odium_
oidium959813oidium_
omentums1243973omentums
opiums10307073_opiums
osmiums1134143osmiums
peplums13145503peplums
podium112911913podium_
premiums1437533premiums
radium93513293radium_
radius73914873radiu_s
rectums11338523rectums
redbuds11144283redbuds
redbugs11134463redbugs
redeems1037163redeems
redials84416883redials
redias74523603redi_as
redips93713843redi_ps
redouts81411663redouts
redubs9358383red_ubs
refilms12347503refilms
regius7311923regiu_s
rheniums1344413rheniums
rhodiums1443763rhodiums
sadisms10359113sadisms
sebums10369813se_bums
sedum84115573sed_um_
seisms84912143se_isms
septums1135743septums
serums83916303se_rums
sexisms16226223sexisms
smeddum1342853smeddum_
sodium92111453sodium_
stadiums1145703stadiums
tectums11306423tectums
tedious838443tedious
telium82611393telium_
terbiums1245423terbiums
uredium1076693uredium_
vellums1235293vellums
verisms123011253verisms

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.466383457.1
2DLD Change Limit1340271907.23618522.2
3Display Results1901900.0633015.9
 (SQL Overall)1786911907.76523012.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.