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

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

57 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
clickers	16	39	1020	(None)
clackers	16	39	1170	1	clackers
clicker	15	41	1188	1	clicker_
clinkers	14	33	983	1	clinkers
clockers	16	36	981	1	clockers
flickers	17	33	888	1	flickers
lickers	13	41	1825	1	_lickers
slickers	14	31	1255	1	slickers
bickers	15	43	1655	2	_bickers
blinkers	14	38	850	2	blinkers
blockers	16	39	879	2	blockers
checkers	19	31	784	2	checkers
chickees	19	25	851	2	chickees
chickens	19	26	743	2	chickens
clacker	15	38	1377	2	clacker_
cliches	14	42	1374	2	cliche_s
clicked	16	41	1245	2	clicke_d
clickless	17	4	398	2	clickless
clicks	14	53	1511	2	click__s
climbers	14	31	841	2	climbers
clinchers	16	33	626	2	clinchers
clingers	11	38	1066	2	clingers
clinker	13	38	1166	2	clinker_
clippers	14	36	884	2	clippers
clivers	12	34	1175	2	cli_vers
clocker	15	39	1087	2	clocker_
clunkers	14	32	756	2	clunkers
cockers	15	36	1833	2	c_ockers
crackers	16	41	1172	2	crackers
crickets	16	41	812	2	crickets
dickers	14	41	1766	2	_dickers
flicker	16	36	1062	2	flicker_
flickery	20	36	510	2	flickery
ickers	12	39	1418	2	__ickers
kickers	12	40	1329	2	_kickers
knickers	13	30	672	2	knickers
lackers	13	41	2054	2	_lackers
licker	12	52	2204	2	_licker_
likers	10	46	2091	2	_li_kers
linkers	11	43	1771	2	_linkers
lockers	13	35	1692	2	_lockers
nickers	13	44	1509	2	_nickers
pickers	15	37	1809	2	_pickers
plinkers	14	30	940	2	plinkers
pluckers	16	31	656	2	pluckers
prickers	16	37	1067	2	prickers
shickers	17	30	1282	2	shickers
slackers	14	38	1274	2	slackers
slicers	9	41	1492	2	slic_ers
slickens	14	31	726	2	slickens
slicker	13	33	1453	2	slicker_
snickers	14	30	1096	2	snickers
stickers	14	29	1303	2	stickers
tickers	13	36	1772	2	_tickers
trickers	14	38	1281	2	trickers
whickers	20	29	798	2	whickers
wickers	16	41	1470	2	_wickers

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.390	458182.1
2	DLD Change Limit	121059	57	3.766	32145.2
3	Display Results	57	57	0.030	1900.0
	(SQL Overall)	178691	57	4.186	42687.8