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

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

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.

62 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
blagging	13	31	916	(None)
bagging	12	33	1698	1	b_agging
blaggings	14	32	446	1	blaggings
blogging	13	36	901	1	blogging
bragging	13	35	933	1	bragging
clagging	13	32	887	1	clagging
flagging	14	32	922	1	flagging
lagging	10	33	1673	1	_lagging
slagging	11	37	1157	1	slagging
badging	12	37	1279	2	b_adging
baggings	13	30	752	2	b_aggings
banging	11	40	1986	2	b_anging
barging	11	40	1848	2	b_arging
beflagging	18	4	281	2	beflagging
begging	12	30	1265	2	b_egging
bigging	12	28	1588	2	b_igging
blabbing	12	26	672	2	blabbing
blacking	17	42	1360	2	blacking
blading	11	36	1536	2	bla_ding
blaming	12	35	1569	2	bla_ming
blanking	15	44	1193	2	blanking
blaring	10	43	1711	2	bla_ring
blasting	11	40	1343	2	blasting
blatting	11	41	1165	2	blatting
blawing	13	40	1275	2	bla_wing
blazing	19	36	1239	2	bla_zing
bloggings	14	26	426	2	bloggings
bludging	13	29	746	2	bludging
blunging	12	32	841	2	blunging
bogging	12	36	1575	2	b_ogging
bugging	12	35	1518	2	b_ugging
clanging	12	40	1212	2	clanging
clogging	13	36	850	2	clogging
dragging	12	30	810	2	dragging
fagging	13	37	1476	2	_fagging
flaggings	15	28	518	2	flaggings
flanging	13	27	1058	2	flanging
flogging	14	32	917	2	flogging
fragging	14	32	942	2	fragging
gagging	9	30	1352	2	_gagging
glugging	10	31	635	2	glugging
hagging	13	31	1468	2	_hagging
jagging	17	33	1199	2	_jagging
laggings	11	29	840	2	_laggings
legging	10	39	1264	2	_legging
logging	10	33	1680	2	_logging
lugging	10	41	1435	2	_lugging
nagging	10	26	1304	2	_nagging
plaguing	12	3	603	2	plaguing
plugging	13	30	689	2	plugging
ragging	10	35	1668	2	_ragging
sagging	10	31	1610	2	_sagging
shagging	14	34	905	2	shagging
slanging	10	34	1343	2	slanging
slogging	11	34	1049	2	slogging
slugging	11	33	942	2	slugging
snagging	11	31	937	2	snagging
stagging	11	33	1051	2	stagging
swagging	14	32	809	2	swagging
tagging	10	30	1491	2	_tagging
wagging	13	33	1335	2	_wagging
zagging	19	32	1045	2	_zagging

Search took 4 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	121059	0.373	479064.3
2	DLD Change Limit	121059	62	3.313	36540.6
3	Display Results	62	62	0.013	4769.2
	(SQL Overall)	178691	62	3.699	48307.9