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

253 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
milts7543071(None) 
gilts64924261gilts
hilts86924411hilts
jilts124717411jilts
kilts95122181kilts
lilts55822801lilts
malts76331751malts
melts74930101melts
milds86422051milds
miles74645071miles
milks115020581milks
mills75435051mills
milos75428011milos
mils66045331mil_s
milt65455811milt_
milty104720071milty
mints76834041mints
mists76633901mists
mitts75523751mitts
molts76032091molts
silts55330821silts
tilts55325611tilts
wilts85023501wilts
ails45654712ail_s
airts55626342airts
aits46355532ai_ts
alts46639902_alts
belts75931162belts
biles75542142biles
bilks115117892bilks
bills75632862bills
bints76130182bints
bits66148162bi_ts
bitts75022592bitts
bolts76232112bolts
celts75325782celts
cists76624532cists
colts76633292colts
cults75022552cults
delts65731792delts
diets66026642diets
dills65530972dills
dints67431312dints
dirts66824462dirts
dits56450522di_ts
dolts65626312dolts
emits75421472emi_ts
felts85324542felts
fiats85324482fiats
files85441272files
filets94718952filets
fills84632372fills
films105617962films
filos86125382filos
fils75838692fil_s
filth115015822filth
filths12389782filths
fists85527542fists
fits76043462fi_ts
flits85625222flits
gelts65924612gelts
gifts96214962gifts
gilds75417522gilds
gills64728192gills
gilt56348542gilt_
girts65423622girts
gists66026192gists
gits55744592gi_ts
guilts74111232guilts
halts85230102halts
hills85431352hills
hilt75850712hilt_
hilus84817642hilus
hints87330622hints
hists86328372hists
hits75545132hi_ts
holts85627912holts
ilks87218572_ilks
ills47030422_ills
its35538832_i_ts
jills125122822jills
jilt115839422jilt_
jolts125018882jolts
kelts95222632kelts
kills94526172kills
kilns95112982kilns
kilos95021472kilos
kilt86144422kilt_
kilty125213892kilty
kists95822112kists
kits86441772ki_ts
lifts85719062lifts
lilos55821872lilos
lilt46349942lilt_
lints57137192lints
lists56628692lists
lits46252492li_ts
mailes84329112mailes
maills84215282maills
mails76037782mail_s
maists85817572maists
males75049792males
malls76233432malls
malms95021552malms
malt66254812malt_
malty106721702malty
marts77442232marts
masts77035762masts
mats65460292m_ats
matts76829182matts
mauts75927192mauts
meats75034052meats
meets74224612meets
melds84822382melds
mells75031332mells
mels65941532mel_s
melt65752892melt_
melty104918362melty
mibs85330482mi_bs
micas96823052micas
micks135525372micks
mics87435152mi_cs
midis85923412midis
mids76541792mi_ds
midst85922552midst
midsts95510052midsts
miens76118302miens
miffs134512882miffs
miggs96311372miggs
mights123516252mights
migs76935322mi_gs
mikes115129892mikes
mil55752112mil__
milch124413372milch
mild75330852mil_d
mile66352572mil_e
miler75733062miler
milers84625162milers
milia72719572milia
milk105028472mil_k
milky144014442milky
mill66541482mil_l
mille75029132mille
milles84526562milles
millets94216842millets
milo65536102mil_o
milpa92111402milpa
milpas101710272milpas
milted93919942milted
milter84921232milter
milters93619092milters
mimes95732022mimes
minas75434112minas
minds85427122minds
mines75651952mines
minis75432992minis
minks115829272minks
mint66758062mint_
minty106323902minty
minus75223932minus
mips85534082mi_ps
mires75640882mires
mirks115122142mirks
mirs66940572mi_rs
mirth106418892mirth
mirths114912992mirths
mis58162622mi__s
mises74740562mises
misos76523292misos
miss65339422mi_ss
mist66154532mist_
misty106120452misty
mite66249412mi_te
mites75141802mites
mitis75425992mitis
mitt66145492mi_tt
mity95528212mi_ty
mixes147224402mixes
mixt136831922mixt_
moats75827642moats
moils76125752moil_s
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molt66356162molt_
molto75619602molto
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162m_ots
motts76527002motts
moults84713702moults
mulcts10298712mulcts
mules75034292mules
mulls75124152mulls
musts75527442musts
muts64839982m_uts
mutts75120252mutts
nills54926672nills
nils46132452nil_s
nits45741642ni_ts
oils46337972oil_s
omits75018262omi_ts
pelts76128812pelts
piles74742612piles
pilis75825202pilis
pills74130972pills
pilots84018872pilots
pilus75921062pilus
pints75936222pints
pits66348742pi_ts
quilts154112542quilts
rifts85718642rifts
riles55343642riles
rills55032712rills
riots54922012riots
salts55431882salts
sifts84918922sifts
silds65520522silds
silks94620682silks
sills55135992sills
silos56029432silos
silt46558192silt_
silty84721632silty
sits45050202si_ts
slits56128852slits
smalts85214892smalts
smelts85412772smelts
smiles84522292smiles
smolts84411882smolts
stilts67915312stilts
tiles55542102tiles
tills54631712tills
tils45739612til_s
tilt46252422tilt_
tilth85515362tilth
tilths9459372tilths
tints56030922tints
tits46145042ti_ts
vills86429322vills
volts85421292volts
welts85225192welts
wilds94818202wilds
wiles85437872wiles
wills84528962wills
wilt76246292wilt_
wists86728522wists
wits76044872wi_ts
yills83921552yills
zills144020782zills
zits136030292zi_ts

Search took 3 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 Limit538002531.65332546.9
3Display Results2532530.0634015.9
 (SQL Overall)1786912532.02988068.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.