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

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

60 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
clerks	12	45	884	(None)
cleeks	12	50	1054	1	cleeks
clerk	11	58	1245	1	clerk_
alerts	6	44	1822	2	alerts
berks	11	54	2312	2	_berks
bleaks	12	51	1243	2	bleaks
carks	11	55	3421	2	c_arks
ceres	7	55	4001	2	c_eres
ceros	7	47	2607	2	c_eros
charks	15	52	1970	2	charks
checks	17	49	1270	2	checks
cheeks	15	47	1278	2	cheeks
cherts	11	56	1723	2	cherts
chirks	15	54	1484	2	chirks
clacks	14	45	1634	2	clacks
clanks	12	46	1518	2	clanks
claros	8	40	1511	2	claros
cleans	8	58	1705	2	cleans
clears	8	41	1656	2	clears
cleats	8	49	1931	2	cleats
cleek	11	55	1491	2	cleek_
clefs	10	66	1624	2	cle_fs
clefts	11	46	1016	2	clefts
clepes	10	42	1462	2	clepes
clergy	12	3	499	2	clergy
cleric	10	6	1213	2	cleric
clerics	11	4	933	2	clerics
clerid	9	3	1241	2	clerid
clerids	10	4	909	2	clerids
clerisy	12	4	682	2	clerisy
clerked	14	32	665	2	clerked
clerkish	17	4	426	2	clerkish
clerkly	16	4	357	2	clerkly
clevis	11	5	896	2	clevis
clews	10	55	1633	2	cle_ws
clicks	14	53	1511	2	clicks
clinks	12	58	1506	2	clinks
cloaks	12	44	1126	2	cloaks
clocks	14	49	1623	2	clocks
clonks	12	50	1347	2	clonks
clucks	14	45	1207	2	clucks
clunks	12	48	1101	2	clunks
corks	11	60	2827	2	c_orks
creaks	12	43	1596	2	creaks
creeks	12	48	1292	2	creeks
flecks	15	43	1080	2	flecks
gleeks	11	48	967	2	gleeks
jerks	16	65	1489	2	_jerks
larks	9	52	2781	2	_larks
leaks	9	59	2391	2	_leaks
leeks	9	53	1889	2	_leeks
leks	8	54	2760	2	_le_ks
lurks	9	52	1874	2	_lurks
merks	11	47	2240	2	_merks
perks	11	53	2580	2	_perks
scleras	9	4	822	2	scleras
sleeks	10	45	1246	2	sleeks
smerks	12	44	971	2	smerks
yerks	12	54	1656	2	_yerks
zerks	18	51	1382	2	_zerks

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	82551	0.123	1452772.4
2	DLD Change Limit	82551	60	4.346	18994.7
3	Display Results	60	60	0.013	4615.4
	(SQL Overall)	178691	60	4.482	39868.6