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

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

246 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
compote	13	56	1646	(None)
compete	13	47	1655	1	compete
compone	13	65	1719	1	compone
compose	13	57	1666	1	compose
compotes	14	47	1651	1	compotes
compute	13	45	1366	1	compute
capote	10	3	1573	2	c_apote
comate	10	41	2484	2	com_ate
commode	14	3	812	2	commode
commove	16	3	596	2	commove
commute	13	43	1044	2	commute
comose	10	50	1684	2	com_ose
compare	13	58	1499	2	compare
compere	13	46	1662	2	compere
competed	15	41	1359	2	competed
competes	14	41	1724	2	competes
compile	13	3	1244	2	compile
complete	14	34	1205	2	complete
complot	13	3	1068	2	complot_
complots	14	3	816	2	complots
compo	11	53	1857	2	compo__
compony	16	130	1191	2	compony
comport	13	36	1684	2	comport
comported	16	31	953	2	comported
comports	14	34	1198	2	comports
compos	12	48	1880	2	compo_s
composed	15	46	1206	2	composed
composer	14	50	1295	2	composer
composes	14	50	1711	2	composes
composite	15	4	1015	2	composite
compost	13	45	1535	2	compost
composted	16	37	881	2	composted
composter	15	36	956	2	composter
composts	14	42	1091	2	composts
compt	11	63	2822	2	comp_t_
compted	14	38	1352	2	comp_ted
compts	12	52	1665	2	comp_ts
computed	15	41	1095	2	computed
computer	14	45	1151	2	computer
computes	14	39	1455	2	computes
comte	9	61	2547	2	com__te
connote	9	3	1161	2	connote
cowpoke	18	3	510	2	cowpoke
cowrote	12	28	967	2	cowrote
coyote	11	4	1178	2	co_yote
bowpot	13	4	1007	3	bowpot_
bowpots	14	4	602	3	bowpots
campo	11	52	1976	3	campo__
campong	14	31	812	3	campong
camporee	14	4	934	3	camporee
campos	12	52	1795	3	campo_s
campout	13	4	1285	3	campout
campouts	14	3	682	3	campouts
campsite	14	4	741	3	campsite
capotes	11	3	1464	3	c_apotes
cenote	8	37	1584	3	c_enote
chayote	15	3	649	3	chayote
chipotle	15	4	365	3	chipotle
clodpate	13	4	408	3	clodpate
clodpole	13	4	360	3	clodpole
coapt	9	61	3153	3	coap_t_
coapted	12	39	1150	3	coap_ted
coapts	10	46	1401	3	coap_ts
cocotte	11	3	860	3	cocotte
codrove	13	3	642	3	codrove
coelome	11	3	968	3	coelome
coempt	12	3	1103	3	coemp_t_
coempted	15	3	533	3	coemp_ted
coempts	13	3	568	3	coemp_ts
coesite	9	7	1362	3	coesite
cognate	10	3	1220	3	cognate
collate	9	29	1968	3	collate
colone	8	54	2500	3	co_lone
comade	11	44	1532	3	com_ade
comae	9	71	2842	3	com__ae
comake	14	44	1342	3	com_ake
comates	11	41	2364	3	com_ates
comatose	12	4	782	3	comatose
combat	12	3	1675	3	combat_
combated	15	3	982	3	combated
combater	14	3	938	3	combater
combats	13	3	1168	3	combats
combe	11	62	2354	3	com__be
combine	13	30	1472	3	combine
combo	11	45	1943	3	combo__
combos	12	53	1661	3	combo_s
come	8	75	4770	3	com___e
comet	9	59	4607	3	com_et_
cometh	13	48	1168	3	com_eth
comets	10	58	2358	3	com_ets
comfit	13	31	1242	3	comfit_
comfits	14	32	874	3	comfits
comfort	14	36	1169	3	comfort
comforted	17	31	596	3	comforted
comforter	16	25	598	3	comforter
comforts	15	34	732	3	comforts
comity	13	3	1271	3	com_ity
commata	13	3	848	3	commata
commie	12	42	1552	3	com_mie
commit	12	40	1670	3	commit_
commits	13	38	1238	3	commits
commodes	15	3	909	3	commodes
common	12	3	1080	3	commo_n
commoner	14	27	1063	3	commoner
commons	13	3	1104	3	commons
commoved	18	4	476	3	commoved
commoves	17	3	696	3	commoves
commune	13	32	936	3	commune
commuted	15	28	898	3	commuted
commuter	14	30	1015	3	commuter
commutes	14	30	1189	3	commutes
comous	10	8	1650	3	com_ous
comp	10	67	3125	3	comp___
compact	15	37	1221	3	compact
compacted	18	29	736	3	compacted
compacter	17	25	788	3	compacter
compacts	16	36	890	3	compacts
compadre	15	29	588	3	compadre
company	16	197	1114	3	company
compared	15	38	1182	3	compared
comparer	14	36	1136	3	comparer
compares	14	38	1643	3	compares
compart	13	40	1600	3	compart
comparted	16	33	842	3	comparted
comparts	14	42	1083	3	comparts
compas	12	58	1706	3	comp_as
compass	13	37	956	3	compass
comped	13	59	1987	3	comp_ed
compeer	13	38	1155	3	compeer
compel	12	44	1289	3	comp_el
compels	13	32	1088	3	compels
compend	14	40	1030	3	compend
compered	15	34	1492	3	compered
comperes	14	32	1797	3	comperes
competent	15	4	1125	3	competent
compiled	15	3	781	3	compiled
compiler	14	3	837	3	compiler
compiles	14	3	1198	3	compiles
comping	14	35	1859	3	comping
completed	16	28	1027	3	completed
completer	15	33	1041	3	completer
completes	15	32	1292	3	completes
complex	20	3	724	3	complex
complice	16	3	933	3	complice
complied	15	3	967	3	complied
complier	14	3	1025	3	complier
complies	14	3	1452	3	complies
complin	13	3	1207	3	complin
compline	14	3	1355	3	compline
complotted	17	4	373	3	complotted
comply	15	28	1038	3	comp_ly
component	15	4	1108	3	component
composers	15	39	1062	3	composers
composited	17	5	600	3	composited
composites	16	4	890	3	composites
composters	16	38	832	3	composters
composure	15	4	512	3	composure
compound	15	5	599	3	compound
comprise	14	3	1081	3	comprise
comprize	23	6	873	3	comprize
comps	11	55	2605	3	comp__s
computers	15	33	975	3	computers
comrade	12	13	921	3	comrade
comtes	10	62	2281	3	com__tes
condole	10	29	1495	3	condole
condone	10	26	1629	3	condone
conepate	12	7	1253	3	conepate
confute	12	3	926	3	confute
connate	9	3	1575	3	connate
connoted	11	3	886	3	connoted
connotes	10	3	1145	3	connotes
console	9	27	1598	3	console
conte	7	66	3320	3	co__nte
convoke	16	20	717	3	convoke
cooee	7	45	3102	3	co__oee
coopt	9	59	2985	3	coop_t_
coopted	12	37	1076	3	coop_ted
coopts	10	58	1458	3	coop_ts
coot	6	78	6038	3	co__ot_
cooter	8	51	2861	3	co__oter
cootie	8	42	2309	3	co__otie
coots	7	56	3684	3	co__ots
cope	8	68	4738	3	co_p__e
coplot	10	5	1827	3	coplot_
coplots	11	5	1159	3	coplots
copout	10	4	1878	3	co_pout
copouts	11	3	1108	3	co_pouts
coppice	15	3	748	3	coppice
copse	9	56	2392	3	co_p_se
copter	10	98	2201	3	co_p_ter
cordate	10	3	1522	3	cordate
cordite	10	3	1526	3	cordite
cornpone	12	4	693	3	cornpone
cornute	9	3	964	3	cornute
corpora	11	3	935	3	corpora
corporate	13	4	1090	3	corporate
corpse	10	40	1340	3	corp_se
corrode	10	13	1057	3	corrode
costate	9	40	1927	3	costate
cote	6	66	4873	3	c___ote
coupe	9	60	2348	3	coup__e
couple	10	44	1596	3	coup_le
couplet	11	47	1794	3	couplet
coupon	10	28	1099	3	coupo_n
coupons	11	27	1056	3	coupons
cowpat	13	3	1203	3	cowpat_
cowpats	14	3	771	3	cowpats
cowpie	13	35	1151	3	cowp_ie
cowpokes	19	4	457	3	cowpokes
cowpox	20	3	500	3	cowpo_x
cowpoxes	22	4	451	3	cowpoxes
cowrite	12	36	1268	3	cowrite
coyotes	12	4	1070	3	co_yotes
coypou	13	26	840	3	coypo_u
coypous	14	24	881	3	coypous
cuspate	11	3	823	3	cuspate
cymose	13	42	965	3	cym_ose
decompose	16	4	454	3	decompose
demote	9	48	1780	3	dem_ote
emote	7	54	2119	3	_em_ote
fomite	11	33	1407	3	fom_ite
gemote	9	46	1302	3	gem_ote
hoopoe	11	9	1123	3	hoopo_e
impone	10	30	1186	3	_impone
impose	10	31	1305	3	_impose
impute	10	3	804	3	_impute
locomote	12	4	588	3	locom_ote
mopoke	14	3	663	3	mo_poke
mote	6	70	4808	3	__m_ote
oospore	9	3	901	3	oospore
oppose	10	3	919	3	_oppose
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
pompous	13	3	806	3	pompous
promote	11	3	1314	3	prom_ote
rampole	11	3	969	3	rampole
recompose	15	4	529	3	recompose
recompute	15	4	471	3	recompute
remote	8	42	2260	3	rem_ote
sapote	8	3	1436	3	_sapote
smote	7	58	2028	3	_sm_ote
someone	9	3	881	3	someone
somite	8	45	1937	3	som_ite
sopite	8	49	1771	3	so_pite

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.390	458182.1
2	DLD Change Limit	134027	246	7.156	18729.3
3	Display Results	246	246	0.093	2645.2
	(SQL Overall)	178691	246	7.639	23391.9