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

326 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
mined8533335(None) 
dined76431991dined
fined94930501fined
lined64934641lined
maned86634101maned
miked125020451miked
mimed105622731mimed
minced114114911minced
mind75434381min_d
minded103817831minded
mine67256171mine_
miner76933541miner
mines75651951mines
minted94220581minted
mired85729221mired
mixed155717251mixed
pined85935321pined
tined65434531tined
vined95626151vined
wined94434181wined
acned87520672acned
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
alined75221402alined
amine75835382amine_
amines84727982amines
awned96615952awned
baned85436352baned
bided95424962bided
biked125320032biked
bind76234512bin_d
bine66650862bine_
biner75930692biner
bines76946792bines
binged105920822binged
binned94414542binned
biped104718832biped
boned85133242boned
brined95118412brined
caned85838092caned
chined125620062chined
cine66242942cine_
cines75239682cines
cited84421952cited
coined94523602coined
coned86040052coned
diced95824682diced
died66137852di_ed
diked115024682diked
dine55555332dine_
diner65632902diner
dines66449152dines
dinged95221782dinged
dinked124818352dinked
dinned84317612dinned
dinted84419842dinted
dived106321372dived
dwined114610212dwined
ermined10410602ermined
fiend95312982fiend
fifed125115972fifed
filed95331902filed
find87532602fin_d
fine75147952fine_
finer85431562finer
fines86644262fines
finked144214622finked
finned104114602finned
fired94829742fired
fixed165416952fixed
foined105915012foined
gained84617462gained
gibed96215962gibed
gied64631982gi_ed
ginned83813982ginned
girned84010512girned
hided105222442hided
hied85434042hi_ed
hiked135919202hiked
hind85529752hin_d
hinged114618922hinged
hinted104318322hinted
hired95226262hired
hived125217912hived
honed95332262honed
iced78721892_iced
imbed105013652imbed
imine75821062imine_
imines84918352imines
imped105117982imped
inked104218522_inked
inned64118422inned
ired55131872_ired
jibed155114162jibed
jinked184013142jinked
jinxed21346082jinxed
jived165115042jived
joined144613072joined
kilned11368392kilned
kind96128552kin_d
kine85643422kine_
kines95039132kines
kinged124215292kinged
kinked104014752kinked
kirned11408622kirned
kited105120092kited
lied55838092li_ed
liked104523812liked
limed85426802limed
limned94811472limned
line46965572line_
linen55728722linen
liner55938922liner
lines57054572lines
liney87029632liney
linked114518212linked
linted74021822linted
lived95523722lived
maced108528692maced
mailed95326752mailed
maimed114812662maimed
mane65052032mane_
manes76648962manes
manned94418642manned
mated85537782mated
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
med66146742m__ed
meed74934702m_eed
menad85918982menad
mend75334032men_d
mended104418682mended
mensed93916542mensed
meted85424432meted
mewed115218012mewed
mice87442232mice_
miched143913392miched
mid67354462mi__d
mien65028362mi_en
miens76118302miens
miffed15398712miffed
mike105535292mike_
mikes115129892mikes
mild75330852mi_ld
milded104416152milded
mile66352572mile_
miler75733062miler
miles74645072miles
milked134612572milked
milled94326172milled
milneb1095952milneb
milted93919942milted
mime85736402mime_
mimeo96018682mimeo
mimer94825762mimer
mimes95732022mimes
mina65136922min_a
minae75627722minae
minas75434112minas
mince95325232mince
mincer104017362mincer
minces104420802minces
mincy125817412mincy
minder94822502minder
minds85427122minds
miners84126632miners
mingled113612732mingled
mingy115520182mingy
mini65634562min_i
minim97321602minim
minis75432992minis
mink106636532min_k
minke115421762minke
minkes124618782minkes
minks115829272minks
minny104518662minny
minor74920062minor
minored10310102minored
mint66758062min_t
minter84425102minter
mints76834042mints
minty106323902minty
minuend1035382minuend
minuet82621032minuet
minus75223932minus
minuted10329502minuted
minx137723352min_x
minxes154612982minxes
mire66748232mire_
mires75640882mires
mirex146816622mirex
mise66043582mise_
miser75430402miser
mises74740562mises
misfed124113022misfed
misled94719312misled
missed94423602missed
misted93625822misted
mite66249412mite_
miter75734792miter
mites75141802mites
mitred94414342mitred
mixer145017642mixer
mixes147224402mixes
mizen164815272mizen
moaned94514172moaned
moiled94318862moiled
monad85519472monad
monde85723142monde
money104826842money
monied94319462monied
mooed85123982mooed
mooned94216642mooned
moped105424732moped
moved114218152moved
mowed113629012mowed
muled85824432muled
mured85726702mured
mused85524582mused
muted85023382muted
mutined103311352mutined
nided75920872nided
nine45842172nine_
nines55937342nines
nixed135714222nixed
oiled64429472oiled
oinked114213282oinked
omened93711002omened
opined95113852opined
owned95113232owned
pained95622852pained
paned85437182paned
peined94918842peined
pied75035362pi_ed
piked125623312piked
piled85232992piled
pine67755712pine_
pines76048862pines
piney105727502piney
pinged104321382pinged
pinked134819882pinked
pinned94818382pinned
piped105123162piped
rained75024602rained
reined74425522reined
riced85825542riced
riled65833252riled
rimed84826372rimed
rind56535602rin_d
rinded84418982rinded
ringed84623842ringed
rinsed75016352rinsed
riped85226432riped
rived94825612rived
ruined74813322ruined
sained75424242sained
saned65636272saned
seined74023062seined
shined104620782shined
sided74825952sided
signed83413752signed
sine46560622sine_
sines55954822sines
sinew84718922sinew
singed85422292singed
sinned73818412sinned
siped84927682siped
sired66134282sired
sited65130742sited
sized155519242sized
smiled93716432smiled
sned56026052_sned
spined95423942spined
tided76322512tided
tied55535212ti_ed
tiled64832942tiled
timed85223612timed
tine45855132tine_
tinea54923162tinea
tineid74412022tineid
tines54848422tines
tinged84220802tinged
tinned74317532tinned
tinted74419532tinted
tired65228902tired
toned65435342toned
trined74920712trined
tuned64622312tuned
twined104413122twined
tyned95915012tyned
unmined102612952unmined
vaned94622422vaned
veined104413912veined
viced115118182viced
vied86328632vi_ed
vine75643682vine_
vines85137642vines
vised95518762vised
waned95831782waned
whined134715202whined
wifed125117742wifed
wiled95231552wiled
winced124415342winced
wind85533852win_d
winded114918212winded
wine74953422wine_
wines85546862wines
winey115325432winey
winged114620832winged
winked144018602winked
winned104017012winned
wiped114722082wiped
wired95327642wired
wised95123342wised
wited94727142wited
wived125121502wived
zinced18419412zinced
zine137036152zine_
zineb165614142zineb
zines145232652zines
zinged174414622zinged
zoned154020262zoned

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.310576422.6
2DLD Change Limit538003261.53335094.6
3Display Results3263260.0933505.4
 (SQL Overall)1786913261.93692299.1
 
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.