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

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

72 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
cheered	13	37	1329	(None)
cheeked	17	39	966	1	cheeked
cheeped	15	34	1059	1	cheeped
cheerer	12	35	1175	1	cheerer
cheerled	14	10	570	1	cheerled
cheesed	13	39	1068	1	cheesed
sheered	11	35	1545	1	sheered
capered	12	30	1404	2	capered
careered	11	3	949	2	careered
catered	10	31	1777	2	catered
cered	8	52	2744	2	c__ered
chaired	13	42	1124	2	chaired
chared	12	54	2369	2	ch_ared
charred	13	46	1448	2	charred
cheated	13	44	1634	2	cheated
checked	19	37	1002	2	checked
checkered	21	4	468	2	checkered
cheeper	14	36	1074	2	cheeper
cheer	10	54	2038	2	cheer__
cheerers	13	31	954	2	cheerers
cheerier	13	4	800	2	cheerier
cheerio	12	37	931	2	cheerio
cheerlead	15	9	300	2	cheerlead
cheerly	15	41	760	2	cheerly
cheero	11	47	1293	2	cheer_o
cheeros	12	37	1163	2	cheeros
cheers	11	45	1891	2	cheer_s
cheery	14	49	1315	2	cheer_y
cheese	11	38	1276	2	cheese_
cheeses	12	36	1310	2	cheeses
chefed	15	50	1056	2	ch_efed
cheffed	19	33	586	2	cheffed
chequered	24	4	261	2	chequered
chested	13	38	1167	2	chested
chevied	16	35	748	2	chevied
chevre	14	31	831	2	chevre_
chevres	15	37	979	2	chevres
chevret	15	33	1063	2	chevret
chewed	15	44	1501	2	ch_ewed
chirred	13	36	1212	2	chirred
choired	13	34	934	2	choired
chored	12	53	2188	2	ch_ored
churred	13	40	917	2	churred
cleared	10	36	1246	2	cleared
cleeked	14	35	773	2	cleeked
cohered	13	35	1469	2	cohered
covered	13	33	1529	2	covered
cowered	13	32	1465	2	cowered
creeled	10	40	1201	2	creeled
creeped	12	32	971	2	creeped
fleered	11	30	950	2	fleered
heeded	11	42	1576	2	_heeded
heeled	10	40	1841	2	_heeled
heezed	19	42	1051	2	_heezed
heired	10	38	1304	2	_heired
jeered	14	39	1279	2	_jeered
leered	7	38	1622	2	_leered
ochered	13	26	1028	2	och_ered
peered	9	38	1949	2	_peered
queered	17	11	721	2	queered
schmeered	17	4	327	2	schmeered
sheared	11	45	1600	2	sheared
sheened	11	35	1170	2	sheened
sheerer	10	38	1384	2	sheerer
sheeted	11	38	1304	2	sheeted
sneered	8	31	1397	2	sneered
speered	10	36	1481	2	speered
steered	8	36	1525	2	steered
veered	10	36	1274	2	_veered
wheeled	14	31	846	2	wheeled
wheeped	16	38	750	2	wheeped
wheezed	23	29	645	2	wheezed

Search took 4 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	107671	0.393	454684.5
2	DLD Change Limit	107671	72	3.140	34290.1
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	3.563	50151.8