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

269 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
milium10471268(None) 
cilium104311371cilium
ilium74614181_ilium
minium106014421minium
allium8311252allium
filum105015432fil_um
folium11310452folium
helium112311252helium
hilum105514602hil_um
ileum74512822_ileum
kalium1239472kalium
kilim11711902kili_m
medium113711622medium
milia72719572mili_a
milieu8314112milieu
milieus939802milieus
milieux1643782milieux
minim97321602mini_m
minimum10456142minimum
miniums113910222miniums
oidium959812oidium
pileum10399512pileum
telium82611402telium
aecium10410423aecium
ailing74331013ailing
album92312653_album
algum82711763_algum
alliums957973alliums
alum65227613_al_um
amylum1344693amyl_um
atrium8411833atrium
barium10313523barium
bilious9310933bilious
calcium1368593calcium
cerium10313773cerium
cesium1039583cesium
chillum1435443chillum
cilia73016763cili_a
cilice103213353cilice
civism1337243civism
conium10415313conium
corium10315723corium
curium10312503curium
dictum1136863dictum
diluvium1443563diluvium
dinkum1335893dinkum
dirdum1036033dirdum
dominium1346773dominium
erbium1038083erbium
familism1546343familism
filial93013253filial
filing103823763filing
film94828183fil__m
foliums1237173foliums
gallium1037953gallium
glim76026353_gli_m
glum75825103_gl_um
gonium949803gonium
heliums12188303heliums
hili75626643hili__
hilus84817643hil_us
holism113713753holism
holmium1445443holmium
idiom899963_idiom
ileus54616893_ileus
ilia46026823_ili_a
iliac75013493_iliac
iliad64613463_iliad
ilial55317843_ilial
illume8298223_illume
imaum9139643_imaum
indium939503indium
ionium8610923ionium
iridium1046303iridium
kaliums1336603kaliums
kelim11912553keli_m
kilims1277903kilims
labium10410243labium
lilied73913213lilied
lilies63021413lilies
linum7313823li_num
lithium1245823lithium
lum55542933__l_um
magnum1136733magnum
mailing102923343mailing
maim85831493m_ai_m
malic94525663mali_c
malice104818483malice
malign939853malign
maline84529093maline
malm85129983mal__m
maxim165216003maxi_m
maximum1743573maximum
mediums12308723mediums
medius93613283medius
melic94722333meli_c
melisma1146473melisma
mentum104511713mentum
miaou7513083miaou_
miaous8511693miaous
miasm91211093mi_asm
miaul71612123mi_aul
midgut103510053midgut
midi75628493midi__
midis85923423midi_s
midlife13248303midlife
midline102315103midline
midlist10312513midlist
miking134218463miking
mil55752123mil___
miladi938883miladi
milady1236613milady
milage93414123milage
milch124413373mil_ch
mild75330863mil__d
milded104416153milded
milden94113153milden
milder93818453milder
mildew12319043mildew
milding113615453milding
mildly12318243mildly
milds86422063mil_ds
mile66352583mil__e
miler75733063mil_er
milers84625163milers
miles74645073mil_es
miliary1249463miliary
militia949733militia
milk105028483mil__k
milked134612573milked
milker124814323milker
milkier133411163milkier
milkily16216553milkily
milking143712763milking
milks115020583mil_ks
milky144014443mil_ky
mill66541493mil__l
milldam1245473milldam
mille75029133mil_le
milled94326173milled
miller84625413miller
milles84526563milles
millet84030743millet
millieme12276803millieme
millier93716703millier
millilux1742933millilux
millime112511403millime
milline92519113milline
milling103223683milling
milliohm1544453milliohm
million91813143million
millirem1245693millirem
millrun944183millrun
mills75435053mil_ls
milneb1095953milneb
milo65536113mil__o
milord999573milord
milos75428013mil_os
milpa92111403mil_pa
milpas101710273milpas
mils66045343mil__s
milt65455823mil__t
milted93919943milted
milter84921233milter
miltier93214963miltier
milting103619123milting
milts75430713mil_ts
milty104720073mil_ty
mim76048433m__i_m
mimic111414323mimi_c
mimics1289363mimics
miming114317263miming
mini65634573mini__
minibus1136343minibus
minicam131110063minicam
minify1439253minify
minima105512653minima
minims104514813minims
minimums11404603minimums
mining94225453mining
minion83416243minion
minis75432993mini_s
minish115216313minish
minus75223933mi_nus
miri66730383miri__
mirier83918363mirier
mirin75023153miri_n
miring93723803miring
mirins83918903mirins
misaim10311853misaim
miscue10412223miscue
miscut10614823miscut
mislie83219153misli_e
mislies92922283mislies
mislike132914833mislike
mislit83019693misli_t
mislive122812693mislive
missus85312293missus
mitier83620673mitier
mitis75425993miti_s
mixing164713943mixing
mixup1636773mi_xup
modicum1445073modicum
moiling103417663moiling
molies84429513molies
moline84422033moline
momism93410353momism
monism104016313monism
muling93519883muling
mulish11311903mulish
mum76643613m___um
muonium1146863muonium
museum1037703museum
mutism103211463mutism
mycelium1743093mycelium
niobium1144723niobium
odium83413033_odium
oilcup1044253oilcup
oilier64417233oilier
oilily93111723oilily
oiling74925313oiling
oleum73613323_oleum
onium73115533_onium
opium92812093_opium
osmium1036573osmium
ostium8310133ostium
pallium1149023pallium
pilau73618523pilau_
pilaus84114133pilaus
pileup10437923pileup
pileus84514943pileus
pili66130363pili__
piling95025593piling
pilis75825203pili_s
pilous84717753pilous
pilus75921063pil_us
plum85122103_pl_um
podium112911913podium
qiviut1846613qiviut
radium93513293radium
riling74227973riling
sedilium1145753sedilium
siglum936563siglum
silica8311243silica
silicium1286563silicium
siliqua1643983siliqua
silique1645643silique
slim66631963_sli_m
slum65430513_sl_um
smiling103915443smiling
sodium92111453sodium
solum74717613sol_um
stibium1145843stibium
talcum1036953talcum
tedium9269873tedium
thulium1254473thulium
tiling73426553tiling
trillium1046203trillium
tritium969013tritium
trivium1256143trivium
vellum1136773vellum
velum10713383vel_um
vilify1536773vilify
villus93611223villus
wikiup15183533wikiup
wilful1235963wilful
wilier93217073wilier
wilily123310763wilily
wiling103024293wiling

Search took 6 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.390458182.1
2DLD Change Limit1127162695.03322395.4
3Display Results2692690.0932892.5
 (SQL Overall)1786912695.51632395.0
 
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.