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

457 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
pared8694676(None) 
bared85144481bared
cared86050091cared
dared75935011dared
eared65139501eared
fared95842341fared
hared95742181hared
oared65030651oared
paced106931681paced
paged95926781paged
paired95017521paired
paled85538721paled
paned85437181paned
pard76441321par_d
pare66760841pare_
pareo74632601pareo
parer75839901parer
pares77164481pares
pareu74928741pareu
parged104922041parged
parked134425141parked
parled94626291parled
parred95024071parred
parsed96323891parsed
parted94228681parted
pated85237841pated
paved115525261paved
pawed115725611pawed
payed115925931payed
pored85234511pored
rared65738321rared
spared95427491spared
tared69340051tared
wared96339871wared
aahed917816442aahed
abed79734132_abed
aced79540882_aced
acred87126352acred
aged67334252_aged
ahed89536252_ahed
aired66032922aired
aped78538152_aped
apres75426402apres
arced88224162_arced
are37874572_are_
area45843392_area
ares45871022_ares
arid57642712_arid
armed86324432_armed
awed88436032_awed
axed128829612_axed
baaed85218162baaed
baked126130772baked
baled85436442baled
baned85436352baned
barbed115121312barbed
bard75648862bar_d
barde85330772barde
barded105426422barded
bare65460522bare_
barer74535802barer
bares75457132bares
barfed125416382barfed
barged105822642barged
barked135027312barked
barned95623582barned
barred95725792barred
based85331582based
bated85935532bated
bayed115423022bayed
blared95018242blared
bored85034302bored
bred75130972_bred
caged95426362caged
caked126128622caked
caned85838092caned
caped104931802caped
card710245872car_d
carded105424902carded
care66968372care_
carer74942332carer
cares77369182cares
caret75360562caret
carex144822302carex
caried94528692caried
carked134024822carked
carped115923762carped
carted98631442carted
carved124320852carved
cased86032412cased
caved116227562caved
cawed116627062cawed
cered85227442cered
chared125423692chared
cored85044222cored
cred76530882_cred
cured85932132cured
dare55848862dare_
darer65230792darer
dares66146702dares
darked123919632darked
darned85018482darned
darted84620922darted
dated75530992dated
dawed106222812dawed
dazed165919362dazed
dured75025402dured
earned74818332earned
eased65430402eased
eaved95924502eaved
erred65915672erred
faced117727652faced
faded105025242faded
faired105915772faired
faked135225482faked
famed115928342famed
farad95720672farad
farced125216532farced
fard85639062far_d
farded114518952farded
fare76354462fare_
farer86733142farer
fares85852872fares
farmed125117652farmed
farted105121782farted
fated95632132fated
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
feared106320432feared
fired94829742fired
flared105317602flared
gaed66031512ga_ed
gaged85522312gaged
gamed95126392gamed
gaped96123532gaped
garbed104815662garbed
garred85217412garred
gated75329772gated
gazed165520332gazed
geared85317742geared
glared84715202glared
gored75227082gored
gyred105114092gyred
haded105227622haded
haed86338582ha_ed
haired105117172haired
haled95335822haled
hard85443502har_d
hare76255732hare_
harem104924452harem
hares86255542hares
harked145422552harked
harmed125218832harmed
harped124418402harped
hated95734022hated
hatred104814332hatred
hawed126025422hawed
hayed125822012hayed
hazed185222202hazed
hired95226262hired
ired55131872_ired
jaded144417032jaded
japed156217632japed
jarred144613252jarred
jawed165517372jawed
laced87132642laced
laded74232612laded
laired75216812laired
laked105731122laked
lamed85235292lamed
lard56742002lar_d
larded84319092larded
laree56036292laree
lares54852632lares
larked114519472larked
lased65132342lased
lated65240672lated
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
lured65427492lured
maced108528692maced
maned86634102maned
mare64759332mare_
mares76457632mares
marked133921622marked
marled95523162marled
marred95421042marred
marted94425212marted
mated85537782mated
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
mired85729222mired
mured85726702mured
nacred95212492nacred
naked105320852naked
naled65525052naled
named85223062named
nard56634452nar_d
nares55544152nares
narked114116742narked
neared75119802neared
pace86345772pace_
pacer96131612pacer
paces96741112paces
pacey126720282pacey
packed154822602packed
pad68057322pa__d
padded114113502padded
padre86018162padre_
padres95016982padres
page76036102page_
pager84728202pager
pages85235072pages
pagod95013682pagod
paid75737482pa_id
paiked135113432paiked
pained95622852pained
pale66055012pale_
palea75028662palea
paler75436932paler
pales75753802pales
palet74650802palet
palled94625162palled
palmed114314642palmed
palped114513642palped
pane64950292pane_
panel76023622panel
panes76148692panes
panged104722332panged
panned94123432panned
panted95024822panted
paper95128662paper
papered122513172papered
par57467022par__
para65242172par_a
parade94720642parade
paraded114014262paraded
parae76335702parae
paras76143042paras
parcel103915472parcel
parch125123002parch
parched154013692parched
pardee93922022pardee
pardi85723952pardi
pards85634332pards
pardy115523952pardy
parent83230422parent
pareos87023772pareos
parers85530742parers
pareus85420742pareus
pareve114613012pareve
parge85831852parge
parges94529542parges
parget94529392parget
pargo86723722pargo
paries84742512paries
paris75145942paris
park105237492par_k
parka115120882parka
parker124121372parker
parks116134462parks
parle75836162parle
parles86334402parles
parley116718362parley
parody12410092parody
parol74826272parol
paroled104217632paroled
parr65731152par_r
parrel84515982parrel
parried103615722parried
parrs75928672parrs
parry105323752parry
pars67560792par_s
parse75236992parse
parsec105914482parsec
parser84822372parser
parses85534702parses
part65967462par_t
partied103516552partied
parts77743372parts
party106630612party
parve109824852parve
parvo107719182parvo
pase65346862pase_
paseo77022512paseo
pases75346502pases
pashed125923142pashed
passed94320942passed
pasted94426902pasted
pate65350462pate_
paten74827342paten
pater74740722pater
pates76047892pates
patted94724682patted
paused95114962paused
pave96133892pave_
paveed12438892paveed
paver104225832paver
paves104833922paves
pavid115717002pavid
pawer104422972pawer
pawned124513282pawned
paxes144928422paxes
payee105524722payee
payer105125722payer
peaced115818912peaced
peaked136117402peaked
pealed95322812pealed
pearled10411552pearled
ped66751522p__ed
peed76239182p_eed
peered93819492peered
pere66450262pere_
perea75026442perea
peres76246642peres
perked134617692perked
permed115217352permed
phased124011972phased
pied75035362p_ied
piked125623312piked
piled85232992piled
pined85935322pined
piped105123162piped
placed114318002placed
planed94420912planed
plated95225772plated
played124815032played
pled75231432p_led
plied85118592plied
poked125425392poked
poled84934842poled
pooed85226242pooed
pore66451262pore_
pores75849032pores
porked134717622porked
ported94223242ported
posed85828412posed
poured95116742poured
poxed154817862poxed
prated94924922prated
prayed124815432prayed
pree67044732p_ree
preed85128122preed
prep86427672p_rep
prex135722972p_rex
prey96228482p_rey
prez156126312p_rez
pried84426862pried
prod76129502p_rod
puked124716222puked
puled84926522puled
pure65543332pure_
puree74632842puree
pureed95017812pureed
purer75127902purer
purged104918262purged
purled94520752purled
purred94218072purred
pursed95220882pursed
pyre94925552pyre_
pyres105523882pyres
pyrex175211212pyrex
raced87635312raced
raged74829452raged
raked105831422raked
raped85334622raped
rare45348432rare_
rarer54731702rarer
rares55247442rares
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
reared75930012reared
red46755802__red
roared75015392roared
sabed86526812sabed
sabred95916532sabred
sacred94917102sacred
saned65636272saned
sard55344242sar_d
saree55044662saree
sarod65325872sarod
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scared95227292scared
seared75232842seared
sered65737292sered
shared105829062shared
shred98125612shred
sired66134282sired
snared74824552snared
soared74324292soared
sored66141782sored
spaced114517252spaced
spaded103816752spaded
spaed85522272spa_ed
spare75135562spare_
sparer84524962sparer
spares84834552spares
sparged113512762sparged
sparid94016932sparid
sparked143513142sparked
sparred104512862sparred
spayed124213612spayed
speared104314422speared
spired94921862spired
spored94821792spored
stared75429872stared
tamed85528512tamed
taped85327422taped
tare45957622tare_
tares57456562tares
tarred74720282tarred
tarted74923372tarted
tawed95926192tawed
taxed135620292taxed
teared75722152teared
tired65228902tired
tyred95816432tyred
vaned94622422vaned
varied104817862varied
varved134110602varved
waded106024752waded
waged104822782waged
waired106015832waired
waked135626752waked
waled94330992waled
waned95831782waned
ward86542252war_d
warded115021042warded
ware76254722ware_
wares88250582wares
warked144421212warked
warmed124516892warmed
warned104018912warned
warped124816412warped
warred104019842warred
warted104223232warted
waved125223582waved
waxed166018482waxed
wired95327642wired
yard85633252yar_d
yarded114714022yarded
yare75636942yare_
yarer84321572yarer
yarned105514022yarned
yawed126022452yawed

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.326548131.9
2DLD Change Limit538004571.69031834.3
3Display Results4574570.1403264.3
 (SQL Overall)1786914572.15682880.8
 
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.