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

232 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
medium11371162(None) 
mediums12308721mediums
medius93613281medius
tedium9269871tedium
aecium10410422aecium
bedim10313832bedi_m
cerium10313772cerium
cesium1039582cesium
helium112311252helium
indium939502indium
media84721712medi_a
mediad104313712mediad
mediae94217412mediae
medial93819862medial
median94117542median
medias93620782medias
medic104619652medi_c
medick154010132medick
medico113711162medico
medics114115352medics
medii84513492medi_i
medina94114092medina
mentum104511712mentum
milium104712682milium
minium106014422minium
modicum1445072modicum
odium83413032_odium
oidium959812oidium
podium112911912podium
radium93513292radium
sedum84115572sed_um
smeddum1342852smeddum
sodium92111452sodium
tediums10266972tediums
telium82611392telium
uredium1076692uredium
aecidium1345283aecidium
aedile73716653aedile
aedine73218393aedine
allium8311243allium
alodium1047583alodium
atrium8411833atrium
barium10313523barium
bedaub1146033bedaub
bedbug12193973bedbug
bedims1149593bedims
bedlam1149273bedlam
bedrug10164953bedrug
bedu75923693bed_u_
beduin939713beduin
bedumb1335063bed_umb
begum105213923be_gum
cadmium1446113cadmium
caesium1158833caesium
cecum11611843ce_cum
cedi74919273cedi__
ceding104014803ceding
cedis84317083cedi_s
centum104012363centum
ceriums1139483ceriums
cesiums1136303cesiums
cilium104311373cilium
conium10415313conium
corium10315723corium
curium10312503curium
dadgum1134583dadgum
degum94711903de_gum
deism84116033de_ism
denim85518843deni_m
dim68146493__di_m
doum76226673__doum
drum76521593__drum
edict84722283_edict
edify12308563_edify
edile64819493_edile
edit54934863_edi_t
edits65819033_edits
erbium1038083erbium
fermium1446353fermium
ferrum1147453ferrum
folium11310453folium
genius74512923genius
geum75424553ge__um
gonium949803gonium
heliums12188303heliums
hymenium1874773hymenium
idiom899963_idiom
ilium74614183_ilium
imperium1446423imperium
indiums1037143indiums
iodism93611133iodism
ionium8610923ionium
iridium1046303iridium
kalium1239473kalium
kelim11912553keli_m
labium10410243labium
madam10316223mad_am
madtom1138023madtom
magnum1136733magnum
maim85831493m_ai_m
maxim165216003maxi_m
maximum1743573maximum
mazaedium2352153mazaedium
meatus85112923meatus
meconium1447313meconium
med66146743med___
medaka1336343medaka
medal86221333med_al
medals94218063medals
meddle103312763meddle
medfly1535223medfly
mediacy1536143mediacy
medials103914743medials
medians103214213medians
mediant103516703mediant
mediate103415213mediate
medical12312513medical
medicks16368413medicks
medicos12339833medicos
medigap1374623medigap
medinas103411463medinas
medivac1554693medivac
medlar93010463medlar
medley1298343medley
meds75735363med__s
medusa936293medusa
megilp1135833megilp
megohm14124193megohm
megrim1178043megrim
meiny104015413me_iny
melding113414273melding
melic94722333meli_c
melisma1146473melisma
mem77943473me___m
mendigo11506333mendigo
mending114018683mending
menial84223033menial
meninx1538703meninx
menu65130233me_nu_
menus75822843me_nus
meou65325863me_ou_
meous76120063me_ous
merino8315093merino
merit7339183meri_t
merits8320873merits
mesial84818083mesial
mesian84315503mesian
mesic93617863mesi_c
metier83517693metier
meting94320593meting
metis75025903meti_s
metump1235713me_tump
mewing123914203mewing
midgut103510053midgut
midi75628483midi__
midis85923413midi_s
mim76048423m__i_m
minim97321603mini_m
minimum10456143minimum
miniums113910223miniums
modem103717143mod_em
modi76826313modi__
modica11310063modica
modicums1543483modicums
modify1537173modify
modish123813543modish
modus85417203mod_us
momism93410353momism
monism104016313monism
mudbug1243253mudbug
mum76643613m___um
muonium1146863muonium
museum1037703museum
mutism103211463mutism
mycelium1743093mycelium
neum66723083ne__um
nudism9357913nudism
odeum84610543_odeum
odiums9337943_odiums
omentum1155933omentum
onium73115533_onium
opium92812093_opium
osmium1036573osmium
ostium8310133ostium
peplum12156823peplum
peridium1349023peridium
podiums12227633podiums
premium13310363premium
radiums10299323radiums
radius73914873radius
rectum103411283rectum
redbud10135803redbud
redbug10165473redbug
redeem9311533redeem
redia65524483redi_a
rediae74221993rediae
redial74923113redial
redias74523603redias
redid74922393redi_d
reding83825563reding
redip87816963redi_p
redips93713843redips
redipt94116743redipt
redout71820253redout
redub84212413red_ub
redux133811103red_ux
refilm114311403refilm
regius7311923regius
regnum957163regnum
rhenium1246243rhenium
rhodium1345343rhodium
sadism94113493sadism
sebum93814553se_bum
sedile73517233sedile
sedilium1145753sedilium
sedums93910483sed_ums
seism75019023se_ism
sensum849353sensum
septum1038003septum
serum75223473se_rum
sexism15227653sexism
smeddums1441983smeddums
sodiums10177213sodiums
stadium1038073stadium
tectum10328603tectum
tedious838443tedious
terbium1147293terbium
tergum937933tergum
vellum1136773vellum
velum10713383ve_lum
verism113214263verism
zoecium2044183zoecium

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.373479064.3
2DLD Change Limit1127162325.89019136.8
3Display Results2322320.0633682.5
 (SQL Overall)1786912326.32628247.1
 
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.