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

372 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
lined6493464(None) 
alined75221401alined
dined76431991dined
fined94930501fined
lied55838091li_ed
liked104523811liked
limed85426801limed
limned94811471limned
line46965571line_
linen55728721linen
liner55938921liner
lines57054571lines
liney87029631liney
linked114518211linked
linted74021821linted
lived95523721lived
mined85333351mined
pined85935321pined
tined65434531tined
vined95626151vined
wined94434181wined
acned87520672acned
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
aliened81011742aliened
aligned9128552aligned
aline57243152aline_
aliner65621982aliner
alines65735222alines
aliped95414282aliped
awned96615952awned
baned85436352baned
bided95424962bided
biked125320032biked
bind76234512bin_d
bine66650862bine_
biner75930692biner
bines76946792bines
binged105920822binged
binned94414542binned
biped104718832biped
blind86319322blin_d
blinded114810022blinded
blinked144010012blinked
boned85133242boned
brined95118412brined
bylined1335852bylined
caned85838092caned
chined125620062chined
cine66242942cine_
cines75239682cines
cited84421952cited
cline76428532cline_
clines84926042clines
clinged113310092clinged
clinked144011642clinked
cloned94518802cloned
coined94523602coined
coned86040052coned
diced95824682diced
died66137852di_ed
diked115024682diked
dine55555332dine_
diner65632902diner
dines66449152dines
dinged95221782dinged
dinked124818352dinked
dinned84317612dinned
dinted84419842dinted
dived106321372dived
dwined114610212dwined
elided84814672elided
eloined8149812eloined
fiend95312982fiend
fifed125115972fifed
filed95331902filed
find87532602fin_d
fine75147952fine_
finer85431562finer
fines86644262fines
finked144214622finked
finned104114602finned
fired94829742fired
fixed165416952fixed
flied96519432fli_ed
flinted114411892flinted
flited104616582flited
foined105915012foined
gained84617462gained
gibed96215962gibed
gied64631982gi_ed
ginned83813982ginned
girned84010512girned
glided94513902glided
glimed105312282glimed
glinted9399372glinted
hided105222442hided
hied85434042hi_ed
hiked135919202hiked
hind85529752hin_d
hinged114618922hinged
hinted104318322hinted
hired95226262hired
hived125217912hived
honed95332262honed
iced78721892_iced
inked104218522_inked
inned64118422inned
ired55131872_ired
jibed155114162jibed
jinked184013142jinked
jinxed21346082jinxed
jived165115042jived
joined144613072joined
kilned11368392kilned
kind96128562kin_d
kine85643432kine_
kines95039132kines
kinged124215292kinged
kinked104014752kinked
kirned11408622kirned
kited105120092kited
laced87132642laced
laded74232612laded
laired75216812laired
laked105731122laked
lamed85235292lamed
lanced93717722lanced
land56337312lan_d
landed84619242landed
lane45153332lane_
lanes54946792lanes
lased65132342lased
lated65240672lated
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
leaned73422542leaned
led46254552l__ed
lend56233672len_d
lenes54738522lenes
lensed74015472lensed
liane54720662liane_
lianes63819322lianes
liard65418592liard
libel74116102libel
liber74723622liber
lice66045062lice_
licked134621562licked
lid47453522li__d
lidded93410242lidded
lie38264522li_e_
lief76036992li_ef
lien45339802li_en
liens56525502liens
lier45942462li_er
lies46454192li_es
lieu46534362li_eu
life75433732life_
lifer85822152lifer
lifted104413522lifted
liger65024472liger
like86040842like_
liken911818842liken
likened12267352likened
liker95627062liker
likes96231902likes
lilied73913212lilied
lilted73715372lilted
limbed114513182limbed
lime66244932lime_
limen75426032limen
limes75636502limes
limey104721042limey
limner84112872limner
limped114817122limped
lin37967372lin__
linac7315412linac
linden7411452linden
lindy96918312lindy
lineal65616032lineal
linear65113342linear
linens64818392linens
lineny94011442lineny
liners65428852liners
lineup835982lineup
ling57447962lin_g
linga66820822linga
linger75226002linger
lingo66022112lingo
lings67135772lings
lingy96925142lingy
linier64423792linier
linin58025522linin
link86943442lin_k
linker104321472linker
links96430192links
linky127622382linky
linn46034592lin_n
linnet6419422linnet
linns56123332linns
lino46343372lin_o
linos55631502linos
lins47059052lin_s
linseed838202linseed
linsey938992linsey
lint416266232lin_t
lintel64013992lintel
linter64625342linter
lints57137192lints
linty87126562linty
linum7313822linum
liny78141322lin_y
lipe66839732lipe_
lipid85916172lipid
lipped114419542lipped
lire47845292lire_
lisped94113422lisped
listed74322832listed
lite47054542lite_
liter54736342liter
live76540992live_
liven85021732liven
livened11238932livened
liver85132962liver
lives86133192lives
livid96714422livid
loaned73816292loaned
lobed86022132lobed
loided83414022loided
lone45849132lone_
loner55431042loner
longed87121372longed
looed64626132looed
loped85128332loped
loved95021362loved
lowed95233902lowed
loxed135017052loxed
lubed85319892lubed
luged74019092luged
lune47140492lune_
lunes55337772lunes
lunet56835422lunet
lunged85418272lunged
lunted74517522lunted
lured65427492lured
luted64826142luted
lysed95011562lysed
maned86634102maned
miked125020452miked
mimed105622732mimed
minced114114912minced
mind75434382min_d
minded103817832minded
mine67256172mine_
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
plained103812232plained
planed94420912planed
plied85118592pli_ed
plinked143910892plinked
rained75024602rained
reined74425522reined
relined85321932relined
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
sliced94416312sliced
slimed94915122slimed
slinked123011382slinked
sliped95417062sliped
sned56026052_sned
spined95423942spined
splined105013112splined
tided76322512tided
tied55535212ti_ed
tiled64832942tiled
timed85223612timed
tine45855132tine_
tinea54923162tinea
tineid74412022tineid
tines54848422tines
tinged84220812tinged
tinned74317532tinned
tinted74419532tinted
tired65228902tired
toned65435342toned
trined74920712trined
tuned64622312tuned
twined104413122twined
tyned95915012tyned
unlined82515802unlined
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.313570897.8
2DLD Change Limit538003721.43637465.2
3Display Results3723720.0934000.0
 (SQL Overall)1786913721.84297009.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.