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

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

72 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
blinking	15	35	1062	(None)
blanking	15	44	1193	1	blanking
blinding	12	32	1016	1	blinding
boinking	15	37	842	1	boinking
clinking	15	36	1166	1	clinking
linking	12	38	1825	1	_linking
plinking	15	36	1124	1	plinking
slinking	13	34	1298	1	slinking
alining	8	19	1704	2	alin_ing
banking	14	46	2135	2	b_anking
biking	13	50	1817	2	b_i_king
bilking	14	44	1355	2	b_ilking
binding	11	38	1938	2	b_inding
binging	11	36	1938	2	b_inging
binning	10	36	1545	2	b_inning
blacking	17	42	1360	2	blacking
blending	12	24	996	2	blending
blinkering	17	4	432	2	blinkering
blipping	15	30	680	2	blipping
blissing	11	3	687	2	blissing
blitzing	20	3	590	2	blitzing
blocking	17	45	1057	2	blocking
blunging	12	32	841	2	blunging
blunting	11	31	984	2	blunting
bonking	14	41	1637	2	b_onking
bricking	17	39	1140	2	bricking
bringing	12	30	1127	2	bringing
brining	10	32	1647	2	brin_ing
brisking	15	32	947	2	brisking
bunking	14	40	1619	2	b_unking
bylining	14	4	601	2	bylin_ing
chinking	18	32	1089	2	chinking
clanking	15	43	1306	2	clanking
clicking	17	36	1098	2	clicking
clinging	12	29	1091	2	clinging
clonking	15	38	1015	2	clonking
clunking	15	32	943	2	clunking
dinking	13	36	1828	2	_dinking
drinking	14	30	891	2	drinking
finking	15	40	1660	2	_finking
flanking	16	42	1108	2	flanking
flicking	18	41	1004	2	flicking
flinging	13	33	1005	2	flinging
flinting	12	34	1234	2	flinting
flunking	16	31	777	2	flunking
glinting	10	32	1005	2	glinting
inking	11	51	1905	2	__inking
jinking	19	36	1354	2	_jinking
kinking	11	36	1515	2	_kinking
licking	14	41	1828	2	_licking
liking	11	43	1958	2	_li_king
lining	7	45	2680	2	_lin_ing
linting	8	38	2098	2	_linting
oinking	12	37	1471	2	_oinking
pinking	14	39	1894	2	_pinking
planking	15	35	1301	2	planking
plonking	15	35	856	2	plonking
plunking	15	32	848	2	plunking
prinking	15	32	1245	2	prinking
reinking	13	3	1102	2	reinking
relinking	14	5	825	2	relinking
sinking	12	33	2054	2	_sinking
skinking	12	29	977	2	skinking
slicking	15	37	1259	2	slicking
slinging	10	33	1286	2	slinging
stinking	13	31	1354	2	stinking
swinking	16	34	1032	2	swinking
thinking	16	28	986	2	thinking
unblinking	17	4	392	2	unblinking
unlinking	14	3	627	2	unlinking
uplinking	16	3	462	2	uplinking
winking	15	33	1796	2	_winking

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.143	1249587.4
2	DLD Change Limit	121059	72	3.186	37997.2
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	3.359	53197.7