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

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

73 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
clicker	15	41	1188	(None)
clacker	15	38	1377	1	clacker
clicked	16	41	1245	1	clicked
clickers	16	39	1020	1	clickers
clinker	13	38	1166	1	clinker
clocker	15	39	1087	1	clocker
flicker	16	36	1062	1	flicker
licker	12	52	2204	1	_licker
slicker	13	33	1453	1	slicker
bicker	14	48	1917	2	_bicker
blacker	15	45	1351	2	blacker
blinker	13	41	1021	2	blinker
blocker	15	41	992	2	blocker
checker	18	32	953	2	checker
chicer	13	45	1360	2	chic_er
chickee	18	31	1155	2	chickee
chicken	18	27	898	2	chicken
chirker	16	42	932	2	chirker
clacked	16	41	1360	2	clacked
clackers	16	39	1170	2	clackers
cliche	13	37	1245	2	cliche_
cliched	15	37	1102	2	cliched
cliches	14	42	1374	2	cliches
click	13	52	1795	2	click__
clicks	14	53	1511	2	click_s
climber	13	44	913	2	climber
clincher	15	34	766	2	clincher
clinger	10	38	1215	2	clinger
clinked	14	40	1164	2	clinked
clinkers	14	33	983	2	clinkers
clipper	13	37	1032	2	clipper
clocked	16	41	1283	2	clocked
clockers	16	36	981	2	clockers
clucked	16	38	1013	2	clucked
clunker	13	41	946	2	clunker
cocker	14	43	2039	2	c_ocker
colickier	17	4	351	2	colickier
cracker	15	31	1417	2	cracker
cricked	16	48	1428	2	cricked
cricket	15	47	1695	2	cricket
crickey	18	41	814	2	crickey
dicker	13	45	2140	2	_dicker
flicked	17	46	1067	2	flicked
flickers	17	33	888	2	flickers
flickery	20	36	510	2	flickery
icker	11	40	1844	2	__icker
kicker	11	41	1618	2	_kicker
lacker	12	53	2562	2	_lacker
licked	13	46	2156	2	_licked
lickers	13	41	1825	2	_lickers
liker	9	56	2706	2	_li_ker
linker	10	43	2147	2	_linker
locker	12	40	1942	2	_locker
nicker	12	38	1870	2	_nicker
picker	14	44	2217	2	_picker
plinker	13	40	1097	2	plinker
plucker	15	36	825	2	plucker
pricker	15	40	1341	2	pricker
quicker	22	4	702	2	quicker
shicker	16	39	1482	2	shicker
sicker	12	40	2390	2	_sicker
slacker	13	39	1529	2	slacker
slicer	8	41	1760	2	slic_er
slicked	14	44	1384	2	slicked
slicken	13	30	929	2	slicken
slickers	14	31	1255	2	slickers
snicker	13	30	1267	2	snicker
sticker	13	35	1588	2	sticker
thicker	16	36	1102	2	thicker
ticker	12	43	2150	2	_ticker
tricker	13	46	1552	2	tricker
whicker	19	35	977	2	whicker
wicker	15	45	1867	2	_wicker

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	107671	0.390	458182.1
2	DLD Change Limit	107671	73	3.596	29941.9
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	4.016	44494.8