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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

229 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
compost	13	45	1535	(None)
comport	13	36	1684	1	comport
compos	12	48	1880	1	compos_
compose	13	57	1666	1	compose
composts	14	42	1091	1	composts
campos	12	52	1795	2	campos_
campout	13	4	1285	2	campout
cohost	11	52	1721	2	co_host
combos	12	53	1661	2	combos_
combust	13	3	836	2	combust
comfort	14	36	1169	2	comfort
comose	10	50	1685	2	com_ose
compact	15	37	1221	2	compact
compart	13	40	1600	2	compart
compas	12	58	1706	2	compas_
compass	13	37	956	2	compass
complot	13	3	1068	2	complot
complots	14	3	816	2	complots
compo	11	53	1857	2	compo__
compone	13	65	1719	2	compone
compony	16	130	1191	2	compony
comports	14	34	1198	2	comports
composed	15	46	1206	2	composed
composer	14	50	1295	2	composer
composes	14	50	1712	2	composes
composite	15	4	1015	2	composite
composted	16	37	882	2	composted
composter	15	36	957	2	composter
compote	13	56	1646	2	compote
comps	11	55	2605	2	comp_s_
compt	11	63	2822	2	comp__t
compts	12	52	1665	2	compts_
copout	10	4	1878	2	co_pout
impost	10	30	1178	2	_impost
topmost	11	4	817	2	topmost
airpost	9	3	924	3	airpost
almost	8	10	1443	3	alm_ost
bedpost	12	4	724	3	bedpost
bombast	13	4	822	3	bombast
boost	7	51	3247	3	bo__ost
bowpot	13	4	1007	3	bowpo_t
bowpots	14	4	602	3	bowpots
cambist	13	3	1211	3	cambist
cameos	10	58	1800	3	cameos_
camos	9	59	2761	3	cam_os_
campiest	14	22	1214	3	campiest
campo	11	52	1976	3	campo__
campong	14	31	812	3	campong
campouts	14	3	682	3	campouts
camps	11	63	3026	3	camp_s_
campus	12	52	1392	3	campus_
capos	9	48	2607	3	c_apos_
carport	11	3	1603	3	carport
chomps	15	51	1222	3	chomp_s_
clomps	12	52	1223	3	clomp_s_
coapt	9	61	3153	3	coap__t
coapts	10	46	1401	3	coapts_
coast	7	52	3627	3	co__ast
cocos	9	56	2469	3	co_cos_
coempt	12	3	1103	3	coemp__t
coempts	13	3	568	3	coempts_
coexist	16	3	858	3	coexist
cohort	11	107	2026	3	co_hort
cohos	10	59	2185	3	co_hos_
cohosh	14	51	712	3	co_hosh
cohosts	12	39	881	3	co_hosts
coldest	10	25	1476	3	coldest
comas	9	58	3300	3	com_as_
comatose	12	4	782	3	comatose
combat	12	3	1675	3	com_bat
combats	13	3	1168	3	combats
combes	12	53	2173	3	combes_
combo	11	45	1943	3	combo__
combs	11	61	2296	3	com_bs_
combusts	14	4	550	3	combusts
comedos	12	32	907	3	comedos_
comers	10	53	2808	3	comers_
comes	9	72	4699	3	com_es_
comet	9	59	4607	3	com__et
comets	10	58	2358	3	comets_
comfiest	15	3	913	3	comfiest
comfit	13	31	1242	3	com_fit
comfits	14	32	874	3	comfits
comforts	15	34	732	3	comforts
comics	12	40	1556	3	comics_
commas	12	48	1457	3	commas_
comment	13	103	1770	3	comment
commit	12	40	1670	3	com_mit
commits	13	38	1238	3	commits
commixt	20	35	762	3	commixt
commode	14	3	812	3	commode
common	12	3	1080	3	commo_n
commonest	15	4	925	3	commonest
commons	13	3	1104	3	commons
commove	16	3	596	3	commove
comous	10	8	1651	3	com_ous
comp	10	67	3125	3	comp___
compacts	16	36	890	3	compacts
company	16	197	1114	3	company
compare	13	58	1499	3	compare
comparts	14	42	1083	3	comparts
comped	13	59	1987	3	comp_ed
compeer	13	38	1155	3	compeer
compel	12	44	1289	3	comp_el
compels	13	32	1089	3	compels
compend	14	40	1030	3	compend
compere	13	46	1662	3	compere
compete	13	47	1655	3	compete
compile	13	3	1244	3	compile
comping	14	35	1859	3	comping
compleat	14	7	1015	3	compleat
complect	16	5	901	3	complect
complete	14	34	1205	3	complete
complex	20	3	724	3	complex
complin	13	3	1207	3	complin
comply	15	28	1038	3	comp_ly
component	15	4	1108	3	component
comported	16	31	953	3	comported
composers	15	39	1064	3	composers
composing	16	17	984	3	composing
composited	17	5	600	3	composited
composites	16	4	890	3	composites
compositor	16	4	463	3	compositor
composters	16	38	833	3	compost~~ers~~
composting	17	17	805	3	compost~~ing~~
composure	15	4	512	3	composure
compotes	14	47	1651	3	compotes
compound	15	5	599	3	compound
compress	14	3	905	3	compress
comprise	14	3	1081	3	comprise
compted	14	38	1352	3	compted
compute	13	45	1366	3	compute
computist	15	4	732	3	computist
comtes	10	62	2281	3	comtes_
concoct	10	3	1290	3	concoct
condos	9	43	2233	3	condos_
congest	10	46	1877	3	congest
congos	9	42	1988	3	congos_
consist	9	3	1603	3	consist
consort	9	13	1990	3	consort
contest	9	35	2323	3	contest
contort	9	14	2234	3	contort
contos	8	49	2323	3	contos_
cookout	13	4	1015	3	cookout
coolest	9	3	1864	3	coolest
coops	9	62	2964	3	coop_s_
coopt	9	59	2985	3	co__opt
coopts	10	58	1458	3	coopts_
coos	6	74	5649	3	co__os_
coot	6	78	6038	3	co__o_t
coots	7	56	3684	3	co__ots
copes	9	77	4710	3	co_pes_
coplot	10	5	1827	3	co_plot
coplots	11	5	1159	3	coplots
copouts	11	3	1108	3	co_pouts
cops	8	67	5137	3	co_p_s_
copse	9	56	2393	3	co_p_se
copyist	14	3	905	3	copyist
corpora	11	3	935	3	corpora
corposant	13	4	709	3	corposant
corps	9	59	2704	3	corp_s_
corpse	10	40	1341	3	corp_se
corpus	10	60	1529	3	corpus_
cosiest	9	38	1985	3	cosiest
cosmist	11	3	1133	3	cosmist
cosmos	10	3	1175	3	cosmos_
cost	6	80	5794	3	c___ost
couldst	10	3	704	3	couldst
coupes	10	50	2252	3	coupes_
couplet	11	47	1794	3	couplet
coupon	10	28	1099	3	coupo_n
coupons	11	27	1056	3	coupons
coups	9	55	2247	3	coup_s_
cowiest	12	36	1467	3	cowiest
cowpat	13	3	1203	3	cowp_at
cowpats	14	3	771	3	cowpats
cowpoke	18	3	510	3	cowpoke
cowpox	20	3	500	3	cowpo_x
coyest	11	3	1605	3	co_yest
coypou	13	26	840	3	coypo_u
coypous	14	24	881	3	coypous
coypus	13	38	930	3	coypus_
coziest	18	40	1435	3	coziest
cymose	13	42	965	3	cym_ose
dampest	12	4	1104	3	dampest
decompose	16	4	454	3	decompose
doorpost	11	6	545	3	doorpost
goalpost	11	4	385	3	goalpost
gombos	11	43	1109	3	gombos_
gosport	10	10	1028	3	gosport
homeport	15	14	894	3	homeport
homiest	12	41	1663	3	homiest
hommos	13	12	850	3	hommos_
homos	10	59	2179	3	hom_os_
import	10	27	1376	3	_import
impose	10	31	1305	3	_impose
imposts	11	26	900	3	_imposts
inmost	8	4	1136	3	inm_ost
jimpest	18	29	755	3	jimpest
lamppost	14	4	352	3	lamppost
limpest	11	37	1231	3	limpest
most	6	65	5420	3	__m_ost
nomos	7	59	1974	3	nom_os_
nonpast	9	3	903	3	nonpast
oomphs	13	4	472	3	oomphs_
oppose	10	3	919	3	_oppose
outpost	9	6	1244	3	outpost
pomos	9	53	2158	3	pom_os_
pompom	14	3	649	3	pompo_m
pompoms	15	3	533	3	pompoms
pompon	12	3	894	3	pompo_n
pompons	13	3	855	3	pompons
pomposity	18	4	465	3	pomposity
pompous	13	3	806	3	pompous
pomps	11	53	1619	3	pomp_s_
post	6	79	5336	3	___post
recompose	15	4	529	3	recompose
ripost	8	36	1500	3	_ripost
romeos	8	40	1317	3	romeos_
rompish	14	3	669	3	rompish
romps	9	46	1754	3	romp_s_
roost	5	57	3093	3	ro__ost
tempest	11	3	922	3	tempest
tempos	10	38	1229	3	tempos_
topmast	11	3	812	3	topmast
topos	7	57	2639	3	to_pos_
upmost	10	6	819	3	upm_ost
utmost	8	7	848	3	utm_ost
volost	9	4	1264	3	vo_lost

Search took 8 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	134027	0.470	380193.6
2	DLD Change Limit	134027	229	6.576	20381.2
3	Display Results	229	229	0.080	2862.5
	(SQL Overall)	178691	229	7.126	25075.9