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

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

296 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
compete	13	47	1655	(None)
compere	13	46	1662	1	compere
competed	15	41	1359	1	competed
competes	14	41	1724	1	competes
complete	14	34	1205	1	complete
compote	13	56	1646	1	compote
compute	13	45	1366	1	compute
comate	10	41	2484	2	com_ate
comet	9	59	4607	2	com_et_
cometh	13	48	1168	2	com_eth
comets	10	58	2358	2	com_ets
commute	13	43	1044	2	commute
compare	13	58	1499	2	compare
comped	13	59	1987	2	compe_d
compeer	13	38	1155	2	compeer
compel	12	44	1289	2	compe_l
compels	13	32	1088	2	compels
compend	14	40	1030	2	compend
compered	15	34	1492	2	compered
comperes	14	32	1797	2	comperes
competent	15	4	1125	2	competent
compile	13	3	1244	2	compile
completed	16	28	1027	2	completed
completer	15	33	1041	2	completer
completes	15	32	1292	2	completes
compone	13	65	1719	2	compone
compose	13	57	1666	2	compose
compotes	14	47	1651	2	compotes
compt	11	63	2822	2	comp_t_
compted	14	38	1352	2	compted
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
ampere	10	5	1441	3	_ampere
bolete	8	5	1961	3	bo_lete
camlet	10	44	2658	3	camlet_
camlets	11	43	1462	3	camlets
camped	13	47	2023	3	campe_d
camper	12	47	2221	3	campe_r
campers	13	42	2029	3	campers
camphene	17	4	661	3	camphene
campsite	14	4	741	3	campsite
capote	10	3	1573	3	c_apote
carpet	10	45	3009	3	carpet_
carpeted	13	3	895	3	carpeted
carpets	11	39	1533	3	carpets
cete	6	49	3478	3	c___ete
chomped	17	32	977	3	chompe_d
chomper	16	38	1007	3	chompe_r
chompers	17	36	959	3	chompers
clodpate	13	4	408	3	clodpate
clomped	14	39	897	3	clompe_d
clypeate	15	4	387	3	clypeate
coapt	9	61	3153	3	coap_t_
coapted	12	39	1150	3	coapted
coapts	10	46	1401	3	coap_ts
coatee	8	43	2722	3	coate_e
cockeye	18	6	722	3	cockeye
cocotte	11	3	860	3	cocotte
cocreate	12	26	1181	3	cocreate
codpiece	15	4	406	3	codpiece
coempt	12	3	1103	3	coemp_t_
coempted	15	3	533	3	coempted
coempts	13	3	568	3	coemp_ts
coesite	9	7	1362	3	coesite
coffee	14	41	1374	3	coffe_e
cognate	10	3	1220	3	cognate
cohere	11	27	1699	3	co_here
collate	9	29	1968	3	collate
college	10	24	1044	3	college
collet	8	40	3036	3	collet_
colleted	11	30	1166	3	colleted
collets	9	35	1790	3	collets
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	comates
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
combed	13	55	1654	3	combe_d
comber	12	51	1850	3	combe_r
combers	13	45	1662	3	combers
combes	12	53	2173	3	combe_s
combine	13	30	1472	3	combine
come	8	75	4770	3	com___e
comedo	11	35	960	3	com_edo
comedy	14	37	823	3	com_edy
comely	13	42	1373	3	com_ely
comer	9	58	3269	3	com_e_r
comers	10	53	2808	3	com_ers
comes	9	72	4699	3	com_e_s
comether	15	3	725	3	com_ether
cometic	13	12	1572	3	com_etic
comfit	13	31	1242	3	comfit_
comfits	14	32	874	3	comfits
comity	13	3	1271	3	com_ity
commata	13	3	848	3	commata
commence	16	14	910	3	commence
commend	14	40	1018	3	commend
comment	13	103	1770	3	comment
commented	16	12	961	3	commented
commenter	15	14	1069	3	commenter
comments	14	29	1388	3	comments
commerce	16	11	632	3	commerce
commie	12	42	1552	3	com_mie
commit	12	40	1670	3	commit_
commits	13	38	1238	3	commits
commode	14	3	812	3	commode
commove	16	3	596	3	commove
commune	13	32	936	3	commune
commuted	15	28	898	3	commuted
commuter	14	30	1015	3	commuter
commutes	14	30	1189	3	commutes
comose	10	50	1684	3	com_ose
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
compeered	16	4	630	3	compeered
compeers	14	34	1001	3	compeers
compelled	16	4	613	3	compelled
compeller	15	4	629	3	compeller
compends	15	37	825	3	compends
compensate	16	4	614	3	compe~~nsa~~te
competence	18	4	672	3	compet~~enc~~e
competency	21	5	504	3	compete~~ncy~~
competing	16	37	1246	3	competing
compiled	15	3	781	3	compiled
compiler	14	3	837	3	compiler
compiles	14	3	1198	3	compiles
comping	14	35	1859	3	comping
compleat	14	7	1015	3	compleat
complect	16	5	901	3	complect
complected	19	29	586	3	complected
complects	17	6	641	3	complects
completely	19	4	455	3	completely
completers	16	29	832	3	completers
completest	16	29	787	3	completest
completive	19	4	623	3	completive
complex	20	3	724	3	complex
complexed	23	29	598	3	complexed
complexer	22	31	621	3	complexer
complexes	22	30	810	3	complexes
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
complot	13	3	1068	3	complot
complots	14	3	816	3	complots
comply	15	28	1038	3	comp_ly
compo	11	53	1857	3	comp__o
compony	16	130	1191	3	compony
comport	13	36	1684	3	comport
comported	16	31	953	3	comported
comports	14	34	1198	3	comports
compos	12	48	1880	3	comp_os
composed	15	46	1206	3	composed
composer	14	50	1295	3	composer
composes	14	50	1711	3	composes
composite	15	4	1015	3	composite
compost	13	45	1535	3	compost
composted	16	37	881	3	composted
composter	15	36	956	3	composter
composts	14	42	1091	3	composts
compress	14	3	905	3	compress
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	comte_s
concede	12	3	1010	3	concede
concrete	12	4	1108	3	concrete
conepate	12	7	1253	3	conepate
confute	12	3	926	3	confute
congee	9	60	2447	3	conge_e
connate	9	3	1575	3	connate
connote	9	3	1161	3	connote
conte	7	66	3320	3	co__nte
convene	12	33	1432	3	convene
cooee	7	45	3102	3	co_oe_e
cooped	11	48	2160	3	coope_d
cooper	10	42	2112	3	coope_r
cooperate	13	7	1014	3	cooperate
coopered	13	33	1093	3	coopered
coopers	11	40	1948	3	coopers
coopery	14	39	1027	3	coopery
coopt	9	59	2985	3	coop_t_
coopted	12	37	1076	3	coopted
coopts	10	58	1458	3	coop_ts
cope	8	68	4738	3	co_p__e
copeck	16	3	694	3	co_peck
coped	10	50	3684	3	co_pe_d
copemate	14	3	999	3	co_pemate
copen	9	48	2643	3	co_pe_n
copens	10	61	1996	3	co_pens
coper	9	53	3609	3	co_pe_r
copers	10	46	2984	3	co_pers
copes	9	77	4710	3	co_pe_s
copped	13	52	2125	3	coppe_d
copper	12	43	2189	3	coppe_r
coppered	15	34	1054	3	coppered
coppers	13	35	1975	3	coppers
coppery	16	40	939	3	coppery
coppice	15	3	748	3	coppice
copse	9	56	2392	3	co_p_se
copter	10	98	2201	3	co_pter
coquet	17	43	1801	3	coquet_
coquets	18	39	989	3	coquets
coquette	19	7	659	3	coquette
cordate	10	3	1522	3	cordate
cordite	10	3	1526	3	cordite
cornet	8	44	3673	3	cornet_
cornets	9	48	2057	3	cornets
cornute	9	3	964	3	cornute
corpse	10	40	1340	3	corp_se
corset	8	56	3622	3	corset_
corseted	11	3	1147	3	corseted
corsets	9	48	1980	3	corsets
cortege	10	9	895	3	cortege
corvee	11	43	2009	3	corve_e
corvet	11	46	2693	3	corvet_
corvets	12	47	1502	3	corvets
corvette	13	3	809	3	corvette
coset	7	57	4884	3	co_set_
cosets	8	58	2440	3	co_sets
cosset	8	41	2586	3	cosset_
cosseted	11	7	834	3	cosseted
cossets	9	50	1428	3	cossets
costate	9	40	1927	3	costate
cote	6	66	4873	3	co___te
coulee	8	3	2351	3	coule_e
coupe	9	60	2348	3	coup__e
couped	11	50	1931	3	coupe_d
coupes	10	50	2252	3	coupe_s
couple	10	44	1596	3	coup_le
couplet	11	47	1794	3	couplet_
couplets	12	38	987	3	couplets
covet	10	56	3894	3	co_vet_
coveted	13	30	1152	3	co_veted
coveter	12	29	1206	3	co_veter
covets	11	48	1964	3	co_vets
cowpat	13	3	1203	3	cowpat_
cowpats	14	3	771	3	cowpats
cowpea	13	3	764	3	cowpe_a
cowpeas	14	3	727	3	cowpeas
cowpie	13	35	1151	3	cowp_ie
cowpoke	18	3	510	3	cowpoke
cowrite	12	36	1268	3	cowrite
cowrote	12	28	967	3	cowrote
coyote	11	4	1178	3	co_yote
crumpet	13	37	1106	3	crumpet_
crumpets	14	33	594	3	crumpets
cuspate	11	3	823	3	cuspate
cymene	13	7	739	3	cym_ene
fomite	11	33	1407	3	fom_ite
gamete	9	3	1359	3	gam_ete
impede	11	46	962	3	_impede
impute	10	3	804	3	_impute
incomplete	16	6	426	3	incomplete
limpet	10	35	1863	3	limpet_
limpets	11	32	978	3	limpets
mete	6	44	3813	3	__m_ete
moppet	12	69	1509	3	moppet_
moppets	13	30	716	3	moppets
outcompete	16	5	303	3	~~out~~compete
pommee	12	28	1328	3	pomme_e
poppet	9	27	1732	3	poppet_
poppets	10	33	885	3	poppets
recompute	15	4	471	3	recompute
romped	11	45	1365	3	rompe_d
romper	10	42	1368	3	rompe_r
rompers	11	34	1224	3	rompers
roupet	8	42	1834	3	roupet_
somite	8	45	1937	3	som_ite
sopite	8	49	1771	3	so_pite
topee	7	60	2995	3	to_pe_e
toupee	8	3	1613	3	toupe_e

Search took 7 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.410	435831.7
2	DLD Change Limit	134027	296	6.390	20974.5
3	Display Results	296	296	0.110	2690.9
	(SQL Overall)	178691	296	6.910	25859.8