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

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

257 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
compare	13	58	1499	(None)
compadre	15	29	588	1	compadre
compared	15	38	1182	1	compared
comparer	14	36	1136	1	comparer
compares	14	38	1643	1	compares
compart	13	40	1600	1	compart
compere	13	46	1662	1	compere
comade	11	44	1532	2	com_ade
comae	9	71	2842	2	com_a_e
comake	14	44	1342	2	com_ake
comate	10	41	2484	2	com_ate
compact	15	37	1221	2	compact
compadres	16	26	641	2	compadres
company	16	197	1114	2	company
comparers	15	31	939	2	comparers
comparted	16	33	842	2	comparted
comparts	14	42	1083	2	comparts
compas	12	58	1706	2	compa_s
compass	13	37	956	2	compass
compeer	13	38	1155	2	compeer
compered	15	34	1492	2	compered
comperes	14	32	1797	2	comperes
compete	13	47	1655	2	compete
compile	13	3	1244	2	compile
compone	13	65	1719	2	compone
comport	13	36	1684	2	comport
compose	13	57	1666	2	compose
compote	13	56	1646	2	compote
compute	13	45	1366	2	compute
comrade	12	13	921	2	comrade
ampere	10	5	1441	3	_ampere
bombard	14	3	733	3	bombard
camerae	11	3	1206	3	camerae
campagne	15	4	441	3	campagne
camper	12	47	2221	3	camper_
campers	13	42	2029	3	campers
campfire	17	4	402	3	campfire
camphire	17	4	589	3	camphire
campier	13	33	1327	3	campier
camporee	14	4	934	3	camporee
care	6	69	6837	3	c___are
carfare	12	3	1007	3	carfare
carpale	11	34	1435	3	carpale
caviare	12	3	837	3	caviare
centare	9	31	1370	3	centare
chare	10	52	3198	3	c__hare
chomper	16	38	1007	3	chomper_
chompers	17	36	959	3	chompers
clodpate	13	4	408	3	clodpate
coarse	8	48	1390	3	co__arse
cockade	16	3	813	3	cockade
coenure	9	6	815	3	coenure
cognate	10	3	1220	3	cognate
cohere	11	27	1699	3	co_here
coinage	10	3	1055	3	coinage
collage	10	28	1376	3	collage
collar	8	38	1617	3	collar_
collard	10	37	1292	3	collard
collared	11	32	1114	3	collared
collaret	10	31	1670	3	collaret
collars	9	38	1657	3	collars
collate	9	29	1968	3	collate
colure	8	3	1416	3	co_lure
coma	8	71	3485	3	com_a__
comaker	15	34	1060	3	com_aker
comakes	15	44	1364	3	com_akes
comal	9	51	2513	3	com_a_l
comanage	13	4	634	3	comanage
comas	9	58	3300	3	com_a_s
comates	11	41	2364	3	com_ates
combat	12	3	1675	3	comba_t
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
comber	12	51	1850	3	comber_
combers	13	45	1662	3	combers
combine	13	30	1472	3	combine
come	8	75	4770	3	com___e
comer	9	58	3269	3	com_er_
comers	10	53	2808	3	com_ers
cometary	15	4	769	3	cometary
comfier	14	3	916	3	comfier
comfort	14	36	1169	3	comfort
comfrey	17	3	468	3	com_frey
comma	11	45	1479	3	comma__
command	14	39	921	3	command
commas	12	48	1457	3	comma_s
commata	13	3	848	3	commata
commerce	16	11	632	3	commerce
commie	12	42	1552	3	com_mie
commode	14	3	812	3	commode
commove	16	3	596	3	commove
commune	13	32	936	3	commune
commute	13	43	1044	3	commute
comose	10	50	1684	3	com_ose
comp	10	67	3125	3	comp___
compacted	18	29	736	3	compacted
compacter	17	25	788	3	compacter
compacts	16	36	890	3	compacts
companied	16	4	802	3	companied
companies	15	3	1180	3	companies
comparable	18	4	560	3	compar~~abl~~e
comparing	16	24	1058	3	comparing
compassed	16	4	554	3	compassed
compasses	15	4	739	3	compasses
comped	13	59	1987	3	comp_ed
compeered	16	4	630	3	compeered
compeers	14	34	1001	3	compeers
compel	12	44	1289	3	comp_el
compels	13	32	1088	3	compels
compend	14	40	1030	3	compend
competed	15	41	1359	3	competed
competes	14	41	1724	3	competes
compiled	15	3	781	3	compiled
compiler	14	3	837	3	compiler
compiles	14	3	1198	3	compiles
comping	14	35	1859	3	comping
complain	14	4	876	3	complain
complete	14	34	1205	3	complete
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
complot	13	3	1068	3	complot
comply	15	28	1038	3	comp_ly
compo	11	53	1857	3	comp__o
compony	16	130	1191	3	compony
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
compost	13	45	1535	3	compost
composure	15	4	512	3	composure
compotes	14	47	1651	3	compotes
compradore	17	5	274	3	compradore
compress	14	3	905	3	comp_ress
comprise	14	3	1081	3	comprise
comprize	23	6	873	3	comprize
comps	11	55	2605	3	comp__s
compt	11	63	2822	3	comp__t
compted	14	38	1352	3	compted
compts	12	52	1665	3	comp_ts
computed	15	41	1095	3	computed
computer	14	45	1151	3	computer
computes	14	39	1455	3	computes
comrades	13	14	977	3	comrades
comte	9	61	2547	3	com__te
concave	14	3	937	3	concave
conepate	12	7	1253	3	conepate
conjure	16	10	907	3	conjure
connate	9	3	1575	3	connate
conspire	12	5	787	3	conspire
cookware	17	4	472	3	cookware
cooper	10	42	2112	3	cooper_
coopered	13	33	1093	3	coopered
coopers	11	40	1948	3	coopers
coopery	14	39	1027	3	coopery
copal	9	56	2178	3	co_pa_l
copalm	12	50	1081	3	co_palm
copals	10	50	1894	3	co_pals
coparent	12	4	1225	3	co_parent
copay	12	65	1631	3	co_pa_y
copays	13	49	1127	3	co_pays
cope	8	68	4738	3	co_p__e
coper	9	53	3609	3	co_per_
copers	10	46	2984	3	co_pers
copier	10	37	2289	3	co_pier
copper	12	43	2189	3	copper_
coppered	15	34	1054	3	coppered
coppers	13	35	1975	3	coppers
coppery	16	40	939	3	coppery
coppice	15	3	748	3	coppice
coppra	12	30	683	3	co_ppra
coppras	13	32	783	3	coppras
copra	9	81	1546	3	co_p_ra
coprah	13	37	1060	3	co_prah
copras	10	35	1715	3	co_pras
copse	9	56	2392	3	co_p_se
copter	10	98	2201	3	co_pter
cordage	11	3	1006	3	cordage
cordate	10	3	1522	3	cordate
core	6	72	6311	3	co___re
corkage	14	3	837	3	corkage
corpora	11	3	935	3	corpora
corpse	10	40	1340	3	corp_se
corrade	10	11	1104	3	corrade
corsage	10	3	980	3	corsage
costae	8	53	1968	3	costa_e
costar	8	55	1861	3	costar_
costard	10	41	1335	3	costard
costars	9	42	1801	3	costars
costate	9	40	1927	3	costate
cottae	8	46	1570	3	cotta_e
cottage	10	42	1057	3	cottage
cottar	8	46	1381	3	cottar_
cottars	9	44	1224	3	cottars
cougar	9	5	878	3	cougar_
cougars	10	3	844	3	cougars
coupe	9	60	2348	3	coup__e
couple	10	44	1596	3	coup_le
coupler	11	47	1301	3	coupler
courage	10	3	1099	3	courage
couture	9	3	1062	3	couture
couvade	13	3	506	3	couvade
covary	14	3	874	3	co_vary
cowage	12	3	1067	3	co_wage
coward	12	4	1167	3	co_ward
cowbane	14	3	767	3	cowbane
cowhage	16	3	630	3	cowhage
cowpat	13	3	1203	3	cowpa_t
cowpats	14	3	771	3	cowpats
cowpie	13	35	1151	3	cowp_ie
cowpoke	18	3	510	3	cowpoke
coxae	14	61	1518	3	co_xa_e
culpae	10	38	926	3	culpa_e
curare	8	49	1695	3	c_urare
cuspate	11	3	823	3	cuspate
cymae	12	67	1301	3	cym_a_e
cymar	12	57	1126	3	cym_ar_
cymars	13	59	915	3	cym_ars
empale	10	26	1126	3	_empale
empire	10	3	932	3	_empire
forbare	12	23	1051	3	forbare
homage	12	12	1060	3	hom_age
hombre	13	30	930	3	hom_bre
homepage	16	4	493	3	homepage
impale	10	28	1166	3	_impale
impark	14	28	707	3	_impark
impart	10	27	1514	3	_impart
impure	10	3	838	3	_impure
mare	6	47	5933	3	__m_are
nonpar	8	16	899	3	nonpar_
ombre	9	41	1180	3	_om_bre
oompah	13	3	425	3	oompa_h
oompahed	16	4	290	3	oompahed
oompahs	14	3	426	3	oompahs
oospore	9	3	901	3	oospore
pare	6	67	6084	3	___pare
pomace	12	31	1191	3	pom_ace
pomade	11	36	1133	3	pom_ade
pompano	13	4	520	3	pompano
prepare	11	19	1362	3	prepare
rampage	12	3	745	3	rampage
rampart	11	3	1199	3	rampart
romper	10	42	1368	3	romper_
rompers	11	34	1224	3	rompers
sempre	10	27	1009	3	semp_re
sombre	10	72	947	3	som_bre
spare	7	51	3556	3	__spare
umpire	10	4	789	3	_umpire
vampire	14	29	667	3	vampire

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.483	369960.7
2	DLD Change Limit	134027	257	6.110	21935.7
3	Display Results	257	257	0.096	2677.1
	(SQL Overall)	178691	257	6.689	26714.2