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

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

90 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
compos	12	48	1880	(None)
campos	12	52	1795	1	campos
combos	12	53	1661	1	combos
compas	12	58	1706	1	compas
compo	11	53	1857	1	compo_
compose	13	57	1666	1	compose
compost	13	45	1535	1	compost
comps	11	55	2605	1	comp_s
compts	12	52	1665	1	compts
cameos	10	58	1800	2	cameos
camos	9	59	2761	2	cam_os
campo	11	52	1976	2	campo_
camps	11	63	3026	2	camp_s
campus	12	52	1392	2	campus
capos	9	48	2607	2	c_apos
chomps	15	51	1222	2	chomp_s
clomps	12	52	1223	2	clomp_s
coapts	10	46	1401	2	coapts
cocos	9	56	2469	2	co_cos
coempts	13	3	568	2	coempts
cohos	10	59	2185	2	co_hos
comas	9	58	3300	2	com_as
combes	12	53	2173	2	combes
combo	11	45	1943	2	combo_
combs	11	61	2296	2	com_bs
comedos	12	32	907	2	comedos
comers	10	53	2808	2	comers
comes	9	72	4699	2	com_es
comets	10	58	2358	2	comets
comics	12	40	1556	2	comics
commas	12	48	1457	2	commas
common	12	3	1080	2	common
commons	13	3	1104	2	commons
comose	10	50	1685	2	com_ose
comous	10	8	1651	2	comous
comp	10	67	3125	2	comp__
compass	13	37	956	2	compass
comped	13	59	1987	2	comped
compel	12	44	1289	2	compel
compels	13	32	1089	2	compels
complot	13	3	1068	2	complot
complots	14	3	816	2	complots
comply	15	28	1038	2	comply
compone	13	65	1719	2	compone
compony	16	130	1191	2	compony
comport	13	36	1684	2	comport
comports	14	34	1198	2	comports
composed	15	46	1206	2	composed
composer	14	50	1295	2	composer
composes	14	50	1712	2	composes
composts	14	42	1091	2	composts
compote	13	56	1646	2	compote
compotes	14	47	1651	2	compotes
compt	11	63	2822	2	comp_t
comtes	10	62	2281	2	comtes
condos	9	43	2233	2	condos
congos	9	42	1988	2	congos
contos	8	49	2323	2	contos
coops	9	62	2964	2	coop_s
coopts	10	58	1458	2	coopts
coos	6	74	5649	2	co__os
copes	9	77	4710	2	co_pes
cops	8	67	5137	2	co_p_s
corps	9	59	2704	2	corp_s
corpus	10	60	1529	2	corpus
cosmos	10	3	1175	2	cosmos
coupes	10	50	2252	2	coupes
coupon	10	28	1099	2	coupon
coupons	11	27	1056	2	coupons
coups	9	55	2247	2	coup_s
cowpox	20	3	500	2	cowpox
coypou	13	26	840	2	coypou
coypous	14	24	881	2	coypous
coypus	13	38	930	2	coypus
gombos	11	43	1109	2	gombos
hommos	13	12	850	2	hommos
homos	10	59	2179	2	hom_os
nomos	7	59	1974	2	nom_os
oomphs	13	4	472	2	oomphs
pomos	9	53	2158	2	pom_os
pompom	14	3	649	2	pompom
pompoms	15	3	533	2	pompoms
pompon	12	3	894	2	pompon
pompons	13	3	855	2	pompons
pompous	13	3	806	2	pompous
pomps	11	53	1619	2	pomp_s
romeos	8	40	1317	2	romeos
romps	9	46	1754	2	romp_s
tempos	10	38	1229	2	tempos
topos	7	57	2639	2	to_pos

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.716	249568.4
2	DLD Change Limit	82551	90	3.236	25510.2
3	Display Results	90	90	0.030	3000.0
	(SQL Overall)	178691	90	3.982	44874.7