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

400 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
paned8543718(None) 
baned85436351baned
caned85838091caned
maned86634101maned
paced106931681paced
paged95926781paged
pained95622851pained
paled85538721paled
pane64950291pane_
panel76023621panel
panes76148691panes
panged104722341panged
panned94123431panned
panted95024821panted
pared86946761pared
pated85237841pated
paved115525261paved
pawed115725611pawed
pawned124513281pawned
payed115925931payed
pined85935321pined
planed94420911planed
saned65636271saned
vaned94622421vaned
waned95831781waned
aahed917816442aahed
abed79734132_abed
aced79540882_aced
acned87520672acned
aged67334252_aged
ahed89536252_ahed
and47244182_an_d
ane37866952_ane_
anes45255932_anes
anew76623132_anew
anted66328242_anted
aped78538152_aped
apnea73413412apnea
awed88436032_awed
awned96615952awned
axed128829612_axed
baaed85218162baaed
baked126130772baked
baled85436442baled
band76740922ban_d
banded105223172banded
bane65250432bane_
banes74945582banes
banged104923732banged
banked135021442banked
banned94721342banned
bared85144482bared
barned95623582barned
based85331582based
bated85935532bated
bayed115423022bayed
beaned95621472beaned
boned85133242boned
caged95426362caged
caked126128622caked
cane66653122cane_
caner75334772caner
canes75350372canes
canid85526342canid
canned95022062canned
canoed94618962canoed
canted94825782canted
caped104931802caped
cared86050092cared
cased86032412cased
caved116227562caved
cawed116627062cawed
coned86040052coned
craned96121652craned
damned104212912damned
danced105315252danced
danged94819492danged
dared75935012dared
darned85018482darned
dated75530992dated
dawed106222812dawed
dawned113912092dawned
dazed165919362dazed
deaned84620452deaned
dined76431992dined
eared65139502eared
earned74818332earned
eased65430402eased
eaved95924502eaved
faced117727652faced
faded105025242faded
faked135225482faked
famed115928342famed
fane75343572fane_
fanes84639892fanes
fanged114318232fanged
fanned104117472fanned
fared95842342fared
fated95632132fated
fawned134910422fawned
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
fined94930502fined
gaed66031512ga_ed
gaged85522312gaged
gained84617462gained
gamed95126392gamed
gane55145302gane_
ganef96322462ganef
ganev95513862ganev
ganged94619202ganged
gaped96123532gaped
gated75329772gated
gazed165520332gazed
haded105227622haded
haed86338582ha_ed
haled95335822haled
hand86833712han_d
handed114919982handed
hanged114222402hanged
hanked144220602hanked
hanted104124312hanted
hared95742182hared
hated95734022hated
hawed126025422hawed
hayed125822012hayed
hazed185222202hazed
honed95332262honed
inned64118422inned
jaded144417032jaded
jane115031482jane_
janes124928122janes
japed156217632japed
jawed165517372jawed
jeaned143813462jeaned
kane85133982kane_
kanes95529372kanes
laced87132642laced
laded74232612laded
laked105731122laked
lamed85235292lamed
lanced93717722lanced
land56337312lan_d
landed84619242landed
lane45153332lane_
lanes54946792lanes
lased65132342lased
lated65240672lated
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
leaned73422542leaned
lined64934642lined
loaned73816292loaned
maced108528692maced
mane65052032mane_
manes76648962manes
manned94418642manned
mated85537782mated
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
mined85333352mined
moaned94514172moaned
naked105320852naked
naled65525052naled
named85223062named
oared65030652oared
opened94311862opened
opined95113852opined
owned95113232owned
pace86345772pace_
pacer96131612pacer
paces96741112paces
pacey126720282pacey
packed154822602packed
pad68057332pa__d
padded114113502padded
page76036102page_
pager84728202pager
pages85235072pages
pagod95013682pagod
paid75737492pa_id
paiked135113432paiked
painted104214632painted
paired95017522paired
pale66055012pale_
palea75028662palea
paler75436942paler
pales75753802pales
palet74650802palet
palled94625162palled
palmed114314642palmed
palped114513642palped
pan58466452pan__
panada94113052panada
panda85022612panda
pander93725532pander
pandied113913442pandied
pandy115021172pandy
paneled10612572paneled
panels84716522panels
pang75336302pan_g
panga85323542panga
pangen94115922pangen
pangs84628672pangs
panic93923902panic
panier84425502panier
panne76623652panne
panner84224762panner
pannes85522852pannes
pans65855732pan_s
pansy105717972pansy
pant66061262pan_t
panto76129412panto
pants76536922pants
panty105929302panty
panzer174213232panzer
paper95128662paper
pard76441322pa_rd
pare66760842pare_
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parged104922042parged
parked134425142parked
parled94626292parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pase65346862pase_
paseo77022512paseo
pases75346502pases
pashed125923142pashed
passed94320942passed
pasted94426902pasted
pate65350462pate_
paten74827342paten
pater74740732pater
pates76047892pates
patined105114782patined
patted94724682patted
paused95114962paused
pave96133892pave_
paveed12438892paveed
paver104225832paver
paves104833922paves
pavid115717002pavid
pawer104422972pawer
pawnee113115402pawnee
pawner114212922pawner
paxes144928422paxes
payee105524722payee
payer105125722payer
peaced115818912peaced
peaked136117402peaked
pealed95322812pealed
ped66751532p__ed
peed76239182p_eed
peened94318162peened
peined94918842peined
pend75934532pen_d
pended103819012pended
penes75839222penes
penned94217612penned
phased124011972phased
phoned124014552phoned
pied75035372p_ied
piked125623312piked
piled85232992piled
pine67755722pine_
pines76048862pines
piney105727502piney
pinged104321382pinged
pinked134819882pinked
pinned94818382pinned
piped105123162piped
placed114318002placed
plained103812232plained
plane74929142plane_
planer84122662planer
planes85028082planes
planet84228352planet
planked143512282planked
planned103810152planned
planted103516122planted
plated95225772plated
played124815032played
pled75231432p_led
plied85118592plied
poked125425392poked
poled84934842poled
ponced114314812ponced
pond75530492pon_d
ponded105218772ponded
pone65747532pone_
pones74547042pones
ponged105619352ponged
ponied94920702ponied
pooed85226242pooed
pored85234512pored
posed85828412posed
poxed154817862poxed
pranced123714042pranced
pranged114512552pranged
pranked143712092pranked
prated94924922prated
prawned1346742prawned
prayed124815432prayed
preed85128122preed
pried84426862pried
pruned93413112pruned
puked124716222puked
puled84926522puled
punned93416192punned
punted94618712punted
raced87635312raced
raged74829452raged
rained75024602rained
raked105831422raked
rand55839572ran_d
ranee55438102ranee
ranged84824322ranged
ranid66429332ranid
ranked114620742ranked
ranted74324702ranted
raped85334622raped
rared65738322rared
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
sabed86526812sabed
sained75424242sained
sand55338472san_d
sanded84920612sanded
sane45954342sane_
saner54334322saner
sanes55649072sanes
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
sned56026052_sned
spaced114517252spaced
spaded103816752spaded
spaed85522272spa_ed
spanked143111732spanked
spanned104111222spanned
spared95427492spared
spawned13316802spawned
spayed124213612spayed
speaned103411522speaned
spined95423942spined
staned74824642staned
tamed85528512tamed
tanged84622512tanged
tanked113919302tanked
tanned75219962tanned
taped85327422taped
tared69340052tared
tawed95926192tawed
taxed135620292taxed
tined65434532tined
toned65435342toned
tuned64622312tuned
tyned95915012tyned
vane75534692vane_
vanes85130982vanes
vanned104614482vanned
vined95626152vined
waded106024752waded
waged104822782waged
waked135626752waked
waled94331002waled
wand85833882wan_d
wane76344722wane_
wanes85040882wanes
waney115120322waney
wanked144517152wanked
wanned104318012wanned
wanted104319722wanted
wared96339872wared
warned104018912warned
waved125223582waved
waxed166018482waxed
weaned103816152weaned
wined94434182wined
yanked144312242yanked
yarned105514022yarned
yawed126022452yawed
yawned13509842yawned
yeaned103813902yeaned
zoned154020262zoned

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.343520965.0
2DLD Change Limit538004001.89328420.5
3Display Results4004000.1233252.0
 (SQL Overall)1786914002.35975748.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.