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

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

100 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
clonks	12	50	1347	(None)
clanks	12	46	1518	1	clanks
clinks	12	58	1506	1	clinks
cloaks	12	44	1126	1	cloaks
clocks	14	49	1623	1	clocks
clones	8	45	2656	1	clones
clonk	11	44	1744	1	clonk_
clons	7	52	2813	1	clon_s
clonus	8	52	1241	1	clonus
clunks	12	48	1101	1	clunks
conks	11	55	2570	1	c_onks
plonks	12	42	1042	1	plonks
blanks	12	41	1289	2	blanks
blinks	12	46	1357	2	blinks
blocks	14	45	1394	2	blocks
blonds	9	52	1334	2	blonds
bonks	11	63	2646	2	_bonks
chinks	15	58	1757	2	chinks
chocks	17	48	1531	2	chocks
chooks	15	53	1279	2	chooks
chunks	15	42	1033	2	chunks
cions	7	52	2285	2	cion_s
clacks	14	45	1634	2	clacks
clangs	9	51	1361	2	clangs
clank	11	47	1952	2	clank_
clanky	15	46	907	2	clanky
clans	7	50	3101	2	clan_s
cleeks	12	50	1054	2	cleeks
clerks	12	45	884	2	clerks
clicks	14	53	1511	2	clicks
clines	8	49	2604	2	clines
clings	9	57	1621	2	clings
clink	11	53	2004	2	clink_
cloak	11	52	1401	2	cloak_
clock	13	49	1798	2	clock_
clods	8	53	2086	2	clo_ds
clogs	8	55	1955	2	clo_gs
clomps	12	52	1223	2	clomps
clon	6	62	3248	2	clon__
clonal	8	3	1091	2	clonal
clone	7	57	2816	2	clon_e
cloned	9	45	1880	2	cloned
cloner	8	44	1809	2	cloner
cloners	9	45	1482	2	cloners
clonic	10	49	1467	2	clonic
clonism	11	3	898	2	clonism
clonked	14	42	956	2	clonked
cloots	8	51	1369	2	cloots
clops	9	59	2485	2	clo_ps
closes	8	54	2559	2	closes
cloths	11	55	1248	2	cloths
clots	7	56	2764	2	clo_ts
clouds	9	46	1235	2	clouds
clours	8	52	1509	2	clours
clouts	8	70	1720	2	clouts
cloves	11	49	1882	2	cloves
clowns	11	48	1011	2	clowns
cloys	10	49	1694	2	clo_ys
clozes	17	49	1556	2	clozes
clucks	14	45	1207	2	clucks
clunk	11	42	1508	2	clunk_
clunky	15	44	789	2	clunky
cocks	13	52	2716	2	c_ocks
colones	9	61	2443	2	colones
colons	8	60	2868	2	colon_s
colonus	9	44	1344	2	colonus
cones	7	64	5742	2	c_ones
conk	10	65	3144	2	c_onk_
conky	14	58	1874	2	c_onky
conns	7	50	2423	2	c_onns
cons	6	60	5769	2	c_on_s
conus	7	67	2653	2	c_onus
cooks	11	54	2914	2	c_ooks
coons	7	67	3728	2	coon_s
corks	11	60	2827	2	c_orks
cranks	12	50	1531	2	cranks
croaks	12	58	1298	2	croaks
crocks	14	51	1842	2	crocks
crones	8	47	2924	2	crones
crooks	12	49	1441	2	crooks
flanks	13	39	1340	2	flanks
flocks	15	47	1353	2	flocks
flongs	10	50	1049	2	flongs
flunks	13	46	986	2	flunks
honks	12	51	2452	2	_honks
klongs	11	43	660	2	klongs
konks	8	49	1711	2	_konks
links	9	64	3019	2	_links
locks	11	51	2692	2	_locks
longs	6	55	2706	2	_longs
looks	9	51	2486	2	_looks
lunks	9	48	2245	2	_lunks
monks	11	61	2339	2	_monks
planks	12	41	1675	2	planks
plinks	12	49	1326	2	plinks
plonk	11	46	1398	2	plonk_
plunks	12	47	1116	2	plunks
slinks	10	43	1515	2	slinks
wonks	12	48	1834	2	_wonks
zonks	18	48	1517	2	_zonks

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	100	2.173	37989.4
3	Display Results	100	100	0.030	3333.3
	(SQL Overall)	178691	100	2.546	70185.0