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

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

67 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
clingers	11	38	1066	(None)
clangers	11	43	1234	1	clangers
clinger	10	38	1215	1	clinger_
clinkers	14	33	983	1	clinkers
cringers	11	25	1187	1	cringers
flingers	12	34	1019	1	flingers
lingers	8	42	2330	1	_lingers
slingers	9	37	1268	1	slingers
aligners	9	11	757	2	aligners
aliners	7	47	1772	2	alin_ers
bingers	10	45	1999	2	_bingers
blinders	11	39	1114	2	blinders
blinkers	14	38	850	2	blinkers
blungers	11	46	984	2	blungers
bringers	11	28	1107	2	bringers
changers	14	43	1320	2	changers
chiggers	15	3	556	2	chiggers
cinders	10	46	1776	2	c_inders
clanger	10	41	1349	2	clanger_
clangors	11	41	700	2	clangors
clickers	16	39	1020	2	clickers
climbers	14	31	841	2	climbers
clinchers	16	33	626	2	clinchers
clines	8	49	2604	2	clin_e_s
clinged	11	33	1009	2	clinge_d
clingier	11	5	585	2	clingier_
clings	9	57	1621	2	cling__s
clinker	13	38	1166	2	clinker_
clippers	14	36	884	2	clippers
clivers	12	34	1175	2	cli_vers
cloggers	12	43	728	2	cloggers
cloners	9	45	1482	2	clon_ers
clunkers	14	32	755	2	clunkers
coiners	9	36	2075	2	coin_ers
coinfers	13	34	950	2	coinfers
cointers	10	36	1641	2	cointers
congers	10	42	2323	2	c_ongers
cringer	10	35	1424	2	cringer_
cringes	10	32	1550	2	cringe_s
cylinders	15	4	320	2	cylinders
dingers	9	43	2138	2	_dingers
fingers	11	34	1843	2	_fingers
flangers	12	33	1137	2	flangers
flinders	12	43	926	2	flinders
flinger	11	37	1051	2	flinger_
gingers	9	41	1864	2	_gingers
hingers	11	34	2021	2	_hingers
ligers	7	50	2204	2	_li_gers
liners	6	54	2885	2	_lin_ers
linger	7	52	2600	2	_linger_
linkers	11	43	1771	2	_linkers
linters	7	38	2263	2	_linters
longers	8	48	1954	2	_longers
lungers	8	38	1709	2	_lungers
malingers	12	8	585	2	malingers
pingers	10	40	2074	2	_pingers
plinkers	14	30	939	2	plinkers
plungers	11	37	939	2	plungers
ringers	8	39	2295	2	_ringers
singers	8	38	2470	2	_singers
slinger	8	34	1383	2	slinger_
stingers	9	40	1274	2	stingers
swingers	12	37	1042	2	swingers
whingers	15	35	872	2	whingers
wingers	11	39	2148	2	_wingers
wringers	12	31	1007	2	wringers
zingers	17	35	1485	2	_zingers

Search took 5 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.140	1276364.3
2	DLD Change Limit	121059	67	3.906	30993.1
3	Display Results	67	67	0.016	4187.5
	(SQL Overall)	178691	67	4.062	43990.9