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

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

65 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
chemo	12	3	1363	(None)
chemos	13	3	1172	1	chemos
ahem	9	72	2536	2	ahem_
cameo	9	59	2499	2	cameo
camo	8	57	3175	2	c_amo
cero	6	63	2945	2	c_ero
cham	11	55	3231	2	cham_
champ	14	50	1796	2	champ
chams	12	60	2850	2	chams
chao	9	57	2731	2	ch_ao
cheap	12	69	1594	2	cheap
cheapo	13	48	1008	2	cheapo
cheat	10	57	3245	2	cheat
check	16	47	1471	2	check
cheek	14	51	1571	2	cheek
cheep	12	54	1650	2	cheep
cheer	10	54	2038	2	cheer
cheero	11	47	1293	2	cheero
chef	12	51	2562	2	che_f
chefs	13	62	1466	2	chefs
chegoe	12	3	727	2	chegoe
chela	10	39	1680	2	chela
chemic	15	30	1209	2	chemic
chert	10	52	3210	2	chert
chess	10	50	1692	2	chess
chest	10	49	2614	2	chest
cheth	13	50	1382	2	cheth
chevy	16	47	999	2	chevy
chew	12	66	2213	2	che_w
chews	13	54	1851	2	chews
chewy	16	50	1190	2	chewy
chez	18	45	1902	2	che_z
chiao	10	56	1836	2	chiao
chico	12	42	1825	2	chico
chimb	14	48	1356	2	chimb
chime	12	53	2259	2	chime
chimp	14	52	1647	2	chimp
chino	10	58	2331	2	chino
chiro	10	53	2034	2	chiro
cholo	10	52	1797	2	cholo
chomp	14	48	1566	2	chomp
chromo	13	28	1101	2	chromo
chum	11	63	1800	2	chum_
chump	14	53	1544	2	chump
chums	12	50	1583	2	chums
chyme	15	65	1250	2	chyme
credo	8	48	1556	2	credo
creme	9	43	1932	2	creme
demo	7	74	2755	2	_demo
helo	7	53	3285	2	_helo
hem	8	61	4873	2	_hem_
heme	9	50	3441	2	_heme
hemp	11	57	2562	2	_hemp
hems	9	55	3494	2	_hems
hero	7	46	3578	2	_hero
homo	9	61	2647	2	_homo
memo	8	59	2479	2	_memo
rheme	10	62	1405	2	rheme
schema	13	8	837	2	schema
scheme	13	7	963	2	scheme
schmo	12	45	1020	2	sch_mo
shmo	9	53	1809	2	sh_mo
them	9	74	2704	2	them_
theme	10	59	2173	2	theme
whamo	13	55	1126	2	whamo

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	53800	0.093	1921408.6
2	DLD Change Limit	53800	65	2.030	26502.5
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	2.139	83539.5