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 “milds” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

206 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
milds8642205(None) 
gilds75417521gilds
melds84822381melds
mids76541781mi_ds
mild75330851mild_
miles74645071miles
milks115020581milks
mills75435051mills
milos75428011milos
mils66045331mil_s
milts75430711milts
minds85427121minds
molds85324831molds
silds65520521silds
wilds94818201wilds
aids57846352ai_ds
ails45654712ail_s
amids85627512ami_ds
balds85524642balds
bids75838432bi_ds
bields94110002bields
biles75542142biles
bilks115117892bilks
bills75632862bills
binds86627472binds
birds85421332birds
bolds85825282bolds
builds9378492builds
colds85726972colds
dildo71911772dildo
dildos8179302dildos
dills65530972dills
elds56324852_elds
fids87034732fi_ds
fields104211042fields
files85441272files
fills84632372fills
films105617962films
filos86125382filos
fils75838692fil_s
finds95424822finds
folds95221692folds
gelds75118342gelds
gids65933732gi_ds
gild65526512gild_
gills64728192gills
gilts64924262gilts
girds74816992girds
golds75421312golds
guilds8388352guilds
hills85431352hills
hilts86924412hilts
hilus84817642hilus
hinds96721472hinds
holds94623242holds
ids47535462_i_ds
ilks87218572_ilks
ills47030422_ills
imids86015142imids
jills125122822jills
jilts124717412jilts
kids96029632ki_ds
kills94526172kills
kilns95112982kilns
kilos95021472kilos
kilts95122182kilts
kinds106221812kinds
lids56336452li_ds
lilos55821872lilos
lilts55822802lilts
mads76845372m_ads
maids86327142maids
mailes84329112mailes
maills84215282maills
mails76037782mail_s
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
mauds85519272mauds
meads85425322meads
meds75735362m_eds
meeds84920272meeds
meld75830472meld_
mells75031332mells
mels65941532mel_s
melts74930102melts
mends84927692mends
mibs85330482mi_bs
micas96823052micas
micks135525372micks
mics87435152mi_cs
mid67354462mi_d_
middy124812592middy
midi75628472mi_di
midis85923412midis
midst85922552mi_dst
miens76118302miens
miffs134512882miffs
miggs96311372miggs
migs76935322mi_gs
mikes115129892mikes
mil55752112mil__
miladi938882miladi
miladis1049822miladis
milady1236612milady
milch124413372milch
milded104416152milded
milden94113152milden
mildens10339932mildens
milder93818452milder
mildest102812062mildest
mildew12319042mildew
mildews13365882mildews
mildly12318242mildly
mile66352572mil_e
miler75733062miler
milers84625162milers
milia72719572milia
milk105028472mil_k
milky144014442milky
mill66541482mil_l
mille75029132mille
milles84526562milles
milo65536102mil_o
milords10117852milords
milpa92111402milpa
milpas101710272milpas
milt65455812mil_t
milty104720072milty
mimes95732022mimes
minas75434112minas
mind75434382mind_
mines75651952mines
minis75432992minis
minks115829272minks
mints76834042mints
minus75223932minus
mips85534082mi_ps
mires75640882mires
mirks115122142mirks
mirs66940572mi_rs
mis58162622mi__s
misdo85413182misdo
mises74740562mises
misos76523292misos
miss65339422mi_ss
mists76633902mists
mites75141802mites
mitis75425992mitis
mitts75523752mitts
mixes147224402mixes
mods77945052m_ods
moils76125752moil_s
molas75132092molas
mold76034332mold_
moldy115014652moldy
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
moods85224622moods
moulds94910992moulds
muds75530652m_uds
mules75034292mules
mulls75124152mulls
nills54926672nills
nils46132452nil_s
oils46337972oil_s
olds55926572_olds
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
rids56539542ri_ds
riles55343642riles
rills55032712rills
rinds64826142rinds
sild55030582sild_
silks94620682silks
sills55135992sills
silos56029432silos
silts55330822silts
smiles84522292smiles
tilde65017342tilde
tildes74513962tildes
tiles55542102tiles
tills54631712tills
tils45739612til_s
tilts55325612tilts
velds95615582velds
vids85627532vi_ds
vills86429322vills
welds94719162welds
wields10469622wields
wild85126512wild_
wiles85437872wiles
wills84528962wills
wilts85023502wilts
winds95425602winds
wolds95420182wolds
yids85224952yi_ds
yields10466842yields
yills83921552yills
yirds96612512yirds
zills144020782zills

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538002061.54634799.5
3Display Results2062060.0464478.3
 (SQL Overall)1786912061.90593801.0
 
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.