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

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

118 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
bespangling	17	4	210	(None)
spangling	13	3	637	2	__spangling
bedraggling	17	6	157	3	bedraggling
bemingling	16	4	340	3	be_mingling
bespangle	14	4	254	3	bespangl__e
bespangled	16	4	190	3	bespangl_ed
bespangles	15	4	213	3	bespangl_es
besprinkling	21	5	114	3	besprinkling
empaneling	15	7	340	3	_empaneling
entangling	12	4	432	3	_entangling
repaneling	13	4	573	3	re_paneling
reshingling	16	4	239	3	reshingling
angling	9	28	1604	4	____angling
banging	11	40	1986	4	b___ang_ing
bantling	11	26	1200	4	b___antling
beaning	10	38	2068	4	be__an__ing
bechancing	20	4	444	4	bechan_cing
becrawling	18	4	361	4	becra_wling
bedabbling	15	4	229	4	be_dabbling
bedazzling	22	4	193	4	be_dazzling
befalling	15	22	650	4	be_fa_lling
beflagging	18	4	282	4	befla_gging
befringing	17	4	406	4	befring_ing
begalling	13	21	649	4	be_ga_lling
belonging	13	3	591	4	be_long_ing
bemeaning	14	3	619	4	bemean__ing
bemoaning	14	3	595	4	bemoan__ing
bepainting	15	14	488	4	be_painting
bepimpling	19	6	192	4	be_pimpling
beshadowing	21	9	187	4	beshadowing
beshaming	17	3	567	4	besha__ming
besieging	13	4	476	4	bes_ieg_ing
besmiling	14	3	626	4	bes__miling
besmudging	17	8	212	4	besmudg_ing
besnowing	15	4	412	4	bes__nowing
bespattering	17	5	234	4	bespattering
bespeaking	19	4	439	4	besp_eaking
bespousing	15	5	341	4	besp_ousing
bespreading	17	4	350	4	bespreading
beswarming	18	4	327	4	beswa_rming
bethanking	20	4	429	4	bethan_king
bewailing	15	3	606	4	be_wa_iling
brandling	13	4	825	4	b__randling
bungling	12	26	954	4	b___ungling
bushranging	18	5	178	4	bushrang_ing
dangling	11	26	1123	4	___dangling
defanging	15	3	533	4	de_fang_ing
deranging	12	3	806	4	de_rang_ing
desanding	12	20	765	4	des_an_ding
descanting	14	4	692	4	descan_ting
despairing	14	4	506	4	despa_iring
despatching	20	12	265	4	despatching
despoiling	14	4	511	4	desp_oiling
desponding	15	5	566	4	despon_ding
dismantling	15	4	339	4	dismantling
eagling	9	11	1360	4	_e__a_gling
eanling	8	14	1667	4	_e__an_ling
embrangling	17	8	227	4	embrangling
empaling	13	3	836	4	_empa__ling
empanelling	16	6	241	4	_empanelling
estranging	12	4	602	4	_estrang_ing
expanding	20	4	479	4	_expan_ding
expunging	20	4	283	4	_expung_ing
fenagling	14	3	455	4	fe_na_gling
gangling	11	24	1140	4	___gangling
impaneling	15	7	337	4	_impaneling
inspanning	13	4	320	4	inspan_ning
jangling	17	24	962	4	___jangling
mangling	12	23	1262	4	___mangling
messaging	13	4	534	4	messa_g_ing
mishandling	18	4	333	4	mishandling
mispaging	15	3	780	4	mispa_g_ing
paneling	11	10	1363	4	___paneling
panging	11	33	1911	4	___pang_ing
pungling	12	22	866	4	___pungling
rechanging	17	4	604	4	rechang_ing
rehandling	15	4	445	4	re_handling
rehanging	14	3	756	4	re_hang_ing
repanelling	14	4	347	4	re_panelling
resaddling	13	4	350	4	res_addling
resailing	10	33	1425	4	res_a_iling
resampling	15	4	433	4	res_ampling
rescaling	12	22	1201	4	resca__ling
resealing	10	21	1567	4	resea__ling
respacing	14	3	889	4	respa__cing
respading	13	3	880	4	respa__ding
respelling	13	4	797	4	resp_elling
responding	14	3	740	4	respon_ding
respooling	13	5	574	4	resp_ooling
respringing	15	4	458	4	respring_ing
restabling	13	3	765	4	resta_bling
restaging	11	24	1085	4	resta_g_ing
sandling	10	22	1441	4	__s_andling
scantling	12	10	723	4	__scantling
shingling	14	13	697	4	__shingling
singling	10	19	1300	4	__s_ingling
slanging	10	34	1343	4	__slang_ing
spackling	18	26	650	4	__spackling
spalling	11	32	1346	4	__spa_lling
spanceling	15	4	394	4	__spanceling
spanglier	12	4	419	4	__spanglier
spanking	15	39	1197	4	__span_king
spanning	11	33	1108	4	__span_ning
sparging	12	26	1113	4	__sparg_ing
sparkling	16	22	635	4	__sparkling
sparling	11	27	1453	4	__spa_rling
spindling	13	13	627	4	__spindling
sponging	12	3	882	4	__spong_ing
stanging	10	40	1365	4	__stang_ing
strangling	12	5	640	4	_strangling
swingling	14	15	620	4	__swingling
tangling	10	17	1254	4	___tangling
twangling	14	3	445	4	__twangling
untangling	12	4	412	4	_untangling
wangling	13	23	1099	4	___wangling
weanling	12	11	864	4	we__an_ling
wrangling	14	5	622	4	__wrangling
yeanling	12	10	706	4	ye__an_ling

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.423	422437.4
2	DLD Change Limit	148819	118	9.343	15928.4
3	Display Results	118	118	0.063	1873.0
	(SQL Overall)	178691	118	9.829	18180.0