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

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

53 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
cheerer	12	35	1176	(None)
cheeper	14	36	1074	1	cheeper
cheered	13	37	1330	1	cheered
cheerers	13	31	954	1	cheerers
cheerier	13	4	801	1	cheerier
sheerer	10	38	1385	1	sheerer
caperer	11	30	1340	2	caperer
careerer	10	3	858	2	careerer
caterer	9	28	1595	2	caterer
cheaper	14	40	1058	2	cheaper
cheater	12	48	1696	2	cheater
checker	18	32	953	2	checker
cheder	12	51	1349	2	ch_eder
cheeked	17	39	966	2	cheeked
cheekier	17	3	510	2	cheekier
cheeped	15	34	1059	2	cheeped
cheepers	15	32	901	2	cheepers
cheer	10	54	2038	2	ch_e_er
cheerio	12	37	932	2	cheerio
cheerled	14	10	571	2	cheerled
cheerly	15	41	760	2	cheerly
cheero	11	47	1294	2	cheer_o
cheeros	12	37	1164	2	cheeros
cheers	11	45	1891	2	cheer_s
cheery	14	49	1315	2	cheer_y
cheese	11	38	1276	2	cheese_
cheesed	13	39	1068	2	cheesed
cheeses	12	36	1310	2	cheeses
cheesier	13	3	596	2	cheesier
chequer	21	3	515	2	chequer
chevre	14	31	831	2	chevre_
chevres	15	37	979	2	chevres
chevret	15	33	1063	2	chevret
chewer	14	55	1262	2	ch_ewer
chewier	15	3	759	2	chewier
chiefer	15	3	686	2	chiefer
clearer	9	37	1082	2	clearer
cleverer	13	3	456	2	cleverer
coherer	12	29	1278	2	coherer
coverer	12	31	1352	2	coverer
creeper	11	33	998	2	creeper
hearer	9	43	2365	2	_hearer
heeder	10	42	1604	2	_heeder
heeler	9	39	1732	2	_heeler
jeerer	13	38	993	2	_jeerer
queerer	16	10	650	2	queerer
shearer	10	44	1469	2	shearer
sheered	11	35	1546	2	sheered
sheeter	10	38	1491	2	sheeter
sneerer	7	35	1231	2	sneerer
steerer	7	31	1363	2	steerer
wheeler	13	29	878	2	wheeler
wheezer	22	29	668	2	wheezer

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.376	475242.0
2	DLD Change Limit	107671	53	2.860	37647.2
3	Display Results	53	53	0.030	1766.7
	(SQL Overall)	178691	53	3.266	54712.5