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

Here are the results of your fuzzy-string dictionary search for “pencil” 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
pencil	10	37	1297	(None)
pencel	10	38	1292	1	pencel
pencils	11	30	1177	1	pencils
penicil	11	3	883	1	penicil
pensil	8	30	1333	1	pensil
dentil	7	40	1788	2	dentil
gentil	7	41	1512	2	gentil
lentil	6	43	1539	2	lentil
penal	7	52	2837	2	pen_al
pence	9	49	2445	2	penc_e
pencels	11	36	1006	2	pencels
penciled	13	3	782	2	penciled
penciler	12	3	711	2	penciler
penial	8	41	2089	2	penial
penicils	12	4	786	2	penicils
penile	8	22	1960	2	pen_ile
penis	7	51	2932	2	pen_is
penni	7	46	1790	2	penni_
pennia	8	44	1297	2	pennia
pennis	8	43	1574	2	pennis
pensile	9	27	1354	2	pensile
pensils	9	28	1159	2	pensils
pentyl	11	3	881	2	pentyl
peril	7	54	2595	2	pe_ril
pontil	8	3	1546	2	pontil
renail	6	50	2076	2	renail
stencil	9	4	689	2	stencil
tenail	6	45	1611	2	tenail
aecia	7	38	1928	3	ae_cia
aecial	8	48	1731	3	ae_cial
agnail	7	3	953	3	agnail
anil	4	64	3743	3	_an_il
anvil	8	27	1260	3	_anvil
bench	12	56	1950	3	benc_h
benni	7	47	1536	3	benni_
bennis	8	43	1480	3	bennis
benzal	17	3	964	3	benzal
benzin	17	3	893	3	benzin
benzol	17	5	699	3	benzol
benzyl	20	3	416	3	benzyl
bewail	11	8	958	3	bewail
bezil	16	38	1288	3	be_zil
cancel	10	53	1668	3	cancel
cecal	9	46	1911	3	ce_cal
ceil	6	57	2506	3	ce__il
cental	8	44	2096	3	cental
centile	9	42	1718	3	centile
cercal	10	3	1412	3	cercal
cerci	9	37	1639	3	cerci_
cercis	10	46	1449	3	cercis
council	11	3	747	3	council
deasil	7	11	1098	3	deasil
decal	8	55	2323	3	de_cal
decile	9	46	1921	3	de_cile
deil	5	62	3162	3	de__il
deni	5	69	2939	3	den_i_
denial	7	47	2051	3	denial
denim	8	55	1884	3	den_im
dental	7	43	1917	3	dental
dentils	8	41	1558	3	dentils
dentin	7	39	1957	3	dentin
derail	7	42	1881	3	derail
detail	7	45	1643	3	detail
devil	9	47	1473	3	de_vil
email	7	47	1510	3	_email
encina	8	3	1044	3	_encina
encinal	9	4	925	3	_encinal
engild	8	10	761	3	_engild
enol	4	58	2382	3	_en_ol
enrol	5	10	1428	3	_enrol
ensile	6	26	1647	3	_ensile
entail	6	11	1434	3	_entail
entia	5	3	1820	3	_entia
entoil	6	9	1249	3	_entoil
epical	10	4	1339	3	epical
ervil	8	3	1030	3	_ervil
evil	7	53	1807	3	_e_vil
excel	14	3	774	3	_excel
fancily	15	3	825	3	fancily
fecal	10	51	1921	3	fe_cal
fecial	11	47	1462	3	fe_cial
fence	10	53	1991	3	fenc_e
fenced	12	44	1271	3	fenced
fencer	11	46	1353	3	fencer
fences	11	46	1711	3	fences
fencible	15	4	560	3	fencible
fencing	13	24	1113	3	fencing
fennel	9	42	947	3	fennel
genial	7	49	1761	3	genial
genic	8	51	1939	3	gen_ic
genie	6	61	2492	3	gen_ie
genii	6	45	1417	3	gen_ii
genip	8	44	1520	3	gen_ip
gentile	8	35	1529	3	gentile
gerbil	9	3	834	3	gerbil
heil	7	63	2893	3	he__il
henbit	11	14	1200	3	henbit
hence	10	49	2005	3	henc_e
jezail	22	3	464	3	jezail
kench	14	55	1392	3	kenc_h
kennel	10	36	922	3	kennel
kevil	12	39	986	3	ke_vil
lenis	5	63	2686	3	len_is
lentic	8	35	1574	3	lentic
lentils	7	39	1297	3	lentils
leucin	8	3	911	3	leucin
menhir	11	3	678	3	menhir
menial	8	42	2303	3	menial
mensal	8	46	1566	3	mensal
mental	8	45	2160	3	mental
mescal	10	41	1349	3	mescal
mezcal	19	36	785	3	mezcal
nail	4	58	3865	3	__nail
nil	3	61	4419	3	__n_il
noil	4	61	3324	3	__noil
nuncio	8	3	797	3	nuncio
pail	6	61	4183	3	p__ail
pandit	9	38	2075	3	pandit
panel	7	60	2362	3	pan_el
panful	11	7	974	3	panful
panic	9	39	2390	3	pan_ic
panicle	11	12	998	3	panicle
panics	10	38	1536	3	panics
pantie	8	43	2647	3	pantie
pantile	9	39	1848	3	pantile
parcel	10	39	1547	3	parcel
pascal	10	8	1237	3	pascal
pastil	8	50	1832	3	pastil
peace	9	50	2608	3	peac_e
peaced	11	58	1891	3	peaced
peaces	10	63	2408	3	peaces
peach	12	54	2249	3	peac_h
peachy	16	45	1084	3	peachy
peacing	12	41	1707	3	peacing
peal	6	86	4810	3	pe__al
pearl	7	53	2446	3	pe_arl
pec	7	67	4441	3	pe_c__
pecan	9	19	1903	3	pe_can
pech	11	61	2545	3	pe_c_h
pechs	12	55	1620	3	pe_chs
peck	12	57	3068	3	pe_c_k
pecks	13	57	2443	3	pe_cks
pecky	16	55	1509	3	pe_cky
pecs	8	46	3410	3	pe_c_s
pectic	12	29	1387	3	pectic
pectin	10	26	1553	3	pectin
pedal	8	60	2250	3	pe_dal
pedicel	12	3	781	3	pedicel
pedicle	12	3	897	3	pedicle
pedocal	12	3	789	3	pedocal
peel	6	55	3561	3	pe__el
peepul	10	3	578	3	peepul
peerie	8	36	1789	3	peerie
peewit	11	11	1090	3	peewit
pein	6	58	3494	3	pe__in
pekin	11	15	1442	3	pe_kin
pelvic	13	30	755	3	pelvic
pelvis	11	36	1032	3	pelvis
pen	5	65	5884	3	pen___
penally	12	11	1177	3	penally
penang	9	25	1111	3	penang
pencilers	13	4	564	3	pencil~~ers~~
penciling	14	3	741	3	pencil~~ing~~
pencilled	14	4	564	3	pencilled
penciller	13	4	495	3	penciller
pend	7	59	3453	3	pen__d
pended	10	38	1901	3	pended
pending	11	41	1977	3	pending
pends	8	55	2719	3	pen_ds
penes	7	58	3922	3	pen_es
pengo	8	43	1759	3	pen_go
pengos	9	46	1241	3	pengos
penguin	10	4	587	3	penguin
penlite	9	3	1324	3	penlite
penman	10	3	1232	3	penman
penmen	10	3	1149	3	penmen
penna	7	45	2020	3	pen_na
pennae	8	43	1403	3	pennae
penne	7	54	2385	3	pen_ne
penned	9	42	1761	3	penned
penner	8	46	1666	3	penner
pennies	9	42	1881	3	pennies
pennine	9	37	1295	3	pennine
penning	10	36	1649	3	penning
pennon	8	3	1064	3	pennon
penny	10	51	1945	3	pen_ny
penoche	14	4	704	3	penoche
penoncel	12	4	485	3	penoncel
pens	6	56	4964	3	pen__s
pensee	8	4	1731	3	pensee
pension	9	4	1220	3	pension
pensive	12	26	1039	3	pensive
pent	6	65	5907	3	pen__t
pentad	9	3	1376	3	pentad
pentyls	12	3	652	3	pentyls
penuche	14	3	594	3	penuche
penuchi	14	4	403	3	penuchi
penuchis	15	4	428	3	penuchis
penuchle	15	4	376	3	penuchle
penuckle	16	4	326	3	penuckle
penult	8	3	1465	3	penult
penury	11	4	810	3	penury
peppily	13	3	513	3	peppily
pepsin	10	3	1085	3	pepsin
peptic	12	21	1315	3	peptic
peptid	11	27	1237	3	peptid
peracid	12	3	1299	3	peracid
percale	11	3	1409	3	percale
perch	12	45	1883	3	perc_h
percoid	12	3	1232	3	percoid
perdie	9	47	1851	3	perdie
pereia	8	52	1798	3	pereia
peri	6	56	3697	3	pe_ri_
perils	8	41	2185	3	pe_rils
peris	7	55	3707	3	pe_ris
perkily	16	3	781	3	perkily
permit	10	3	2168	3	permit
pernio	8	5	1314	3	pernio
peskily	16	3	508	3	peskily
petal	7	65	2689	3	pe_tal
petit	7	43	3265	3	pe_tit
petrel	8	31	1153	3	petrel
petrol	8	27	1406	3	petrol
petti	7	51	1945	3	petti_
pettily	12	3	817	3	pettily
pewit	10	46	2279	3	pe_wit
peyotl	11	4	623	3	peyotl
pfennig	13	6	228	3	pfennig
phenix	18	3	713	3	phen_ix
phenol	11	4	925	3	phen_ol
phenyl	14	3	532	3	phen_yl
pical	9	55	2437	3	p_ical
picnic	12	34	1026	3	picnic
picul	9	50	1536	3	p_icul
pincer	10	40	1917	3	pincer
pinch	12	56	1930	3	pinc_h
pineal	8	48	1769	3	pineal
pinkie	12	44	1427	3	pinkie
pinnal	8	48	1428	3	pinnal
pintail	9	3	1118	3	pintail
pinyin	11	27	1061	3	pinyin
pistil	8	39	1507	3	pistil
placid	11	40	1254	3	placid
plench	13	40	1081	3	plenc_h
plical	10	4	1168	3	plical
ponce	9	52	2251	3	ponc_e
ponced	11	43	1481	3	ponced
ponces	10	47	2084	3	ponces
poncho	13	33	1012	3	poncho
poncing	12	29	1358	3	poncing
pongid	10	41	1158	3	pongid
pontils	9	3	1221	3	pontils
preboil	11	4	895	3	preboil
precis	10	34	1670	3	precis
prevail	12	3	824	3	prevail
pricily	14	27	1028	3	pricily
psocid	11	3	725	3	psocid
punch	12	51	1842	3	punc_h
punchily	18	4	486	3	punchily
punchy	16	39	852	3	punchy
pundit	9	29	1418	3	pundit
punily	11	3	1177	3	pun_ily
punji	14	3	820	3	punji_
punjis	15	3	669	3	punjis
punkie	12	35	1361	3	punkie
punkin	12	36	1152	3	punkin
pupil	9	47	1298	3	p_upil
rancid	9	5	1386	3	rancid
reboil	8	38	1468	3	reboil
recit	7	52	3510	3	re_cit
recoil	8	40	1672	3	recoil
remail	8	50	1712	3	remail
renails	7	49	1726	3	renails
renal	5	59	2951	3	ren_al
renig	6	45	1891	3	ren_ig
renin	5	48	3003	3	ren_in
rennin	6	39	1403	3	rennin
rental	6	39	2203	3	rental
reoil	5	53	2118	3	re_oil
resail	6	44	1873	3	resail
retail	6	55	2207	3	retail
sendal	7	33	1499	3	sendal
senecio	9	4	720	3	senecio
sengi	6	40	1651	3	sengi_
senile	6	34	2021	3	sen_ile
sennit	6	31	1792	3	sennit
senti	5	62	2670	3	senti_
serail	6	42	2267	3	serail
snail	5	70	2020	3	_snail
spancel	11	4	736	3	spancel
special	11	3	1030	3	spe_cial
specie	10	4	1222	3	spe_cie
speil	7	56	1864	3	spe__il
spence	10	38	1379	3	spenc_e
spencer	11	36	1097	3	spencer
spences	11	34	1392	3	spences
stencils	10	4	640	3	stencils
tenails	7	37	1392	3	tenails
tench	10	56	2000	3	tenc_h
tendril	8	3	678	3	tendril
tenia	5	53	2448	3	ten_ia
tennis	6	40	1530	3	tennis
tenpin	8	3	1058	3	tenpin
tensile	7	26	1273	3	tensile
tentie	6	25	2118	3	tentie
tenuis	6	42	1308	3	tenuis
tercel	8	36	1299	3	tercel
tincal	8	39	1337	3	tincal
toenail	7	3	878	3	toenail
tonsil	6	3	1187	3	tonsil
trenail	7	4	1081	3	trenail
unci	6	50	1946	3	_unci_
uncia	7	50	1516	3	_uncia
uncial	8	37	1522	3	_uncial
uncoil	8	8	1185	3	_uncoil
unnail	6	4	1058	3	unnail
until	5	35	1774	3	_until
uracil	8	3	1154	3	uracil
utensil	7	12	521	3	utensil
veil	7	55	2359	3	ve__il
venal	8	55	2321	3	ven_al
venial	9	42	1828	3	venial
venin	8	51	1866	3	ven_in
ventail	10	3	1045	3	ventail
vexil	15	3	896	3	ve_xil
weevil	12	9	543	3	weevil
wench	13	62	1478	3	wenc_h
xenia	12	48	1477	3	xen_ia
xenial	13	34	1490	3	xenial
xenic	14	41	1464	3	xen_ic
zincic	19	3	590	3	zincic

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	112716	0.373	479064.3
2	DLD Change Limit	112716	331	6.783	16617.4
3	Display Results	331	331	0.123	2691.1
	(SQL Overall)	178691	331	7.279	24548.8