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

197 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
miladis104982(None) 
miladi938881miladi_
miladies1139921miladies
maladies11311932maladies
midis85923412mi__dis
mikados1444682mikados
milady1236612milad_y
milages103114402milages
milds86422052mil_d_s
milreis937322milreis
misadds1136302misadds
tuladis835702tuladis
beladies11310423beladies
bialis83617163bi_alis
bidis86721143bi__dis
bindis94614583bi_ndis
blades95221253_blades
cadis84428503__cadis
cicadas1235993cicadas
clades94920463_clades
cladism1238553_cladism
cladist10311973_cladist
clads85722733_clad_s
dalasis8810533dalasis
dilates83220663dilates
dildos8179303dil_dos
filaria1039653filaria
filmis114610283fil_mis
finalis103313663finalis
gadis74825293__gadis
geladas936313geladas
gelatis83313513gelatis
gilds75417523gil_d_s
glacis94012133_glacis
glades84820343_glades
glads75620613_glad_s
gliadin935593gliadin
gliadins1035193gliadins
iliads7448673_iliad_s
irades74517393_irades
jihads1734483jihad_s
kadis105921063__kadis
khadis1446913_khadis
lades65141273__lades
ladies75124883__ladies
lads56549133__lad_s
lapis76223153__lapis
laris54737463__laris
lilacs837483lila_cs
mads76845373m__ad_s
maids86327143m__aids
malady1237863malad_y
malaise9312673mala_ise
malaria9313693malaria
malarias10313773malarias
malars85020683mala_rs
malates93522603malates
mavis105622723m__avis
maxis145721563m__axis
meads85425323m_ead_s
mehndis1343583mehndis
melamdim1242503melamdim
melanic11310403melanic
melanics1237733melanics
melanin9310893melanin
melanins10310383melanins
melanism1239363melanism
melanist10313053melanist
melds84822383mel_d_s
melodia1038883melodia
melodias1148703melodias
melodic1238543melodic
melodies11310123melodies
melodise1147593melodise
melodist1149743melodist
meloids10911453meloids
menads95514383menad_s
miaous8511693mi_aous
miaows1145473mi_aows
miasms1097383mi_asms
miauls8178713mi_auls
micas96823053mica__s
midair937993mida_ir
midairs1037203midairs
middays14335663middays
middies113116153mi_ddies
midi75628473mi__di_
midlands1245543midlands
mids76541783mi__d_s
mikado1344513mikad_o
milage93414123mila_ge
milchig1543653milchig
mild75330853mil_d__
milded104416153mil_ded
milden94113153mil_den
mildens10339933mildens
milder93818453mil_der
mildest102812063mil_dest
mildew12319043mil_dew
mildews13365883mildews
milding113615453mil_ding
mildly12318243mil_dly
mileages11249693mileages
milers84625163mil_ers
miles74645073mil__es
milfoil1264383milfoil
milfoils1343893milfoils
milia72719573mil__ia
miliaria1048783miliaria
miliarias1148783miliarias
milieus939803milieus
militia949733militia
militias1048633militias
milkers134411613milkers
milkfish2043333milkfish
milkmaids1841703milkmaids
milks115020583mil__ks
millages113212903millages
milldam1245473milldam
milldams1344633milldams
millers93621343millers
milles84526563mil_les
millets94216843millets
mills75435053mil__ls
milnebs11113793milnebs
milords10117853milords
milos75428013mil__os
milpas101710273mil_pas
mils66045333mil___s
milters93619093milters
milts75430713mil__ts
mimesis1137323mimesis
minas75434113mina__s
minds85427123mi_nd_s
minidisc1344143minidisc
minis75432993mi__nis
miosis83615163mi_osis
mirador1046503mirador
miradors1146853miradors
mirages102213533mirages
misacts1139353misacts
misadd1037163misad_d
misadvise1542933misadvise
misaim10311853misa_im
misaims11310113misaims
misdid10510573mi_sdid
misedit10311043misedit
misedits1147963misedits
mislaid1039303misla_id
mislain9311243misla_in
mislays12349243misla_ys
misleads11358543mislead_s
missis84417503mi_ssis
mitis75425993mi__tis
mitosis939633mitosis
molars85517323mola_rs
molas75132093mola__s
molds85324833mol_d_s
monades103713823monades
monadic1268883monadic
monadism1348023monadism
monads94515303monad_s
myasis114010473m_yasis
myiasis1245493myiasis
mylars114310443myla_rs
nicads938333nicad_s
nilgais845203nilgais
padis86227143__padis
paladin101011773paladin
paladins11911003paladins
palais8420423pala_is
pilaffs15365153pilaffs
pilafs113511023pila_fs
pilaus84114133pila_us
pilaws11399433pila_ws
pilis75825203pil__is
plaids94312443_plaids
qadis155917853__qadis
sadis64930853__sadis
salads75316963salad_s
salamis9313513salamis
sialids839723sialids
silages82514443silages
silanes72517163silanes
silds65520523sil_d_s
smilaxes1744653smilaxes
tilaks1097353tila_ks
tilapia945553tilapia
tilapias1045293tilapias
tildes74513963til_des
tirades8311723tirades
tsadis7429133_tsadis
tuladi765723tuladi_
unlades82612833unlades
wadis95223963__wadis
wildish1446853wil_dish
wilds94818203wil_d_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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271975.82623005.0
3Display Results1971970.0802462.5
 (SQL Overall)1786911976.06229477.2
 
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.