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

225 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
parked13442514(None) 
barked135027311barked
carked134024821carked
darked123919631darked
harked145422551harked
larked114519471larked
marked133921621marked
narked114116741narked
packed154822601packed
paiked135113431paiked
pared86946761par_ed
parged104922041parged
parker124121371parker
parled94626291parled
parred95024071parred
parsed96323891parsed
parted94228681parted
perked134617691perked
porked134717621porked
sparked143513141sparked
warked144421211warked
arced88224162_arced
arcked136211942_arcked
armed86324432_armed
asked106919312_asked
backed155725722backed
baked126130772ba_ked
balked135219412balked
banked135021442banked
barbed115121312barbed
barded105426422barded
bared85144482bar_ed
barfed125416382barfed
barged105822642barged
barker124822862barker
barned95623582barned
barred95725792barred
basked135218602basked
borked135117292borked
braked135318692braked
burked135220882burked
caked126128622ca_ked
calked134617402calked
carded105424902carded
cared86050092car_ed
caried94528692caried
carped115923762carped
carted98631442carted
carved124320852carved
casked134815512casked
charked174814012charked
corked135020782corked
dared75935012dar_ed
darken114013442darken
darker114718692darker
darkey145212422darkey
darkled13378722darkled
darned85018482darned
darted84620922darted
dirked124912272dirked
eared65139502ear_ed
earned74818332earned
faked135225482fa_ked
farced125216532farced
farded114518952farded
fared95842342far_ed
farmed125117652farmed
farted105121782farted
forked145217142forked
garbed104815662garbed
garred85217402garred
gawked15468762gawked
hacked164923512hacked
hanked144220602hanked
hared95742182har_ed
harken135116342harken
harmed125218832harmed
harped124418402harped
hawked174712672hawked
imparked17264862imparked
irked104510922_irked
jacked204817522jacked
jarred144613252jarred
jauked18489012jauked
jerked18479592jerked
lacked135324652lacked
laked105731122la_ked
larded84319092larded
larker104519242larker
lurked114511972lurked
marker124420392marker
market123226042market
marled95523162marled
marred95421042marred
marted94425212marted
masked134316522masked
naked105320852na_ked
oared65030652oar_ed
paced106931682pa_ced
packer144223402packer
packet144726502packet
padded114113502padded
paged95926782pa_ged
pained95622852pained
paired95017522paired
paled85538722pa_led
palled94625162palled
palmed114314642palmed
palped114513642palped
paned85437182pa_ned
panged104722332panged
panned94123432panned
panted95024822panted
parade94720642parade
paraded114014262paraded
parae76335702parae_
parbaked1735502parbaked
parcel103915472parcel
parched154013692parched
pard76441322par__d
pardee93922022pardee
pare66760842par_e_
pareo74632602par_eo
parer75839902par_er
pares77164482par_es
pareu74928742par_eu
parge85831852parge_
parges94529542parges
parget94529392parget
paries84742512paries
park105237492park__
parka115120882park_a
parkade1437582parkade
parkas125018022parkas
parkers133816872parkers
parks116134462park_s
parle75836162parle_
parles86334402parles
parley116718362parley
paroled104217632paroled
parrel84515982parrel
parried103615722parried
parse75236992parse_
parsec105914482parsec
parser84822372parser
parses85534702parses
partied103516552partied
parve109824852parve_
pashed125923142pashed
passed94320942passed
pasted94426902pasted
pated85237842pa_ted
patted94724682patted
paused95114962paused
paved115525262pa_ved
paveed12438892paveed
pawed115725612pa_wed
pawned124513282pawned
payed115925932pa_yed
peaked136117402peaked
pearled10411552pearled
pecked155019102pecked
peeked134314582peeked
permed115217352permed
peruked14367892peruked
picked154421312picked
piked125623312p_iked
pinked134819882pinked
planked143512282planked
pocked154818982pocked
poked125425392p_oked
pored85234512por_ed
porker124917542porker
ported94223242ported
pranked143712092pranked
prated94924922prated
prayed124815432prayed
preed85128122p_reed
pried84426862p_ried
puked124716222p_uked
pureed95017812pureed
purged104918262purged
purled94520752purled
purred94218072purred
pursed95220882pursed
racked134526082racked
raked105831422ra_ked
ranked114620742ranked
rared65738322rar_ed
reparked15208922reparked
sacked135525212sacked
sharked153613912sharked
spanked143111732spanked
spared95427492spar_ed
sparged113512762sparged
sparker133914362sparker
sparkled15317732sparkled
sparred104512862sparred
tacked134723942tacked
talked114015402talked
tanked113919292tanked
tared69340052tar_ed
tarred74720282tarred
tarted74923372tarted
tasked114714642tasked
varied104817862varied
varved134110602varved
waked135626752wa_ked
walked145313782walked
wanked144517152wanked
warded115021042warded
wared96339872war_ed
warmed124516892warmed
warned104018912warned
warped124816412warped
warred104019842warred
warted104223232warted
wauked144210572wauked
worked145314702worked
yacked164516792yacked
yakked13366092yakked
yanked144312242yanked
yarded114714022yarded
yarned105514022yarned
yerked14509372yerked

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 Filter178691825510.360496363.9
2DLD Change Limit825512252.31335690.0
3Display Results2252250.0603750.0
 (SQL Overall)1786912252.73365382.7
 
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.