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

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

50 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
cheese	11	38	1276	(None)
cheesed	13	39	1068	1	cheesed
cheeses	12	36	1310	1	cheeses
cheesy	14	41	919	1	cheesy
creese	8	40	1433	1	creese
cease	7	52	2765	2	c_ease
cees	6	59	4159	2	c_ees_
cense	7	51	2140	2	c_ense
chaise	11	49	1641	2	chaise
chase	10	51	2712	2	ch_ase
chasse	11	51	1460	2	chasse
cheek	14	51	1571	2	chee_k
cheeked	17	39	966	2	cheeked
cheeks	15	47	1278	2	cheeks
cheeky	18	44	861	2	cheeky
cheep	12	54	1650	2	chee_p
cheeped	15	34	1059	2	cheeped
cheeper	14	36	1074	2	cheeper
cheeps	13	53	1291	2	cheeps
cheer	10	54	2038	2	chee_r
cheered	13	37	1329	2	cheered
cheerer	12	35	1175	2	cheerer
cheero	11	47	1293	2	cheero
cheers	11	45	1891	2	cheers
cheery	14	49	1315	2	cheery
cheesier	13	3	596	2	cheesier
chefs	13	62	1466	2	chefs_
chegoe	12	3	727	2	chegoe
chelae	11	36	1460	2	chelae
chemise	14	32	1150	2	chemise
cheque	20	3	666	2	cheque
chess	10	50	1692	2	ch_ess
chesses	12	41	1263	2	chesses
chest	10	49	2614	2	ch_est
chevre	14	31	831	2	chevre
chews	13	54	1851	2	chews_
choose	11	51	1614	2	choose
chose	10	59	2540	2	ch_ose
chouse	11	60	1756	2	chouse
chowse	14	47	1175	2	chowse
crease	8	55	1957	2	crease
creeses	9	39	1462	2	creeses
creesh	11	32	833	2	creesh
geese	6	43	1600	2	_geese
ghees	9	52	1555	2	ghees_
heeze	17	53	1348	2	_heeze
sheesh	12	3	781	2	sheesh
sheeve	12	34	1284	2	sheeve
these	8	65	1901	2	th_ese
wheeze	21	27	681	2	wheeze

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.140	1276364.3
2	DLD Change Limit	82551	50	4.453	18538.3
3	Display Results	50	50	0.033	1515.2
	(SQL Overall)	178691	50	4.626	38627.5