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

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

82 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
clinker	13	38	1166	(None)
blinker	13	41	1021	1	blinker
clicker	15	41	1188	1	clicker
clinger	10	38	1215	1	clinger
clinked	14	40	1164	1	clinked
clinkers	14	33	983	1	clinkers
clunker	13	41	945	1	clunker
linker	10	43	2147	1	_linker
plinker	13	40	1096	1	plinker
aliner	6	56	2198	2	alin_er
blanker	13	46	1202	2	blanker
blinder	10	39	1298	2	blinder
blinked	14	40	1001	2	blinked
blinkers	14	38	850	2	blinkers
canker	12	44	2252	2	c_anker
chinked	17	40	1102	2	chinked
chinkier	17	37	736	2	chinkier
chirker	16	42	932	2	chirker
cinder	9	41	1912	2	c_inder
clacker	15	38	1377	2	clacker
clanger	10	41	1349	2	clanger
clanked	14	38	1225	2	clanked
clankier	14	32	708	2	clankier
clicked	16	41	1245	2	clicked
clickers	16	39	1020	2	clickers
climber	13	44	913	2	climber
clincher	15	34	766	2	clincher
cline	7	64	2853	2	clin_e_
clines	8	49	2604	2	clin_es
clinged	11	33	1009	2	clinged
clingers	11	38	1066	2	clingers
clingier	11	5	585	2	clingier
clink	11	53	2004	2	clink__
clinkered	16	3	477	2	clinkered
clinks	12	58	1506	2	clink_s
clipper	13	37	1032	2	clipper
clocker	15	39	1087	2	clocker
cloner	8	44	1809	2	clon_er
clonked	14	42	956	2	clonked
clunked	14	43	957	2	clunked
clunkers	14	32	755	2	clunkers
clunkier	14	34	579	2	clunkier
coiner	8	43	2378	2	coin_er
coinfer	12	41	939	2	coinfer
cointer	9	36	1672	2	cointer
conker	12	47	2155	2	c_onker
cranker	13	36	1278	2	cranker
cringer	10	35	1424	2	cringer
cylinder	14	3	338	2	cylinder
drinker	12	34	948	2	drinker
flanker	14	39	1129	2	flanker
flicker	16	36	1062	2	flicker
flinder	11	31	987	2	flinder
flinger	11	37	1051	2	flinger
flunker	14	38	936	2	flunker
inker	9	44	2109	2	__inker
jinker	17	40	1354	2	_jinker
lanker	10	41	2300	2	_lanker
licker	12	52	2204	2	_licker
liker	9	56	2706	2	_li_ker
liner	5	59	3892	2	_lin_er
linger	7	52	2600	2	_linger
linier	6	44	2379	2	_linier
linked	11	45	1821	2	_linked
linkers	11	43	1771	2	_linkers
linter	6	46	2534	2	_linter
lunker	10	47	1834	2	_lunker
pinker	12	53	2244	2	_pinker
plinked	14	39	1089	2	plinked
plinkers	14	30	939	2	plinkers
plunker	13	39	1065	2	plunker
prinker	13	34	1274	2	prinker
sinker	10	36	2090	2	_sinker
skinker	10	31	944	2	skinker
slicker	13	33	1453	2	slicker
slinger	8	34	1383	2	slinger
slinked	12	30	1138	2	slinked
slinkier	12	20	693	2	slinkier
stinker	11	33	1331	2	stinker
thinker	14	36	1068	2	thinker
tinker	10	36	1992	2	_tinker
winker	13	42	2029	2	_winker

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.360	496363.9
2	DLD Change Limit	107671	82	2.860	37647.2
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	3.250	54981.8