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

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

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

136 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
spancelling	16	4	334	(None)
spanceling	15	4	394	1	spance_ling
cancelling	15	4	721	2	_cancelling
panelling	12	3	907	2	_pan_elling
parcelling	15	4	617	2	_parcelling
canceling	14	3	1016	3	_cance_ling
chandelling	18	4	445	3	chandelling
channelling	17	4	399	3	channelling
empanelling	16	6	241	3	empan_elling
flannelling	15	4	283	3	flannelling
hanselling	14	4	562	3	_hanselling
impanelling	16	5	262	3	impan_elling
marcelling	15	4	559	3	_marcelling
paneling	11	10	1362	3	_pan_e_ling
panellings	13	4	453	3	_pan_ellings
parceling	14	3	844	3	_parce_ling
pencilling	15	4	547	3	_pencilling
repanelling	14	4	347	3	repan_elling
sandalling	12	4	587	3	s_andalling
sanderling	12	5	665	3	s_anderling
scandalling	15	4	344	3	scandalling
snelling	9	39	1356	3	s__n_elling
spackling	18	26	650	3	spa_c_kling
spalling	11	32	1346	3	spa___lling
spancelled	15	4	300	3	spancell_ed
spangling	13	3	637	3	span__gling
spelling	11	33	1523	3	sp___elling
stencilling	14	4	323	3	stencilling
aneling	8	27	1950	4	__an_e_ling
angeling	10	28	1173	4	__ange_ling
annealing	10	4	745	4	__annealing
annulling	10	4	500	4	__annulling
anvilling	13	3	683	4	__anvilling
apparelling	16	5	243	4	apparelling
barrelling	13	4	545	4	_barrelling
canalling	12	3	955	4	_can_alling
catcalling	15	4	512	4	_catcalling
celling	10	39	2126	4	____celling
changeling	17	4	567	4	change_ling
channeling	16	4	520	4	channe_ling
concealing	15	4	930	4	_concealing
counselling	14	4	440	4	counselling
crenelling	13	4	568	4	cren_elling
empaneling	15	7	340	4	empan_e_ling
enamelling	13	4	431	4	ena_melling
excelling	19	3	564	4	__excelling
flanneling	14	4	381	4	flanne_ling
funnelling	14	4	424	4	_funnelling
gavelling	14	28	687	4	_ga_velling
gravelling	15	6	521	4	gra_velling
handselling	16	4	282	4	_handselling
hanseling	13	3	806	4	_hanse_ling
hatchelling	20	5	262	4	_hatchelling
impaneling	15	7	337	4	impan_e_ling
kennelling	15	7	386	4	_kennelling
kernelling	15	8	414	4	kern_elling
knelling	13	31	902	4	__kn_elling
labelling	12	3	808	4	_la_belling
laurelling	11	4	446	4	_laurelling
marvelling	16	4	536	4	_marvelling
painkilling	18	5	230	4	_painkilling
palling	10	40	2448	4	_pa___lling
pancaking	18	3	638	4	_panc_aking
pandering	13	32	1196	4	_pande_ring
panelings	12	10	745	4	_pan_e_lings
patrolling	13	4	569	4	_patrolling
penciling	14	3	741	4	_penc_iling
pencillings	16	5	240	4	_pencillings
pinballing	15	4	401	4	_pinballing
pommelling	17	4	361	4	_pommelling
precancelling	20	5	174	4	precancelling
preselling	13	3	869	4	_preselling
pretelling	13	3	813	4	_pretelling
princeling	15	4	465	4	prince_ling
propelling	15	5	693	4	_propelling
pummelling	17	4	316	4	_pummelling
quarrelling	21	4	340	4	quarrelling
rappelling	15	4	436	4	_rappelling
ravelling	13	26	924	4	_ra_velling
repaneling	13	4	573	4	repan_e_ling
sandaling	11	20	1056	4	s_an_daling
sanderlings	13	4	343	4	s_anderlings
sandling	10	22	1441	4	s_an__dling
scandaling	14	19	545	4	scan_daling
scantling	12	10	723	4	scan__tling
sculling	11	29	1099	4	s___culling
selling	8	32	2583	4	s____elling
shackling	19	28	617	4	sha_c_kling
shaveling	16	4	684	4	sha_ve_ling
shelling	12	35	1521	4	s___helling
shovelling	17	4	406	4	s_hovelling
shrivelling	18	4	221	4	shrivelling
signalling	12	4	380	4	sign_alling
slandering	12	3	724	4	slande_ring
smelling	11	37	1272	4	s___melling
snivelling	14	4	429	4	s_nivelling
spacewalking	24	5	153	4	spa_cewalking
spacing	12	36	1449	4	spa_c___ing
spaeing	10	34	1354	4	spa__e__ing
spancel	11	4	736	4	spance_l___
spanceled	14	4	369	4	spance_l_ed
spancels	12	4	527	4	spance_l__s
spanking	15	39	1197	4	span___king
spanning	11	33	1108	4	span___ning
sparkling	16	22	635	4	spa__rkling
sparling	11	27	1453	4	spa___rling
spattering	13	10	779	4	spatte_ring
speckling	18	23	558	4	sp_ec_kling
speeling	11	27	1312	4	sp___eeling
speiling	11	36	1297	4	sp___eiling
spellings	12	29	655	4	sp___ellings
spieling	11	32	1252	4	sp__ie_ling
spilling	11	31	1394	4	sp___illing
spindling	13	13	627	4	spin__dling
spiralling	13	4	396	4	sp_iralling
spurgalling	15	5	172	4	spurgalling
stalling	9	51	1670	4	sta___lling
stanching	15	3	808	4	stanc__hing
starveling	14	4	426	4	starve_ling
stenciling	13	4	417	4	stenc_iling
subceiling	15	4	519	4	s_ubceiling
superselling	15	5	449	4	superselling
swelling	12	32	1275	4	s___welling
swivelling	17	4	341	4	s_wivelling
tasselling	11	4	523	4	_tasselling
teaselling	11	4	533	4	tea_selling
teazelling	20	4	380	4	tea_zelling
tinselling	11	4	552	4	_tinselling
tramelling	13	4	637	4	tra_melling
trammelling	16	4	261	4	trammelling
travelling	14	5	653	4	tra_velling
tunnelling	11	4	438	4	_tunnelling
unselling	10	8	1033	4	__unselling
upswelling	16	4	336	4	up_swelling
upwelling	15	3	523	4	up__welling
weaselling	14	5	423	4	wea_selling

Search took 10 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	148819	0.453	394461.4
2	DLD Change Limit	148819	136	8.796	16918.9
3	Display Results	136	136	0.063	2158.7
	(SQL Overall)	178691	136	9.312	19189.3