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

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

331 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
pechan	13	5	1154	(None)
pecan	9	19	1903	1	pec_an
pechans	14	8	1050	1	pechans
brechan	14	3	722	2	brechan
lochan	11	3	909	2	lochan
pacha	12	65	1806	2	pacha_
pachas	13	50	1714	2	pachas
peahen	11	34	1013	2	peahen
pean	6	61	4717	2	pe__an
pecans	10	15	1583	2	pec_ans
peccant	13	3	1173	2	peccant
pech	11	61	2545	2	pech__
peched	14	49	1534	2	peched
peching	15	45	1390	2	peching
pechs	12	55	1620	2	pech_s
pecten	10	27	1110	2	pecten
pectin	10	26	1553	2	pectin
pekan	11	16	1397	2	pe_kan
penchant	15	4	958	2	penchant
penman	10	3	1232	2	penman
zechin	20	13	770	2	zechin
aecia	7	38	1928	3	aecia_
aecial	8	48	1731	3	aecial
afghan	13	3	387	3	afghan
archean	12	6	912	3	archean
archon	11	3	1175	3	archon
ashcan	11	3	584	3	ashcan
barchan	14	6	913	3	barchan
bean	6	64	4386	3	be__an
becap	11	43	1505	3	bec_ap
bechalk	18	4	580	3	bechalk
bechance	17	4	774	3	bechance
becharm	16	3	684	3	becharm
beckon	14	30	938	3	beckon
bedpan	11	3	758	3	bedpan
beechen	14	36	770	3	beechen
began	8	63	1957	3	be_gan
bemean	10	4	1068	3	bemean
bemoan	10	3	1025	3	bemoan
bethank	16	6	627	3	bethank
brecham	16	4	683	3	brecham
brechans	15	4	741	3	brechans
can	5	77	6014	3	__c_an
ceca	8	48	2078	3	cec_a_
cecal	9	46	1911	3	cec_al
chad	10	55	2550	3	__chad
chai	9	59	2990	3	__chai
chain	10	57	2367	3	__chain
cham	11	55	3231	3	__cham
chang	11	54	1856	3	__chang
chant	10	59	3269	3	__chant
chao	9	57	2731	3	__chao
chap	11	49	2849	3	__chap
char	9	51	3215	3	__char
chat	9	55	4613	3	__chat
chaw	12	62	2463	3	__chaw
chay	12	49	2487	3	__chay
chin	9	69	3474	3	__chin
chon	9	66	2779	3	__chon
clachan	14	3	718	3	clachan
clan	6	56	3392	3	__clan
cochin	13	13	1320	3	cochin
cyan	9	64	1962	3	__cyan
dacha	11	48	1257	3	dacha_
dachas	12	41	1325	3	dachas
dean	5	60	3948	3	de__an
decaf	11	49	1944	3	dec_af
decal	8	55	2323	3	dec_al
decane	9	38	1887	3	dec_ane
decant	9	35	2422	3	dec_ant
decay	11	47	1848	3	dec_ay
decern	9	13	1095	3	decern
deckhand	19	4	310	3	deckhand
declaw	12	6	670	3	declaw
decuman	12	3	657	3	decuman
deewan	10	26	755	3	deewan
demean	9	5	1056	3	demean
desman	9	3	1169	3	desman
dewan	9	57	1804	3	de_wan
echard	12	4	922	3	_echard
eche	9	75	2028	3	_ech_e
eched	11	69	1922	3	_eched
eches	10	63	2216	3	_eches
eching	12	63	1556	3	_eching
echini	11	47	1043	3	_echini
echo	9	66	1595	3	_ech_o
echos	10	52	1646	3	_echos
echt	9	57	2290	3	_ech_t
eclat	7	5	2360	3	_eclat
elan	4	67	3424	3	_e_lan
enchain	12	4	886	3	enchain
enchant	12	3	1312	3	enchant
epha	9	3	1005	3	_epha_
ephah	13	3	706	3	_ephah
ephas	10	3	1154	3	_ephas
epochal	14	4	524	3	epochal
eschar	11	3	653	3	eschar
etchant	12	4	982	3	etchant
ethane	9	46	1324	3	_ethane
fecal	10	51	1921	3	fec_al
fecial	11	47	1462	3	fecial
german	9	6	1198	3	german
heehaw	15	4	393	3	heehaw
henchman	18	4	401	3	henchman
hetman	11	25	1060	3	hetman
iceman	10	3	785	3	iceman
ipecac	12	6	462	3	ipec_ac
jean	11	66	2928	3	je__an
jehad	16	3	768	3	je_had
khan	11	58	1914	3	__khan
kuchen	15	3	665	3	kuchen
lean	4	63	4524	3	le__an
lech	9	68	2544	3	lech__
leched	12	37	1600	3	leched
lecher	11	34	1585	3	lecher
leches	11	54	2131	3	leches
leching	13	46	1365	3	leching
lechwe	14	3	511	3	lechwe
lectin	8	25	1501	3	lectin
legman	9	4	965	3	legman
leman	7	56	2260	3	le_man
lethal	9	3	980	3	lethal
lethean	10	3	709	3	lethean
lichen	11	40	1274	3	lichen
lochans	12	4	883	3	lochans
mean	6	55	3809	3	me__an
mecca	11	3	993	3	mecca_
meccas	12	3	949	3	meccas
mechanic	17	4	761	3	mechanic
median	9	41	1754	3	median
merchant	15	4	882	3	merchant
merman	10	5	1386	3	merman
mesian	8	43	1550	3	mesian
messan	8	39	1206	3	messan
methane	12	32	1179	3	methane
mocha	12	4	992	3	mocha_
mochas	13	3	1066	3	mochas
nachas	11	49	1419	3	nachas
nectar	8	3	885	3	nectar
nucha	10	22	979	3	nucha_
nuchae	11	21	851	3	nuchae
nuchal	11	21	887	3	nuchal
ocean	7	12	1296	3	_ocean
octan	7	13	1348	3	_octan
orphan	11	3	773	3	orphan
paca	8	51	3224	3	pac_a_
pacas	9	60	2940	3	pac_as
packman	17	3	669	3	packman
paean	7	72	2272	3	p_aean
paesan	8	51	1409	3	paesan
pagan	8	61	2116	3	p_agan
paisan	8	44	1707	3	paisan
pan	5	84	6645	3	p___an
panchax	21	3	498	3	panchax
paphian	14	3	745	3	paphian
parian	8	32	2396	3	parian
partan	8	38	2056	3	partan
paschal	14	15	724	3	paschal
pasha	10	54	1718	3	pasha_
pashas	11	51	1706	3	pashas
pavan	10	65	1847	3	p_avan
pea	5	66	5724	3	pe__a_
peach	12	54	2249	3	peach__
peached	15	43	1588	3	peached
peacher	14	42	1607	3	peacher
peaches	14	41	2005	3	peaches
peaching	16	36	1364	3	peaching
peachy	16	45	1084	3	peach_y
peacoat	11	4	1291	3	peacoat
peag	7	54	3134	3	pe__ag
peahens	12	30	757	3	peahens
peak	10	65	3520	3	pe__ak
peal	6	86	4810	3	pe__al
peans	7	54	3764	3	pe__ans
pear	6	97	4523	3	pe__ar
peas	6	57	5506	3	pe__as
peasant	9	3	1492	3	peasant
peasen	8	48	1596	3	peasen
peat	6	59	6793	3	pe__at
pec	7	67	4441	3	pec___
peccancy	16	4	395	3	peccancy
peccary	16	3	628	3	peccary
peccavi	16	4	309	3	peccavi
peck	12	57	3068	3	pec__k
pecked	15	50	1910	3	pecked
pecker	14	46	1536	3	pecker
pecking	16	40	1778	3	pecking
pecks	13	57	2443	3	pec_ks
pecky	16	55	1509	3	pec_ky
pecs	8	46	3410	3	pec__s
pectase	11	24	1036	3	pectase
pectate	11	22	1469	3	pectate
pectens	11	18	920	3	pectens
pectic	12	29	1387	3	pectic
pectins	11	23	1523	3	pectins
pedal	8	60	2250	3	pe_dal
pedant	9	3	1949	3	pe_dant
pedlar	9	33	1127	3	pedlar
peen	6	59	3808	3	pe__en
peh	8	67	4096	3	pe_h__
pehs	9	56	2576	3	pe_h_s
pein	6	58	3494	3	pe__in
pekans	12	17	1055	3	pe_kans
pekin	11	15	1442	3	pe_kin
pelican	11	3	943	3	pelican
pelon	7	44	2321	3	pe_lon
pemican	13	4	816	3	pemican
pen	5	65	5884	3	pe___n
penal	7	52	2837	3	pe_nal
penang	9	25	1111	3	pe_nang
penchants	16	4	620	3	penchants
pendant	10	3	1485	3	pendant
penial	8	41	2089	3	penial
penmen	10	3	1149	3	penmen
penna	7	45	2020	3	penna_
pennae	8	43	1403	3	pennae
pennant	9	3	1249	3	pennant
pennon	8	3	1064	3	pennon
pentad	9	3	1376	3	pentad
pentane	9	4	1574	3	pentane
peon	6	56	3524	3	pe__on
pepla	9	3	1286	3	pepla_
pepsin	10	3	1085	3	pepsin
perch	12	45	1883	3	perch__
perchance	18	6	639	3	perchance
perched	15	47	1324	3	perched
percher	14	33	1342	3	percher
perches	14	37	1795	3	perches
perching	16	37	1163	3	perching
perea	7	50	2644	3	perea_
pereon	8	35	1745	3	pereon
perhaps	14	4	612	3	perhaps
permian	11	26	1228	3	permian
perron	8	32	1662	3	perron
person	8	35	1787	3	person
pertain	9	27	1496	3	pertain
petal	7	65	2689	3	pe_tal
petnap	10	3	742	3	petnap
petsai	8	3	808	3	petsai
phat	9	58	3786	3	p__hat
phon	9	59	2538	3	p__hon
pian	6	61	3609	3	p__ian
pica	8	58	3149	3	pic_a_
pical	9	55	2437	3	pic_al
picas	9	46	2652	3	pic_as
pickax	21	3	591	3	pickax
pitchman	17	4	401	3	pitchman
pitman	10	24	1212	3	pitman
plan	6	58	3394	3	p__lan
platan	8	39	1369	3	platan
pochard	15	3	736	3	pochard
potman	10	28	1357	3	potman
preclean	12	4	589	3	preclean
preman	10	41	1745	3	preman
preplan	11	4	995	3	preplan
prochain	15	4	848	3	prochain
prolan	8	4	1469	3	prolan
pschent	14	3	741	3	pschent
pshaw	13	44	751	3	p_shaw
ptisan	8	41	797	3	ptisan
pucka	13	34	1280	3	pucka_
pyran	10	5	1447	3	p_yran
python	14	4	714	3	python
recane	8	30	2287	3	rec_ane
recant	8	32	2868	3	rec_ant
recap	9	57	1802	3	rec_ap
rechange	14	5	818	3	rechange
rechart	12	3	1433	3	rechart
recheat	12	4	1593	3	recheat
rechew	14	3	1021	3	rechew
reckon	12	30	1054	3	reckon
reclad	9	3	1187	3	reclad
reclean	9	3	852	3	reclean
recoal	8	41	1797	3	recoal
recoat	8	40	2427	3	recoat
recoin	8	43	2029	3	recoin
recon	7	56	2424	3	rec_on
recta	7	42	2026	3	recta_
rectal	8	44	1813	3	rectal
redan	6	61	2501	3	re_dan
rehab	10	3	1244	3	re_hab
rehang	10	3	982	3	re_hang
reloan	6	4	1569	3	reloan
reman	7	57	3015	3	re_man
replan	8	32	1582	3	replan
reran	5	73	2910	3	re_ran
rewan	8	56	2366	3	re_wan
richen	11	38	1251	3	richen
scan	6	55	3045	3	_sc_an
schav	13	3	831	3	_schav
seaman	8	40	1590	3	seaman
seawan	9	41	1122	3	seawan
secant	8	40	2329	3	sec_ant
secern	8	10	1022	3	secern
secpar	10	3	792	3	secpar
sedan	6	56	2042	3	se_dan
seitan	6	26	1323	3	seitan
sewan	8	59	2129	3	se_wan
sextan	13	38	964	3	sextan
siccan	10	3	759	3	siccan
socman	10	3	981	3	socman
spean	7	46	2051	3	spe__an
special	11	3	1030	3	special
spelean	9	3	712	3	spelean
spleuchan	16	5	174	3	spleuchan
tech	9	59	2544	3	tech__
teched	12	40	1443	3	teched
techie	11	5	1172	3	techie
techno	11	3	595	3	techno
techs	10	69	1583	3	tech_s
techy	13	56	1201	3	tech_y
tecta	7	42	1552	3	tecta_
tectal	8	37	1325	3	tectal
teopan	8	3	935	3	teopan
than	7	61	2877	3	__than
tuchun	11	4	544	3	tuchun
unchain	12	3	894	3	unchain
urchin	11	3	874	3	urchin
urethan	10	4	547	3	urethan
vegan	9	51	1415	3	ve_gan
wean	7	57	3435	3	we__an
wecht	13	4	1544	3	wech_t
wechts	14	4	625	3	wechts
wiccan	13	3	503	3	wiccan
yean	7	58	3458	3	ye__an
yech	12	72	2053	3	yech__
yechs	13	61	1258	3	yech_s
yechy	16	51	908	3	yech_y
yeoman	11	3	882	3	yeoman
zecchin	23	4	370	3	zecchin
zechins	21	13	712	3	zechins

Search took 6 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	112716	0.436	409841.7
2	DLD Change Limit	112716	331	4.813	23419.1
3	Display Results	331	331	0.110	3009.1
	(SQL Overall)	178691	331	5.359	33344.1