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

Here are the results of your fuzzy-string dictionary search for “parcelling” 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.

64 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
parcelling	15	4	617	(None)
marcelling	15	4	559	1	marcelling
parceling	14	3	844	1	parce_ling
barrelling	13	4	545	2	barrelling
cancelling	15	4	721	2	cancelling
marvelling	16	4	536	2	marvelling
panelling	12	3	908	2	pa_nelling
spancelling	16	4	334	2	spancelling
apparelling	16	5	243	3	appar_elling
barreling	12	3	804	3	barre_ling
canceling	14	3	1016	3	cance_ling
caracolling	16	4	303	3	caracolling
carolling	12	5	941	3	car_olling
catcalling	15	4	512	3	catcalling
celling	10	39	2126	3	___celling
corbelling	15	4	671	3	corbelling
cordelling	14	4	638	3	cordelling
excelling	19	3	564	3	_excelling
farewelling	18	4	262	3	farewelling
ferrelling	14	4	506	3	ferrelling
gavelling	14	28	688	3	ga_velling
gravelling	15	6	521	3	gravelling
gruelling	11	5	560	3	_gruelling
hanselling	14	4	562	3	hanselling
hatchelling	20	5	262	3	hatchelling
hirselling	14	4	483	3	hirselling
kernelling	15	8	414	3	kernelling
labelling	12	3	809	3	la_belling
laurelling	11	4	447	3	laurelling
marveling	15	3	710	3	marve_ling
morselling	13	4	632	3	morselling
palling	10	40	2448	3	pa___lling
paneling	11	10	1362	3	pa_ne_ling
panellings	13	4	454	3	pa_nellings
paralleling	14	6	310	3	paralleling
parallelling	15	7	199	3	parallelling
parboiling	15	4	517	3	parboiling
parcelled	14	4	578	3	parcell_ed
parching	16	43	1305	3	parc__hing
parenting	12	6	1158	3	par_enting
pargeting	13	3	828	3	parge_ting
pargetting	14	4	494	3	pargetting
parleying	15	3	611	3	parle_ying
parling	10	38	2376	3	par___ling
paroling	11	33	1621	3	par__oling
patrolling	13	4	569	3	patrolling
pencilling	15	4	547	3	pencilling
perceiving	18	4	466	3	perceiving
perilling	12	4	1000	3	per_illing
pommelling	17	4	361	3	pommelling
porcelain	13	4	413	3	porcelain_
porcelains	14	4	438	3	porcelains
preselling	13	3	869	3	preselling
pretelling	13	3	813	3	pretelling
prilling	11	34	1341	3	p_r_illing
propelling	15	5	693	3	propelling
pummelling	17	4	316	3	pummelling
quarrelling	21	4	340	3	quarrelling
rappelling	15	4	436	3	rappelling
ravelling	13	26	925	3	ra_velling
spanceling	15	4	394	3	spance_ling
tasselling	11	4	523	3	tasselling
tramelling	13	4	638	3	tramelling
travelling	14	5	653	3	travelling

Search took 8 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	140603	0.406	440125.6
2	DLD Change Limit	140603	64	6.703	20976.1
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	7.139	25030.3