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

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

333 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
pectate	11	22	1469	(None)
pectase	11	24	1036	1	pectase
pectates	12	22	1395	1	pectates
peltate	9	20	1377	1	peltate
spectate	12	24	883	1	spectate
acetate	9	25	1475	2	acetate
dentate	8	3	1515	2	dentate
dictate	10	3	1166	2	dictate
estate	6	47	1976	2	_estate
gestate	8	36	1407	2	gestate
hectare	12	3	847	2	hectare
lactate	9	3	1270	2	lactate
metate	8	27	2053	2	me_tate
nictate	9	3	1022	2	nictate
pectases	12	24	1119	2	pectases
pectinate	13	4	955	2	pectinate
pectize	20	25	991	2	pectize
peculate	12	24	1467	2	peculate
pedate	9	31	1776	2	pe_date
pennate	9	33	1403	2	pennate
pentane	9	4	1574	2	pentane
petite	8	43	2065	2	pe_tite
picrate	11	20	1414	2	picrate
punctate	12	4	647	2	punctate
recrate	9	26	2166	2	recrate
restate	7	38	2488	2	restate
septate	9	5	1187	2	septate
speciate	12	20	958	2	speciate
spectated	14	23	659	2	spectated
spectates	13	22	881	2	spectates
tectite	9	3	1058	2	tectite
testate	7	39	1623	2	testate
acerate	9	28	1891	3	acerate
acetated	11	20	1069	3	acetated
acetates	10	20	1306	3	acetates
actuate	9	3	1144	3	_actuate
acuate	8	3	1563	3	_acuate
aerate	6	48	3055	3	ae_rate
agitate	8	3	1206	3	agitate
apostate	10	4	985	3	apostate
arcuate	9	3	1196	3	arcuate
baccate	13	10	1126	3	baccate
became	12	32	1316	3	bec_ame
bedmate	12	3	943	3	bedmate
berate	8	47	2902	3	be_rate
betake	12	45	1270	3	be_take
bistate	9	3	1382	3	bistate
cate	6	62	5460	3	__c_ate
centare	9	31	1370	3	centare
cerate	8	48	2946	3	ce_rate
cetane	8	3	1528	3	ce_tane
costate	9	40	1927	3	costate
crate	7	65	3740	3	__crate
curtate	9	3	1264	3	curtate
dealate	8	36	1784	3	dealate
debate	9	44	1919	3	de_bate
decade	10	42	1616	3	dec_ade
decane	9	38	1887	3	dec_ane
decare	9	39	1915	3	dec_are
decease	10	4	952	3	decease
deciare	10	7	1066	3	deciare
decimate	13	4	1112	3	decimate
declare	10	4	1123	3	declare
decorate	11	3	1519	3	decorate
deflate	11	36	1394	3	deflate
delate	7	38	2775	3	de_late
delectate	12	4	874	3	delectate
dentated	10	4	1170	3	dentated
derate	7	45	3123	3	de_rate
deviate	11	3	1271	3	deviate
dictated	12	3	920	3	dictated
dictates	11	3	1138	3	dictates
ecarte	8	43	1350	3	_ecarte
eclat	7	5	2360	3	_eclat_
eclats	8	3	1303	3	_eclats
ecotage	10	3	688	3	_ecotage
ectases	9	29	1167	3	_ectases
ectatic	11	3	1012	3	_ectatic
ectype	13	3	428	3	_ectype
edentate	9	4	770	3	edentate
elate	5	53	3588	3	_e_late
eluate	6	23	1543	3	_eluate
enate	5	44	2815	3	_e_nate
epilate	9	3	1428	3	epilate
equate	15	20	1246	3	_equate
ergate	7	3	1514	3	_ergate
eructate	10	4	733	3	eructate
estated	8	37	1557	3	_estated
estates	7	45	2018	3	_estates
etape	7	44	1370	3	_e_tape
execrate	17	3	965	3	execrate
fellate	10	3	1343	3	fellate
fermate	12	28	1300	3	fermate
ferrate	10	30	1404	3	ferrate
gelate	7	34	2126	3	ge_late
gemmate	12	41	838	3	gemmate
gestated	10	29	1057	3	gestated
gestates	9	32	1373	3	gestates
guttate	8	32	890	3	guttate
hastate	10	3	1391	3	hastate
hebetate	13	4	705	3	hebetate
hectares	13	3	886	3	hectares
hektare	14	3	551	3	hektare
heptane	12	3	836	3	heptane
hesitate	11	6	997	3	hesitate
imitate	9	3	1087	3	imitate
instate	7	16	1648	3	instate
lactase	9	3	796	3	lactase
lactated	11	3	887	3	lactated
lactates	10	3	1123	3	lactates
leachate	13	4	744	3	leachate
lecture	9	14	952	3	lecture
legate	7	29	1745	3	le_gate
levitate	11	3	793	3	levitate
locate	8	39	1984	3	loc_ate
mediate	10	34	1521	3	mediate
meditate	11	3	1062	3	meditate
meltage	10	3	795	3	meltage
metage	9	31	1445	3	me_tage
metates	9	27	2001	3	me_tates
mutate	8	30	1748	3	_mutate
nectar	8	3	885	3	necta_r
nectars	9	3	846	3	nectars
nectary	12	4	622	3	nectary
negate	7	29	1557	3	ne_gate
neonate	7	3	1133	3	neonate
nervate	10	3	953	3	nervate
nictated	11	3	779	3	nictated
nictates	10	3	959	3	nictates
notate	6	32	1786	3	_notate
nutate	6	30	1737	3	_nutate
octane	8	14	1163	3	_octane
octave	11	15	734	3	_octave
operate	9	6	1573	3	ope_rate
outate	6	29	2340	3	_outate
package	16	12	801	3	package
palate	8	42	2679	3	p_alate
paleate	9	41	2000	3	paleate
palmate	11	32	1523	3	palmate
palpate	11	32	1392	3	palpate
partake	13	3	964	3	partake
partite	9	3	1713	3	partite
pate	6	53	5046	3	p___ate
peace	9	50	2608	3	pe__ace
peacoat	11	4	1291	3	peacoat_
peacoats	12	4	783	3	peacoats
peage	8	47	2357	3	pe__age
pease	7	52	3111	3	pe__ase
peat	6	59	6793	3	pe__at_
peats	7	61	4019	3	pe__ats
peaty	10	57	2569	3	pe__aty
pecan	9	19	1903	3	pec_a_n
pecans	10	15	1583	3	pec_ans
peccable	16	4	812	3	peccable
peccant	13	3	1173	3	peccant
peccary	16	3	628	3	peccary
peccavi	16	4	309	3	peccavi
pechan	13	5	1154	3	pecha_n
pechans	14	8	1050	3	pechans
pecten	10	27	1110	3	pect_en
pectens	11	18	920	3	pectens
pectic	12	29	1387	3	pect_ic
pectin	10	26	1553	3	pect_in
pectines	12	19	1468	3	pectines
pectins	11	23	1523	3	pectins
pectized	22	25	759	3	pectized
pectizes	21	22	979	3	pectizes
peculated	14	23	1085	3	peculated
peculates	13	21	1254	3	peculates
peerage	10	8	980	3	peerage
pelage	9	5	1536	3	pe_lage
pelite	8	43	2300	3	pe_lite
peltast	9	3	1051	3	peltast
peltasts	10	3	570	3	peltasts
peltately	14	4	396	3	peltately
penates	9	33	2160	3	pe_nates
penetrate	11	4	923	3	penetrate
penlite	9	3	1324	3	penlite
pennae	8	43	1403	3	penna_e
penname	11	32	855	3	penname
pennated	11	29	954	3	pennated
pentacle	12	3	938	3	pentacle
pentad	9	3	1376	3	penta_d
pentads	10	3	952	3	pentads
pentanes	10	3	1608	3	pentanes
pentene	9	3	1379	3	pentene
pentode	10	3	989	3	pentode
pentose	9	3	1159	3	pentose
peonage	10	4	872	3	peonage
peptalk	15	5	482	3	peptalk
peptide	12	29	1069	3	peptide
peptize	20	27	948	3	peptize
peptone	11	3	1076	3	peptone
percale	11	3	1409	3	percale
percolate	13	4	1116	3	percolate
perlite	9	3	1732	3	perlite
permeate	12	3	1161	3	permeate
permute	11	3	879	3	permute
perorate	10	4	1792	3	perorate
pertain	9	27	1496	3	pertain
pervade	13	3	702	3	pervade
pesade	9	3	1110	3	pe_sade
pestle	8	32	1584	3	pest_le
petabyte	15	4	278	3	pe_tabyte
petal	7	65	2689	3	pe_ta_l
petaled	10	36	1415	3	pe_taled
petals	8	47	1981	3	pe_tals
petard	9	50	1380	3	pe_tard
petit	7	43	3265	3	pe_tit_
petites	9	38	2020	3	pe_tites
petrale	9	3	1262	3	petrale
pettable	12	17	1071	3	pettable
petted	9	41	2152	3	pe_t_ted
petter	8	39	2477	3	pe_t_ter
petti	7	51	1945	3	pe_t_ti
pettle	8	41	1605	3	pe_ttle
petto	7	60	2104	3	pe_t_to
petty	10	53	2029	3	pe_t_ty
peyote	11	3	985	3	pe_yote
phenate	12	4	1220	3	phenate
phonate	12	4	1181	3	phonate
phorate	12	4	1336	3	phorate
phytane	15	4	544	3	phytane
picante	11	3	1052	3	picante
piccata	13	4	570	3	piccata
pickaxe	22	4	462	3	pickaxe
picrated	13	21	1011	3	picrated
picrates	12	20	1321	3	picrates
picrite	11	19	1131	3	picrite
picture	11	5	861	3	picture
pileate	9	38	1592	3	pileate
pinnate	9	36	1374	3	pinnate
pirate	8	23	2288	3	p_irate
placate	11	3	1243	3	placate
planate	9	3	1457	3	planate
platane	9	31	1230	3	platane
plate	7	46	3511	3	p__late
plicate	11	3	1451	3	plicate
plumate	11	4	980	3	plumate
portage	10	30	1364	3	portage
postage	10	32	1485	3	postage
postdate	11	3	965	3	postdate
potage	9	27	1590	3	p_otage
potato	8	5	1343	3	p_otato
potentate	11	9	725	3	potentate
pottage	10	33	1060	3	pottage
prate	7	51	3598	3	p__rate
predate	10	6	1689	3	predate
prelate	9	5	1969	3	prelate
pretape	11	35	1162	3	pretape
pretaste	10	13	952	3	pretaste
primate	11	15	1628	3	primate
private	12	15	1326	3	private
probate	11	4	1448	3	probate
prolate	9	4	1979	3	prolate
pronate	9	4	1887	3	pronate
prorate	9	4	1873	3	prorate
prostate	10	3	1453	3	prostate
pulsate	9	5	1023	3	pulsate
punctated	14	4	505	3	punctated
punctuate	13	4	374	3	punctuate
pupate	10	42	1312	3	p_upate
rebate	8	44	2411	3	re_bate
recane	8	30	2287	3	rec_ane
recite	8	36	2511	3	rec_ite
reclame	11	4	1106	3	reclame
recoat	8	40	2427	3	recoat_
recoated	11	34	1679	3	recoated
recoats	9	26	1664	3	recoats
recrated	11	29	1861	3	recrated
recrates	10	24	2037	3	recrates
recreate	10	3	1360	3	recreate
recta	7	42	2026	3	recta__
rectal	8	44	1814	3	recta_l
rectorate	11	4	1137	3	rectorate
redate	7	41	2468	3	re_date
redictate	12	4	906	3	redictate
reflate	10	35	1626	3	reflate
regrate	8	26	1866	3	regrate
relate	6	40	3363	3	re_late
reluctate	11	4	692	3	reluctate
remate	8	44	2868	3	re_mate
replate	9	34	2005	3	replate
reslate	7	35	2059	3	reslate
restage	8	33	1619	3	restage
restated	9	31	2018	3	restated
restates	8	34	2343	3	restates
retake	10	47	1853	3	re_take
retape	8	39	1768	3	re_tape
retaste	7	23	1313	3	re_taste
rotate	6	33	2034	3	_rotate
saccate	11	13	1176	3	saccate
scutate	9	3	1032	3	scutate
seatmate	10	4	857	3	seatmate
secrete	9	3	1107	3	secrete
sectary	12	3	827	3	sectary
sectile	9	3	1197	3	sectile
sedate	7	30	1981	3	se_date
senate	6	37	2517	3	se_nate
sensate	7	3	1189	3	sensate
septage	10	7	840	3	septage
seriate	7	37	2247	3	seriate
serrate	7	30	1754	3	serrate
setae	5	60	2622	3	se_ta_e
smectite	12	4	577	3	smectite
speciated	14	20	754	3	speciated
speciates	13	22	923	3	speciates
spectacle	15	4	408	3	spectacle
spectator	13	4	483	3	spectator
spectre	11	29	777	3	spect_re
speculate	13	23	919	3	speculate
spicate	11	32	1419	3	spic_ate
state	5	62	3733	3	__state
tate	4	47	4860	3	___tate
tecta	7	42	1552	3	tecta__
tectal	8	37	1325	3	tecta_l
tectites	10	3	999	3	tectites
tektite	11	3	688	3	tektite
tentage	8	10	1064	3	tentage
ternate	7	4	1548	3	ternate
testae	6	42	1625	3	testa_e
testates	8	36	1545	3	testates
thecate	12	32	1002	3	thec_ate
toccate	11	3	877	3	toccate
tractate	10	4	1100	3	tractate
uncrate	9	4	1595	3	uncrate
unstate	7	19	1621	3	unstate
upstate	9	16	1049	3	upstate
vacate	11	3	1455	3	vac_ate
vegetate	12	4	667	3	vegetate
velate	9	37	2014	3	ve_late
ventage	11	10	962	3	ventage
vittate	10	40	973	3	vittate

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.420	425454.8
2	DLD Change Limit	134027	333	7.110	18850.5
3	Display Results	333	333	0.126	2642.9
	(SQL Overall)	178691	333	7.656	23340.0