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

337 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
dined7643199(None) 
diced95824681diced
died66137851di_ed
diked115024681diked
dine55555331dine_
diner65632901diner
dines66449151dines
dinged95221781dinged
dinked124818351dinked
dinned84317611dinned
dinted84419841dinted
dived106321371dived
dwined114610211dwined
fined94930501fined
lined64934641lined
mined85333351mined
pined85935321pined
tined65434531tined
vined95626151vined
wined94434181wined
acned87520662acned
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
alined75221402alined
awned96615952awned
baned85436352baned
bided95424962bided
biked125320032biked
bind76234502bin_d
bine66650852bine_
biner75930692biner
bines76946792bines
binged105920822binged
binned94414542binned
biped104718832biped
boned85133242boned
brined95118412brined
caned85838092caned
chined125620062chined
cine66242942cine_
cines75239682cines
cited84421952cited
coined94523602coined
coned86040052coned
damned104212912damned
danced105315252danced
danged94819482danged
dared75935012dared
darned85018482darned
dated75530992dated
dawed106222812dawed
dawned113912092dawned
dazed165919362dazed
deaned84620452deaned
deed65340902d_eed
defined123813822defined
deiced104214482deiced
deigned1037502deigned
deked115718532deked
deled75326542deled
dene56643412dene_
denes65639722denes
denied84318632denied
denned84215632denned
dented84120512dented
dewed105020302dewed
dialed84716452dialed
dibbed124713472dibbed
dice75841892dice_
dicer85426422dicer
dices86434242dices
dicey114819332dicey
dicked144920862dicked
did56850512di__d
die46759652di_e_
diel59034602di_el
diene65720132diene
dienes75719902dienes
dies55653522di_es
diet57357532di_et
dieted83115492dieted
digged104314652digged
dike95935762dike_
diker105524552diker
dikes105831332dikes
dikey135116422dikey
dilled84122222dilled
dime76237642dime_
dimer85625602dimer
dimes85833042dimes
dimmed124110322dimmed
din46459462din__
dinar66319892dinar
dindled104412722dindled
dinero75612642dinero
diners75525952diners
ding66940952din_g
dinge75627302dinge
dinger85323662dinger
dinges83825422dinges
dingey114914042dingey
dingo74720792dingo
dings76331402dings
dingy105721262dingy
dink97137802din_k
dinkey144812762dinkey
dinks105927952dinks
dinky135819372dinky
dinner74217152dinner
dino56036752din_o
dinos65428062dinos
dins56652042din_s
dint56759052din_t
dints67431312dints
diode74716112diode
dipnet91317472dipnet
dipped123517492dipped
dire56644142dire_
direr64927072direr
dirked124912272dirked
dirled84514902dirled
disced104914652disced
dished114318712dished
disked125015762disked
dissed85220172dissed
dite55547552dite_
dites66339152dites
dive85634772dive_
diver94827802diver
dives95832402dives
divined12329692divined
dizen155214932dizen
dizened18267332dizened
doiled84817292doiled
doited85016632doited
doled75430912doled
domed95423262domed
done55747912done_
donee66931012donee
donned85015742donned
doped95326712doped
dosed76626912dosed
doted75227072doted
dowed104632612dowed
downed115314782downed
dozed165619352dozed
drained93713252drained
dreed75222842dreed
dried75321382dried
droned84616862droned
duded84417132duded
duked115218462duked
dune56137582dune_
dunes65332172dunes
dunged95414692dunged
dunked124315282dunked
dunned85015522dunned
dunted84718502dunted
duped95118322duped
dured75025402dured
durned84113172durned
dwine95616142dwine_
dwines105013102dwines
dyed96720762d_yed
dyked145310952dyked
dyne85320932dyne_
dynel9569852dynel
dynes95917582dynes
edited83913672edited
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
hinged114618912hinged
hinted104318322hinted
hired95226262hired
hived125217912hived
honed95332262honed
iced78721892_iced
idled74915212idled
inked104218522_inked
inned64118422inned
ired55131872_ired
jibed155114162jibed
jinked184013142jinked
jinxed21346082jinxed
jived165115042jived
joined144613072joined
kilned11368392kilned
kind96128552kin_d
kine85643422kine_
kines95039132kines
kinged124215282kinged
kinked104014752kinked
kirned11408622kirned
kited105120092kited
lied55838092li_ed
liked104523812liked
limed85426802limed
limned94811472limned
line46965572line_
linen55728722linen
liner55938912liner
lines57054572lines
liney87029622liney
linked114518212linked
linted74021822linted
lived95523722lived
maned86634092maned
miked125020452miked
mimed105622732mimed
minced114114912minced
mind75434362min_d
minded103817832minded
mine67256152mine_
miner76933542miner
mines75651952mines
minted94220582minted
mired85729222mired
mixed155717252mixed
nided75920872nided
nine45842172nine_
nines55937342nines
nixed135714222nixed
oiled64429472oiled
oinked114213282oinked
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
sned56026052_sned
spined95423942spined
tided76322512tided
tied55535212ti_ed
tiled64832942tiled
timed85223612timed
tine45855132tine_
tinea54923152tinea
tineid74412012tineid
tines54848422tines
tinged84220792tinged
tinned74317532tinned
tinted74419532tinted
tired65228902tired
toned65435342toned
trined74920712trined
tuned64622312tuned
twined104413122twined
tyned95915012tyned
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.0961861364.6
2DLD Change Limit538003371.64032804.9
3Display Results3373370.0933623.7
 (SQL Overall)1786913371.82997698.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.