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

Here are the results of your fuzzy-string dictionary search for “comfreys” with Change Limit: [1] [2] [3] [4]

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
comfreys	18	4	333	(None)
comfrey	17	3	468	1	comfrey_
coffrets	16	4	536	2	coffrets
compress	14	3	905	2	compress
pomfrets	15	4	303	2	pomfrets
cockneys	19	3	449	3	cockneys
coffees	15	32	957	3	co_ffees
coffers	15	41	1269	3	co_ffers
coffles	15	26	1000	3	coffle_s
coffret	15	3	1007	3	coffre_t
coherers	13	23	1073	3	coherers
coheres	12	29	1769	3	cohere_s
coiffes	15	4	680	3	coiffe_s
coloreds	11	3	809	3	coloreds
colorers	10	3	1218	3	colorers
colures	9	3	1514	3	colure_s
comakers	16	33	917	3	comakers
comakes	15	44	1364	3	comake_s
comates	11	41	2364	3	comate_s
combers	13	45	1662	3	com_bers
combes	12	53	2173	3	com_be_s
comers	10	53	2808	3	com__ers
comes	9	72	4699	3	com__e_s
comets	10	58	2358	3	com__ets
comfier	14	3	916	3	comfie_r
comfiest	15	3	913	3	comfiest
comfiness	16	4	695	3	comfiness
comfits	14	32	874	3	comf_its
comforters	17	27	520	3	comforters
comforts	15	34	732	3	comforts
comfy	15	37	1021	3	comf__y_
commies	13	37	1845	3	commie_s
comparers	15	31	939	3	comparers
compares	14	38	1643	3	compare_s
compeers	14	34	1001	3	compeers
compels	13	32	1089	3	com_pels
comperes	14	32	1797	3	comperes
comtes	10	62	2281	3	com_te_s
coneys	11	52	1842	3	co__neys
conferees	14	6	1062	3	conferees
confers	12	41	2009	3	conf_ers
confess	12	39	990	3	conf_ess
confrere	13	4	756	3	confrere
confreres	14	4	803	3	confreres
congress	11	3	807	3	congress
conveys	15	30	822	3	co_nveys
cooeys	11	49	1448	3	co__oeys
cookeys	16	47	850	3	co_okeys
corers	8	52	3107	3	co__rers
cores	7	63	6185	3	co__re_s
coseys	11	52	1581	3	co__seys
costrels	10	3	893	3	costrels
coverers	13	27	1212	3	coverers
coveys	14	54	1350	3	co__veys
cozeys	20	46	1091	3	co__zeys
gomerels	11	4	457	3	gomerels
hombres	14	36	988	3	hombre_s
homeys	14	50	1288	3	hom__eys
koupreys	17	4	173	3	koupreys
lampreys	15	4	288	3	lampreys
ombres	10	39	1114	3	_ombre_s
orfrays	13	4	353	3	_orfrays
ospreys	12	3	314	3	_ospreys
palfreys	16	4	200	3	palfreys
pomfret	14	4	699	3	pomfre_t

Search took 9 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	146162	0.420	425454.8
2	DLD Change Limit	146162	65	7.940	18408.3
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	8.390	21298.1