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

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

265 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
declare	10	4	1122	(None)
decare	9	39	1915	1	dec_are
deciare	10	7	1066	1	deciare
declared	12	4	874	1	declared
declarer	11	4	806	1	declarer
declares	11	6	1131	1	declares
dealate	8	36	1784	2	dealate
decade	10	42	1616	2	dec_ade
decane	9	38	1887	2	dec_ane
decares	10	28	1853	2	dec_ares
decease	10	4	952	2	decease
deciares	11	5	1063	2	deciares
declaim	12	4	736	2	declaim
declarers	12	3	642	2	declarers
declass	10	3	873	2	declass
declasse	11	6	594	2	declasse
declaw	12	6	670	2	decla_w
declawed	15	4	592	2	declawed
declaws	13	3	625	2	declaws
decline	10	37	1661	2	decline
deflate	11	36	1394	2	deflate
deglaze	18	3	558	2	deglaze
dekare	11	28	1156	2	de_kare
delate	7	38	2775	2	de_late
deplane	10	3	1141	2	deplane
deplore	10	3	948	2	deplore
hectare	12	3	846	2	hectare
reclame	11	4	1106	2	reclame
aglare	7	3	1243	3	_aglare
became	12	32	1316	3	bec_ame
becharm	16	3	684	3	becharm
beclasp	13	3	526	3	beclasp
beware	11	3	1371	3	be_ware
blare	7	58	2623	3	__blare
care	6	69	6837	3	__c_are
cellae	8	49	1593	3	cella_e
cellar	8	45	1498	3	cellar_
cellared	11	39	879	3	cellared
cellarer	10	31	792	3	cellarer
cellaret	10	37	1357	3	cellaret
cellars	9	37	1369	3	cellars
centare	9	31	1370	3	centare
chare	10	52	3198	3	__chare
clade	8	58	2101	3	__clade
claret	8	40	2657	3	__claret
claro	7	50	1869	3	__claro
clary	10	57	1961	3	__clary
clave	10	54	2015	3	__clave
cyclase	14	3	661	3	cyclase
dare	5	58	4886	3	d___are
daycare	13	5	509	3	daycare
daymare	13	7	563	3	daymare
dealated	10	32	1360	3	dealated
dealates	9	27	1668	3	dealates
dealer	7	41	2214	3	dealer_
dealers	8	41	1861	3	dealers
dear	5	53	4360	3	de__ar_
dearer	7	48	2280	3	de__arer
dearie	7	33	1981	3	de__arie
dears	6	57	3688	3	de__ars
deary	9	58	2684	3	de__ary
deave	9	50	2233	3	de__ave
debar	8	55	1786	3	de_bar_
debark	13	42	1094	3	de_bark
debars	9	42	1804	3	de_bars
debase	9	40	1447	3	de_base
debate	9	44	1919	3	de_bate
debeard	11	3	735	3	debeard
decades	11	36	1551	3	dec_ades
decaf	11	49	1944	3	dec_a_f
decafs	12	40	1088	3	dec_afs
decal	8	55	2323	3	dec_a_l
decalog	11	3	600	3	decalog
decals	9	37	1771	3	dec_als
decamp	13	3	845	3	dec_amp
decanes	10	31	1891	3	dec_anes
decant	9	35	2422	3	dec_ant
decay	11	47	1848	3	dec_a_y
decayed	14	30	933	3	dec_ayed
decayer	13	33	935	3	dec_ayer
decays	12	46	1291	3	dec_ays
deceased	12	4	771	3	deceased
deceases	11	4	1015	3	deceases
deceive	13	3	781	3	deceive
decenary	14	4	627	3	decenary
decentre	11	24	855	3	decentre
decern	9	13	1095	3	dec_ern
decide	10	41	1687	3	dec_ide
decider	11	42	1318	3	decider
decile	9	46	1921	3	dec_ile
decilitre	12	4	501	3	decilitre
decimate	13	4	1112	3	decimate
decker	13	52	1599	3	decker_
deckers	14	44	1383	3	deckers
deckle	13	120	1245	3	dec_kle
declaimed	15	4	438	3	declaimed
declaimer	14	4	423	3	declaimer
declaims	13	4	582	3	declaims
declarable	15	4	497	3	declar~~abl~~e
declarant	12	4	603	3	declarant
declaring	13	3	957	3	declaring
declassed	13	4	499	3	declassed
declasses	12	4	644	3	declasses
declined	12	39	1088	3	declined
decliner	11	37	1084	3	decliner
declines	11	33	1580	3	declines
decode	10	44	1474	3	dec_ode
decoder	11	37	1229	3	decoder
decollate	12	13	774	3	decollate
decolor	10	8	703	3	decolor_
decolored	13	4	566	3	decolored
decolors	11	8	771	3	decolors
decor	8	47	1757	3	dec_or_
decorate	11	3	1519	3	decorate
decors	9	40	1777	3	dec_ors
decoyer	13	34	868	3	decoyer
decrease	11	3	656	3	decrease
decree	9	31	1778	3	dec_ree
decreer	10	26	912	3	decreer
decrier	10	27	1355	3	decrier
decry	11	55	1435	3	dec__ry
decuple	12	8	536	3	decuple
decurve	13	3	558	3	decurve
decury	12	7	796	3	dec_ury
deface	12	31	1386	3	de_face
defame	12	32	1243	3	de_fame
defilade	13	12	443	3	defilade
deflated	13	34	1230	3	deflated
deflater	12	32	1160	3	deflater
deflates	12	30	1394	3	deflates
degage	9	27	1138	3	de_gage
degame	10	27	1318	3	de_game
deglazed	20	3	495	3	deglazed
deglazes	19	3	546	3	deglazes
degrade	10	22	990	3	degrade
dekares	12	27	1087	3	de_kares
delaine	8	3	1479	3	de_laine
delated	9	37	2287	3	de_lated
delates	8	35	2628	3	de_lates
delay	9	48	2063	3	de_la_y
delayed	12	33	1076	3	de_layed
delayer	11	30	1053	3	de_layer
delays	10	40	1405	3	de_lays
dele	5	68	4308	3	de_l__e
deleave	11	4	772	3	deleave
delete	7	36	2070	3	de_lete
delime	9	3	1404	3	de_lime
delude	8	19	1067	3	de_lude
deluge	8	18	940	3	de_luge
deluxe	14	19	730	3	de_luxe
delve	9	60	1826	3	de_l_ve
delver	10	49	1349	3	de_lver
demark	13	42	1102	3	de_mark
demure	9	3	1153	3	de_mure
denar	6	52	2329	3	de_nar_
denari	7	109	1735	3	de_nari
denars	7	46	2143	3	de_nars
denary	10	53	1686	3	de_nary
dentate	8	3	1515	3	dentate
denture	8	3	1189	3	denture
deodar	8	3	771	3	deodar_
deodara	9	4	524	3	deodara
deodars	9	3	762	3	deodars
depart	9	47	2056	3	de_part
depilate	11	3	1170	3	depilate
deplaned	12	3	866	3	deplaned
deplanes	11	3	1121	3	deplanes
deplete	10	30	1042	3	deplete
deplored	12	3	723	3	deplored
deplorer	11	3	634	3	deplorer
deplores	11	3	953	3	deplores
deplume	12	5	506	3	deplume
deprave	13	3	707	3	deprave
derate	7	45	3123	3	de_rate
dere	5	68	4590	3	de___re
desire	7	4	1530	3	de_sire
desolate	9	4	1199	3	desolate
devalue	11	3	601	3	devalue
deviate	11	3	1271	3	deviate
dewar	9	58	1773	3	de_war_
dewars	10	51	1707	3	de_wars
dewclaw	16	5	179	3	dewcla_w
dewclawed	19	4	153	3	dewclawed
dewclaws	17	5	187	3	dewclaws
dewlap	12	6	484	3	dewla_p
dewlaps	13	3	466	3	dewlaps
dictate	10	3	1166	3	dictate
dilate	7	32	2069	3	d_ilate
dockage	15	3	572	3	dockage
dollar	7	41	1098	3	dollar_
dollars	8	33	1102	3	dollars
dullard	9	3	660	3	dullard
ecarte	8	43	1350	3	_ec_arte
echard	12	4	922	3	_echard
eclair	8	3	681	3	_eclair
eclairs	9	3	596	3	_eclairs
eclat	7	5	2360	3	_ecla_t
eclats	8	3	1303	3	_eclats
elate	5	53	3588	3	_e_late
enclave	12	5	753	3	enclave
enlace	8	22	1323	3	_enlace
enlarge	8	3	553	3	_enlarge
euclase	9	3	893	3	euclase
exclave	19	4	519	3	exclave
feculae	12	33	920	3	fecula_e
fellate	10	3	1343	3	fellate
flare	8	48	2363	3	__flare
gelate	7	34	2126	3	ge_late
glare	6	52	2296	3	__glare
hectares	13	3	885	3	hectares
hektare	14	3	550	3	hektare
keelage	12	3	618	3	keelage
lecture	9	14	952	3	lecture
medlar	9	30	1046	3	medlar_
medlars	10	25	944	3	medlars
necklace	16	4	364	3	necklace
nectar	8	3	885	3	nectar_
nectars	9	3	846	3	nectars
nectary	12	4	622	3	nectary
peccary	16	3	628	3	peccary
pectase	11	24	1036	3	pectase
pectate	11	22	1469	3	pectate
peculate	12	24	1467	3	peculate
pedlar	9	33	1127	3	pedlar_
pedlars	10	32	1021	3	pedlars
pedlary	13	27	754	3	pedlary
pelage	9	5	1536	3	pe_lage
recane	8	30	2287	3	rec_ane
recharge	14	7	661	3	recharge
rechart	12	3	1433	3	rechart
reclad	9	3	1187	3	recla_d
reclads	10	4	999	3	reclads
reclaim	11	3	775	3	reclaim
reclames	12	3	1089	3	reclames
reclasp	11	3	664	3	reclasp
recline	9	40	2049	3	recline
recluse	9	52	1077	3	recluse
recrate	9	26	2166	3	recrate
redware	11	3	936	3	redware
reflate	10	35	1626	3	reflate
reglaze	17	4	722	3	reglaze
relace	8	31	2215	3	re_lace
relate	6	40	3363	3	re_late
replace	11	32	1428	3	replace
replate	9	34	2005	3	replate
reslate	7	35	2059	3	reslate
scalare	9	33	1183	3	scalare
scare	7	53	3446	3	_sc_are
seaware	10	4	963	3	seaware
seclude	10	3	523	3	seclude
secpar	10	3	792	3	secpar_
secpars	11	3	841	3	secpars
sectary	12	3	827	3	sectary
secular	9	22	1153	3	secular_
seculars	10	21	939	3	seculars
secure	8	5	1353	3	sec_ure
teaware	10	4	814	3	teaware
telae	5	43	2329	3	te_la_e
undeclared	14	4	504	3	undeclared
velar	8	58	1763	3	ve_lar_
velars	9	39	1372	3	ve_lars
velate	9	37	2014	3	ve_late
velure	9	3	977	3	ve_lure
welfare	13	3	571	3	welfare
wetware	13	3	579	3	wetware

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.406	440125.6
2	DLD Change Limit	134027	265	6.110	21935.7
3	Display Results	265	265	0.093	2849.5
	(SQL Overall)	178691	265	6.609	27037.5