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

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

75 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
cheeks	15	47	1278	(None)
checks	17	49	1270	1	checks
cheek	14	51	1571	1	cheek_
cheeky	18	44	861	1	cheeky
cheeps	13	53	1291	1	cheeps
cheers	11	45	1891	1	cheers
cleeks	12	50	1054	1	cleeks
creeks	12	48	1292	1	creeks
breeks	12	53	1079	2	breeks
cees	6	59	4159	2	c_ee_s
chalks	15	54	1214	2	chalks
charks	15	52	1970	2	charks
cheaps	13	46	1368	2	cheaps
cheats	11	45	1954	2	cheats
chebecs	16	3	501	2	chebecs
check	16	47	1471	2	check_
cheders	13	45	1239	2	cheders
cheeked	17	39	966	2	cheeked
cheep	12	54	1650	2	chee_p
cheer	10	54	2038	2	chee_r
cheero	11	47	1293	2	cheero
cheeros	12	37	1163	2	cheeros
cheery	14	49	1315	2	cheery
cheese	11	38	1276	2	cheese
cheeses	12	36	1310	2	cheeses
cheesy	14	41	919	2	cheesy
chefs	13	62	1466	2	ch_efs
chelas	11	38	1720	2	chelas
chemos	13	3	1172	2	chemos
cherts	11	56	1723	2	cherts
chess	10	50	1692	2	ch_ess
chests	11	49	1626	2	chests
cheths	14	38	982	2	cheths
chewers	15	41	1114	2	chewers
chews	13	54	1851	2	ch_ews
chicks	17	53	1759	2	chicks
chiefs	14	50	965	2	chiefs
chiels	11	51	1593	2	chiels
chinks	15	58	1757	2	chinks
chirks	15	54	1484	2	chirks
chocks	17	48	1531	2	chocks
chokes	15	49	1738	2	chokes
chooks	15	53	1279	2	chooks
chucks	17	48	1293	2	chucks
chunks	15	42	1033	2	chunks
cleek	11	55	1491	2	cleek_
clerks	12	45	884	2	clerks
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
geeks	10	49	1584	2	_geeks
ghees	9	52	1555	2	ghee_s
gleeks	11	48	967	2	gleeks
hecks	14	52	2065	2	_hecks
heeds	9	54	2042	2	_heeds
heels	8	56	2553	2	_heels
keeks	8	47	1725	2	_keeks
leeks	9	53	1889	2	_leeks
peeks	11	50	2111	2	_peeks
reeks	9	41	2403	2	_reeks
seeks	9	47	2464	2	_seeks
sheens	9	51	1699	2	sheens
sheers	9	43	2240	2	sheers
sheets	9	39	1850	2	sheets
sheiks	13	25	1001	2	sheiks
sleeks	10	45	1246	2	sleeks
smeeks	12	42	843	2	smeeks
steeks	10	36	1370	2	steeks
weeks	12	50	1786	2	_weeks
wheels	12	38	1171	2	wheels
wheens	12	46	1061	2	wheens
wheeps	14	43	995	2	wheeps
whelks	16	36	732	2	whelks

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.373	479064.3
2	DLD Change Limit	82551	75	4.203	19641.0
3	Display Results	75	75	0.030	2500.0
	(SQL Overall)	178691	75	4.606	38795.3