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 “parceled” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

211 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
parceled133834(None) 
parcelled1445781parcelled
barreled1137852barreled
canceled13279402canceled
marcelled1445202marcelled
marveled1436432marveled
paneled10612572pa_neled
parcel103915472parcel__
parcels113712662parcel_s
parcener1238472parcener
parched154013692parc_hed
pargeted1238682pargeted
parled94626292par__led
parleyed1436242parleyed
paroled104217632par_oled
spanceled1443692spanceled
acceded1336113_acceded
aneled74719283_a_neled
angeled93211513_angeled
appareled1442893appar_eled
arcaded1178973_arcaded
arced88224163_arc__ed
arched125717323_arc_hed
arcked136211943_arc_ked
argled85314553_ar_gled
ariled75620323_ar_iled
barbered13259553barbered
barrelled1245263barrelled
bartered113113033bartered
bracelet12310693bracelet
cackled164613303ca_ckled
canceler12238913canceler
cancelled1456743cancelled
cancered132411553cancered
caracoled1445993caracoled
carcel105018673carcel__
carcels114516063carcel_s
careened1139193careened
careered1139503careered
caroled103717693car_oled
carolled1138833carolled
carpeted1338953carpeted
circled1237583circ_led
corbeled1338373corbeled
crackled17428863crackled
creeled104012013_creeled
darkened1435943darkened
darkled13378723dar_kled
dartled9409853dar_tled
easeled8159863ea_seled
faceted13509563fa_ceted
farced125216533farc__ed
ferreled1234843ferreled
garbled114512803gar_bled
gardened1137003gardened
gargled104210673gar_gled
garnered10247123garnered
garreted1057523garreted
gartered10319603gartered
gaveled12399133ga_veled
graveled13417363graveled
grueled937133_grueled
hackled173312493ha_ckled
hanseled1237713hanseled
hardened1338613hardened
harkened1637483harkened
hatcheled1844223hatcheled
hirseled12106253hirseled
kerneled1344033kerneled
labeled102510563la_beled
lancelet1049473lancelet
lanceted1137073lanceted
lapeled10258893la_peled
larcener1036493larcener
laureled934543laureled
mackled164111923ma_ckled
macled116718113ma_c_led
maculed123510053ma_culed
marbled123212113mar_bled
marcel103714853marcel__
marceller1345153marceller
marcels113212373marcel_s
marched153813403marc_hed
marketed1537323marketed
marled95523163mar__led
marvelled1544963marvelled
morseled1147193morseled
opercele1244593opercele_
operceles1344613operceles
paced106931683pa_c__ed
packed154822603pa_c_ked
packeted17148283packeted
paddled123612023pa_ddled
paled85538723pa___led
palled94625163pa__lled
palleted1139873palleted
paltered113012503paltered
pampered15229233pampered
pancaked1734893pancaked
pandered121812573pandered
panelled1138963panelled
panicled13106783panicled
pantiled113111593pantiled
papered122513173pa_pered
parable111819773parable_
parables121613563parables
paraded114014263par_aded
parallel1047473parallel
paralleled1343743paralleled
parapeted1446483parapeted
parasoled1246353parasoled
parbaked1735503parbaked
parboiled1445223parboiled
parbuckled2151583parbuckled
parceling1438443parceling
parceners1337463parceners
parches143720003parc_hes
pardee93922023parde_e_
pardoned12189333pardoned
pared86946763par___ed
parented11912213parented
pareses94718883par_eses
pareve114613013par_eve_
parged104922043par__ged
pargetted1345663pargetted
parhelia1346713parhelia
parhelic1547093parhelic
parietes10714543parietes
parked134425143par__ked
parlayed1435823parlayed
parle75836163par__le_
parles86334403par__les
parley116718363par__ley
parleyer1335633parleyer
parodied1238343parodied
parole84425253par_ole_
parolee94119653par_olee
parolees104313983parolees
paroles95025883par_oles
parqueted2144223parqueted
parred95024073par__red
parrel84515983parrel__
parrels94713493parrel_s
parried103615723par_ried
parroted1158853parroted
parsed96323893par__sed
parsley1247803par_sley
parsleyed1543353parsleyed
parslied1137823parslied
parted94228683par__ted
partied103516553par_tied
partlet92720363par_tlet
partnered1244493partnered
patched153514623patc_hed
patrolled1245713patrolled
pattened11299393pattened
pattered112714213pattered
paupered13216943paupered
paveed12438893pa_ve_ed
pearled10411553pear__led
peeled94119713p__eeled
penciled1337823penciled
percale11314093percale_
percales12313803percales
perceived1744353perceived
perched154713243perc_hed
periled10316323per_iled
perilled11410113perilled
pickled164011883p_ickled
pommeled1543103pommeled
portaled11239203portaled
portered112311553portered
prattled11246533prattled
preceded1438293preceded
preed85128123p_r_e_ed
preened103214993p_reened
premed114617763p_r_emed
preyed125313203p_r_eyed
prickled17358073prickled
prilled104713003p_rilled
proceed12310553proce_ed
prowled13309913p_rowled
pummeled1543373pummeled
pureed95017813pur_e_ed
purfled13248733pur_fled
purled94520753pur__led
purpled12299783pur_pled
purveyed1743363purveyed
quarreled1963443quarreled
racemed1237013ra_cemed
rappeled1335003rappeled
raveled114113633ra_veled
reeled74725533__reeled
sarcenet10413313sarcenet
satcheled1544423satcheled
spackled17297803spa_ckled
spancelled1543003spancelled
sparkled15317733spar_kled
streeled9267873streeled
tackled143913193ta_ckled
targeted1037483targeted
tarweed1137343tarwe_ed
tasseled935603tasseled
tercelet1049883tercelet
trachled1438313trachled
trameled11309073trameled
traveled12349453traveled
unreeled91310333unreeled
warbled133212163war_bled
warsled112910443war_sled
warstled12286123warstled

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461622117.34319904.9
3Display Results2112110.0932268.8
 (SQL Overall)1786912117.87222699.6
 
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.