Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “parcelled” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

74 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
parcelled	14	4	578	(None)
marcelled	14	4	520	1	marcelled
parceled	13	3	834	1	parce_led
barrelled	12	4	526	2	barrelled
cancelled	14	5	674	2	cancelled
marceller	13	4	515	2	marceller
marvelled	15	4	496	2	marvelled
panelled	11	3	896	2	pa_nelled
spancelled	15	4	300	2	spancelled
apparelled	15	5	261	3	appar_elled
barreled	11	3	785	3	barre_led
canceled	13	27	940	3	cance_led
canceller	13	6	668	3	canceller
caracolled	15	4	302	3	caracolled
carolled	11	3	883	3	car_olled
catcalled	14	4	489	3	catcalled
celled	9	44	2032	3	___celled
corbelled	14	4	661	3	corbelled
cordelled	13	4	640	3	cordelled
excelled	18	12	570	3	_excelled
farewelled	17	4	237	3	farewelled
ferrelled	13	4	394	3	ferrelled
gabelled	12	31	758	3	ga_belled
gavelled	13	38	736	3	ga_velled
gravelled	14	7	555	3	gravelled
gruelled	10	3	489	3	_gruelled
hanselled	13	4	548	3	hanselled
hatchelled	19	4	301	3	hatchelled
hirselled	13	4	469	3	hirselled
kernelled	14	4	374	3	kernelled
labelled	11	27	829	3	la_belled
lapelled	11	22	708	3	la_pelled
laurelled	10	4	361	3	laurelled
marcellers	14	4	383	3	marcellers
marveled	14	3	643	3	marve_led
morselled	12	4	596	3	morselled
nacelle	9	3	815	3	na_celle_
nacelles	10	4	839	3	na_celles
palled	9	46	2516	3	pa___lled
paneled	10	6	1257	3	pa_ne_led
parallel	10	4	747	3	par_allel
paralleled	13	4	374	3	paralleled
parallelled	14	7	230	3	parallelled
parasoled	12	4	635	3	parasoled
parboiled	14	4	522	3	parboiled
parcel	10	39	1547	3	parce_l__
parceling	14	3	844	3	parceling
parcelling	15	4	617	3	parcelling
parcels	11	37	1266	3	parce_l_s
parcener	12	3	847	3	parce_ner
parched	15	40	1369	3	parc__hed
parented	11	9	1221	3	par_ented
pargeted	12	3	868	3	parge_ted
pargetted	13	4	566	3	pargetted
parled	9	46	2629	3	par___led
parleyed	14	3	624	3	parle_yed
paroled	10	42	1763	3	par__oled
parsleyed	15	4	335	3	parsleyed
parslied	11	3	782	3	par_slied
patrolled	12	4	571	3	patrolled
pencilled	14	4	564	3	pencilled
perceived	17	4	435	3	perceived
perilled	11	4	1011	3	per_illed
pommelled	16	4	308	3	pommelled
prilled	10	47	1300	3	p_r_illed
propelled	14	5	691	3	propelled
pummelled	16	4	307	3	pummelled
quarrelled	20	5	316	3	quarrelled
rappelled	14	4	370	3	rappelled
ravelled	12	41	978	3	ra_velled
spanceled	14	4	369	3	spance_led
tasselled	10	4	466	3	tasselled
tramelled	12	6	622	3	tramelled
travelled	13	5	686	3	travelled

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	148641	0.436	409841.7
2	DLD Change Limit	148641	74	7.813	19024.8
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	8.282	21575.8