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

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

78 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
clicked	16	41	1245	(None)
clacked	16	41	1360	1	clacked
cliched	15	37	1102	1	cliched
clicker	15	41	1188	1	clicker
clinked	14	40	1164	1	clinked
clocked	16	41	1283	1	clocked
clucked	16	38	1013	1	clucked
cricked	16	48	1428	1	cricked
flicked	17	46	1067	1	flicked
licked	13	46	2156	1	_licked
slicked	14	44	1384	1	slicked
blacked	16	36	1337	2	blacked
blinked	14	40	1001	2	blinked
blocked	16	44	998	2	blocked
bricked	16	43	1206	2	bricked
checked	19	37	1002	2	checked
chickee	18	31	1155	2	chickee
chicken	18	27	898	2	chicken
chinked	17	40	1102	2	chinked
chirked	17	38	1033	2	chirked
chocked	19	44	1161	2	chocked
chucked	19	46	973	2	chucked
clacker	15	38	1377	2	clacker
clanked	14	38	1225	2	clanked
cleeked	14	35	773	2	cleeked
clerked	14	32	665	2	clerked
cliche	13	37	1245	2	cliche_
cliches	14	42	1374	2	cliches
click	13	52	1795	2	click__
clickers	16	39	1020	2	clickers
clicks	14	53	1511	2	click_s
climbed	14	33	698	2	climbed
clinched	16	34	738	2	clinched
clinged	11	33	1009	2	clinged
clinker	13	38	1166	2	clinker
clipped	14	43	983	2	clipped
cliqued	19	26	668	2	cliqued
cloaked	14	36	854	2	cloaked
clocker	15	39	1087	2	clocker
clonked	14	42	956	2	clonked
clunked	14	43	957	2	clunked
cocked	15	50	2256	2	c_ocked
cracked	16	35	1474	2	cracked
cricket	15	47	1695	2	cricket
crickey	18	41	814	2	crickey
crocked	16	40	1443	2	crocked
dicked	14	49	2086	2	_dicked
flacked	17	37	1158	2	flacked
flecked	17	35	807	2	flecked
flicker	16	36	1062	2	flicker
flocked	17	45	1025	2	flocked
hoicked	17	3	596	2	hoicked
kicked	12	44	1594	2	_kicked
lacked	13	53	2465	2	_lacked
licker	12	52	2204	2	_licker
liked	10	45	2381	2	_li_ked
linked	11	45	1821	2	_linked
locked	13	49	2166	2	_locked
lucked	13	51	1802	2	_lucked
nicked	13	50	1968	2	_nicked
picked	15	44	2131	2	_picked
plinked	14	39	1089	2	plinked
plucked	16	36	796	2	plucked
pricked	16	46	1383	2	pricked
ricked	13	65	2362	2	_ricked
sicked	13	45	2440	2	_sicked
slacked	14	38	1545	2	slacked
sliced	9	44	1631	2	slic_ed
slicken	13	30	929	2	slicken
slicker	13	33	1453	2	slicker
slinked	12	30	1138	2	slinked
snicked	14	38	1163	2	snicked
sticked	14	41	1463	2	sticked
ticked	13	47	2052	2	_ticked
tricked	14	40	1616	2	tricked
unlicked	15	24	826	2	unlicked
wicked	16	43	1741	2	_wicked
wricked	17	49	1019	2	wricked

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	107671	0.390	458182.1
2	DLD Change Limit	107671	78	3.423	31455.2
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	3.843	46497.8