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

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

70 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
cleeks	12	50	1054	(None)
cheeks	15	47	1278	1	cheeks
cleek	11	55	1491	1	cleek_
clerks	12	45	884	1	clerks
creeks	12	48	1292	1	creeks
gleeks	11	48	967	1	gleeks
leeks	9	53	1889	1	_leeks
sleeks	10	45	1246	1	sleeks
bleaks	12	51	1243	2	bleaks
bleeds	9	52	1159	2	bleeds
bleeps	10	49	910	2	bleeps
breeks	12	53	1079	2	breeks
cees	6	59	4159	2	c_ee_s
celebs	10	3	788	2	celebs
checks	17	49	1270	2	checks
cheek	14	51	1571	2	cheek_
cheeky	18	44	861	2	cheeky
cheeps	13	53	1291	2	cheeps
cheers	11	45	1891	2	cheers
clacks	14	45	1634	2	clacks
clanks	12	46	1518	2	clanks
cleans	8	58	1705	2	cleans
clears	8	41	1656	2	clears
cleats	8	49	1931	2	cleats
cleeked	14	35	773	2	cleeked
clefs	10	66	1624	2	cl_efs
clefts	11	46	1016	2	clefts
clepes	10	42	1462	2	clepes
clerk	11	58	1245	2	clerk_
clevis	11	5	896	2	clevis
clews	10	55	1633	2	cl_ews
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
clues	7	46	2303	2	clue_s
clunks	12	48	1101	2	clunks
creaks	12	43	1596	2	creaks
creeds	9	47	1477	2	creeds
creek	11	49	1739	2	creek_
creels	8	44	1694	2	creels
creeps	10	42	1362	2	creeps
flecks	15	43	1080	2	flecks
fleers	9	60	1579	2	fleers
flees	8	58	2875	2	flee_s
fleets	9	69	1506	2	fleets
geeks	10	49	1584	2	_geeks
gleeds	8	47	1162	2	gleeds
gleek	10	53	1510	2	gleek_
glees	6	50	2759	2	glee_s
gleets	7	53	1505	2	gleets
keeks	8	47	1725	2	_keeks
leaks	9	59	2391	2	_leaks
leek	8	53	3173	2	_leek_
leers	5	48	2898	2	_leers
lees	4	54	5588	2	_lee_s
leets	5	49	2712	2	_leets
leks	8	54	2760	2	_l_eks
peeks	11	50	2111	2	_peeks
reeks	9	41	2403	2	_reeks
seeks	9	47	2464	2	_seeks
sleek	9	46	1904	2	sleek_
sleeky	13	39	896	2	sleeky
sleeps	8	39	1332	2	sleeps
sleets	6	43	1887	2	sleets
smeeks	12	42	843	2	smeeks
steeks	10	36	1370	2	steeks
weeks	12	50	1786	2	_weeks

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.233	766914.2
2	DLD Change Limit	82551	70	2.703	30540.5
3	Display Results	70	70	0.016	4375.0
	(SQL Overall)	178691	70	2.952	60532.2