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

258 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
miladi93888(None) 
miladis1049821miladis
milady1236611milady
malady1237862malady
midi75628482mi__di
mikado1344512mikado
miladies1139922miladies
milage93414122milage
mild75330852mil_d_
milds86422052mil_ds
misadd1037162misadd
mislaid1039302mislaid
tuladi765722tuladi
ailed66240283ailed_
belady12489933belady
biali73419073bi_ali
bidi78226593bi__di
bindi85617013bi_ndi
blade85923333_blade
cadi75732183__cadi
calami10313423calami
cicada1136413cicada
clad76225823_clad_
clade85821013_clade
clads85722733_clads
clavi104912923_clavi
dalasi7610623dalasi
dilate73220693dilate
dildo71911773dil_do
fila74729133fila__
filar84819293fila_r
filaria1039653filaria
filed95331903filed_
filmi105914003fil_mi
gadi66329723__gadi
gelada837623gelada
gelati73814533gelati
gild65526513gil_d_
gilds75417523gil_ds
glad65624013_glad_
glade75121963_glade
glads75620613_glads
glady105413943_glady
gliadin935593gliadin
hila76228353hila__
hilar85418143hila_r
hili75626633hil__i
iliad64613463_iliad_
iliads7448673_iliads
inlaid7310143inlaid
irade65618153_irade
jihad1635913jihad_
jihads1734483jihads
kadi96224833__kadi
khadi1367603_khadi
kulaki984293kulaki
lad48165703__lad_
lade56345983__lade
lads56549133__lads
lady86527153__lady
laid56439143__laid
lari45839153__lari
lati46438273__lati
lilac7311073lila_c
lilacs837483lilacs
litai55216363lita_i
mad68958713m__ad_
made75440243m__ade
mads76845373m__ads
magi76329533m__agi
maid75537663m__aid
mailed95326753mailed_
maladies11311933maladies
malar76424443mala_r
malaria9313703malaria
malars85020683malars
malate84624563malate
mallei84414633mallei
maloti8313213maloti
maxi137023563m__axi
mead75531603m_ead_
meads85425323m_eads
mehndi1233153mehndi
melamdim1242503melamdim
melanic11310403melanic
melanin9310893melanin
meld75830473mel_d_
melds84822383mel_ds
melodia1038883melodia
melodic1238543melodic
melody1237203melody
meloid9616003meloid
menad85918983menad_
menads95514383menads
miaou7513083mi_aou
miaow1058353mi_aow
miasm91211093mi_asm
miaul71612123mi_aul
mica86428253mica__
micas96823053mica_s
mid67354473mi__d_
midair937993midair
midday13327503midday
middy124812593mi_ddy
midis85923413mi__dis
midland1136613midland
midlands1245543midlands
mids76541793mi__ds
mikados1444683mikados
miked125020453miked_
mil55752113mil___
milages103114403milages
milch124413373mil_ch
milchig1543653milchig
milded104416153milded
milden94113153milden
milder93818453milder
mildew12319043mildew
milding113615453mil_ding
mildly12318243mildly
mile66352573mil__e
mileage10299313mileage
miler75733063mil_er
milers84625163milers
miles74645073mil_es
milfoil1264383milfoil
milia72719573mil_ia
miliaria1048783miliaria
miliary1249463miliary
milieu8314113milieu
militia949733militia
milium104712683milium
milk105028473mil__k
milked134612573milked
milker124814323milker
milkmaid1742683milkmaid
milks115020583mil_ks
milky144014443mil_ky
mill66541483mil__l
millage103112753millage
milldam1245473milldam
mille75029133mil_le
milled94326173milled
miller84625413miller
milles84526563milles
millet84030743millet
mills75435053mil_ls
milneb1095953milneb
milo65536103mil__o
milord999573milord
milords10117853milords
milos75428013mil_os
milpa92111403mil_pa
milpas101710273milpas
milreis937323milreis
mils66045333mil__s
milt65455813mil__t
milted93919943milted
milter84921233milter
milts75430713mil_ts
milty104720073mil_ty
mimed105622733mimed_
mina65136923mina__
minae75627723mina_e
minas75434113mina_s
mind75434383mi_nd_
minds85427123mi_nds
mined85333353mined_
mini65634563mi__ni
mirador1046503mirador
mirage92313653mirage
mired85729223mired_
miri66730373mi__ri
misact10316693misact
misadds1136303misadds
misaim10311853misaim
misate81222693misate
misdid10510573mi_sdid
misdo85413183mi_sdo
misedit10311043misedit
mislain9311243mislain
mislay113510683misla_y
mislays12349243mislays
mislead10419973mislead_
misleads11358543misleads
misled94719313misled_
mismade12129353mismade
missaid10310303missaid
mixed155717253mixed_
modi76826313m__odi
moiled94318863moiled_
moirai886913moira_i
mola66035633mola__
molal75120343mola_l
molar75223093mola_r
molars85517323molars
molas75132093mola_s
mold76034333mol_d_
molds85324833mol_ds
moldy115014653mol_dy
monad85519473monad_
monadic1268883monadic
monads94515303monads
muled85824433muled_
mylar105311533myla_r
mylars114310443mylars
nicad8312613nicad_
nicads938333nicads
nidi56524403ni__di
nilgai734883nilgai
oiled64429473oiled_
padi76331783__padi
paladin101011773paladin
pilaf103923483pila_f
pilaff143910363pilaff
pilafs113511023pilafs
pilar75221503pila_r
pilau73618523pila_u
pilaus84114133pilaus
pilaw103913743pila_w
pilaws11399433pilaws
piled85232993piled_
pilei74021783pil_ei
pili66130353pil__i
plaid85118303_plaid
qadi145621103__qadi
relaid75518443relaid
riled65833253riled_
sadi55834643__sadi
salad65321833salad_
salads75316963salads
salami8313103salami
sialid7314943sialid
silage72715303silage
silane62718053silane
sild55030583sil_d_
silds65520523sil_ds
sileni63312143sileni
smilax1535393smila_x
smiled93716433smiled_
soldi65717203sol_di
solidi73813153solidi
tilak91011553tila_k
tilaks1097353tilaks
tilapia945553tilapia
tilde65017343til_de
tiled64832943tiled_
tirade7311693tirade
tsadi6379913_tsadi
tuladis835703tuladis
unlade72714153unlade
unlaid7311753unlaid
villi86517853vil_li
wadi86228173__wadi
wild85126513wil_d_
wilds94818203wil_ds
wiled95231553wiled_
yclad11246383yclad_

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.376475242.0
2DLD Change Limit1127162586.48317386.4
3Display Results2582580.0932774.2
 (SQL Overall)1786912586.95225703.5
 
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.