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

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

337 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
perching	16	37	1163	(None)
parching	16	43	1305	1	parching
peaching	16	36	1364	1	peaching
peching	15	45	1390	1	pe_ching
arching	13	62	1669	2	_arching
beaching	16	41	1414	2	beaching
belching	16	34	915	2	belching
benching	16	34	1134	2	benching
berthing	14	20	960	2	berthing
birching	16	32	846	2	birching
eching	12	63	1556	2	_e_ching
etching	13	45	1184	2	_etching
fetching	17	29	841	2	fetching
leaching	14	30	1283	2	leaching
leching	13	46	1365	2	le_ching
leeching	14	31	837	2	leeching
letching	14	38	1026	2	letching
lurching	14	27	733	2	lurching
marching	16	43	1219	2	marching
patching	16	32	1275	2	patching
peacing	12	41	1707	2	peac_ing
pecking	16	40	1778	2	pe_cking
periling	11	3	1686	2	periling
perishing	15	3	953	2	perishing
perking	14	37	1646	2	per_king
perming	12	34	1609	2	per_ming
perusing	11	8	1106	2	perusing
piercing	13	4	666	2	pierc_ing
pinching	16	37	1105	2	pinching
pitching	16	34	1111	2	pitching
pleaching	17	25	708	2	pleaching
poaching	16	35	1083	2	poaching
pooching	16	32	898	2	pooching
pouching	16	32	1041	2	pouching
preaching	17	28	1116	2	preaching
psyching	19	3	448	2	psyching
punching	16	33	1012	2	punching
reaching	14	33	1720	2	reaching
retching	14	34	1217	2	retching
searching	15	3	834	2	searching
teaching	14	36	1260	2	teaching
torching	14	25	1008	2	torching
welching	17	28	736	2	welching
wenching	17	32	886	2	wenching
aching	12	65	2197	3	__aching
aerating	9	28	2100	3	aerating
airthing	12	29	795	3	airthing
amercing	13	3	719	3	amerc_ing
archine	12	58	1705	3	_archine
archings	14	49	986	3	_archings
arcing	9	58	1964	3	_arc_ing
arcking	14	58	1196	3	_arcking
baching	15	60	1775	3	_baching
batching	16	37	1209	3	batching
becking	16	44	1607	3	be_cking
beraking	15	36	1297	3	beraking
berating	11	32	2076	3	berating
beriming	13	3	1046	3	beriming
berming	12	36	1483	3	ber_ming
berrying	14	13	738	3	berrying
birthing	14	33	843	3	birthing
bitching	16	36	1062	3	bitching
bleaching	17	28	709	3	bleaching
blenching	17	27	650	3	blenching
botching	16	35	970	3	botching
breaching	17	26	940	3	breaching
breeching	17	23	647	3	breeching
bunching	16	34	1070	3	bunching
caching	15	63	1750	3	_caching
catching	16	37	1277	3	catching
cering	9	45	2253	3	cer__ing
churching	20	5	508	3	churching
cinching	16	33	1022	3	cinching
circling	13	3	842	3	circling
clenching	17	26	630	3	clenching
coaching	16	40	1196	3	coaching
coercing	13	4	900	3	coerc_ing
couching	16	32	1326	3	couching
deashing	13	42	1095	3	deashing
decking	15	39	1559	3	de_cking
decrying	15	23	741	3	decrying
deicing	11	3	1219	3	deic_ing
derating	10	32	2228	3	derating
deriding	11	25	1293	3	deriding
deriving	13	25	1074	3	deriving
detaching	16	3	726	3	detaching
deucing	11	3	939	3	deuc_ing
ditching	15	34	994	3	ditching
douching	15	34	984	3	douching
drenching	16	25	603	3	drenching
earthing	12	3	1033	3	earthing
echini	11	47	1043	3	_e_chini
echoing	13	5	861	3	_e_choing
enriching	15	4	615	3	enriching
erasing	8	3	1796	3	_erasing
erecting	11	24	1506	3	_erecting
erlking	12	3	670	3	_erlking
eroding	9	3	1427	3	_eroding
errhine	10	3	659	3	_errhine
erring	7	38	1648	3	_er_ring
eructing	11	21	1017	3	_eructing
etchings	14	39	629	3	_etchings
euchring	14	3	661	3	_euchring
farcing	13	35	1400	3	farc_ing
farthing	15	3	807	3	farthing
fencing	13	24	1113	3	fenc_ing
ferrying	15	14	625	3	ferrying
feruling	12	5	887	3	feruling
filching	17	3	611	3	filching
fleeching	18	30	501	3	fleeching
flenching	18	29	670	3	flenching
fletching	18	25	614	3	fletching
forcing	13	40	1375	3	forc_ing
frenching	18	26	775	3	frenching
freshing	15	26	1102	3	freshing
gecking	15	41	1136	3	ge_cking
girthing	13	25	608	3	girthing
hatching	17	33	1221	3	hatching
herding	12	29	1512	3	her_ding
herring	11	36	1588	3	her_ring
herrying	15	14	703	3	herrying
hitching	17	33	1052	3	hitching
hotching	17	30	931	3	hotching
hunching	17	30	911	3	hunching
hutching	17	31	864	3	hutching
impeaching	20	4	337	3	impeaching
inarching	15	4	634	3	inarching
inching	13	44	1432	3	_inching
itching	13	40	1168	3	_itching
jerking	19	30	892	3	jer_king
kecking	13	41	1188	3	ke_cking
kerbing	14	30	848	3	ker_bing
kerchief	20	4	387	3	kerchief
kerfing	15	30	753	3	ker_fing
kerning	12	40	1089	3	ker_ning
kvetching	22	4	290	3	kvetching
latching	14	37	1202	3	latching
leashing	12	33	1031	3	leashing
lunching	14	31	1000	3	lunching
lynching	17	33	608	3	lynching
matching	16	35	1239	3	matching
merchant	15	4	882	3	merchant
merging	11	27	1176	3	mer_ging
meriting	11	3	1469	3	meriting
meshing	13	45	1381	3	me_shing
miching	15	29	1180	3	_miching
mooching	16	25	906	3	mooching
morphing	16	3	755	3	morphing
mouching	16	31	1058	3	mouching
mulching	16	28	710	3	mulching
munching	16	29	997	3	munching
necking	14	39	1389	3	ne_cking
neighing	13	5	552	3	neighing
nerving	11	29	1083	3	ner_ving
niching	13	36	1243	3	_niching
northing	12	19	906	3	northing
notching	14	28	858	3	notching
operating	12	3	1372	3	operating
ouching	13	43	1490	3	_ouching
pacing	11	45	2275	3	p_ac_ing
packing	16	44	2072	3	p_acking
parading	12	3	1386	3	parading
parawing	14	3	1058	3	parawing
parceling	14	3	844	3	parceling
parchisi	15	36	893	3	parchisi
parging	11	33	1860	3	par_ging
paring	9	42	3649	3	par__ing
parking	14	34	2304	3	par_king
parling	10	38	2376	3	par_ling
paroling	11	33	1621	3	paroling
parring	10	32	2206	3	par_ring
parrying	14	16	813	3	parrying
parsing	10	38	1955	3	par_sing
parting	10	35	2738	3	par_ting
partying	14	16	889	3	partying
pashing	13	51	2051	3	p_ashing
peachier	15	4	862	3	peachier
peaking	14	43	1769	3	pe_aking
pealing	10	41	2320	3	pe_aling
pearling	11	9	1201	3	pearling
pebbling	15	3	507	3	pebbling
pechan	13	5	1154	3	pe_chan_
pechans	14	8	1050	3	pe_chans
pectin	10	26	1553	3	pe_ctin_
pectins	11	23	1523	3	pe_ctins
pedaling	12	24	1213	3	pedaling
peddling	13	21	797	3	peddling
peeing	9	46	1808	3	pe__eing
peeking	14	44	1495	3	pe_eking
peeling	10	29	1987	3	pe_eling
peening	10	33	1830	3	pe_ening
peeping	12	36	1521	3	pe_eping
peering	10	35	2035	3	pe_ering
peeving	13	51	1224	3	pe_eving
pegging	12	28	1113	3	pe_gging
peining	10	46	1915	3	pe_ining
peising	10	34	1676	3	pe_ising
pelting	10	29	1727	3	pe_lting
penchant	15	4	959	3	penchant
penciling	14	3	741	3	penciling
pending	11	41	1977	3	pe_nding
penning	10	36	1649	3	pe_nning
peopling	13	3	835	3	peopling
pepping	11	35	1162	3	pe_pping
percaline	13	4	1095	3	percaline
perceive	15	4	697	3	perceive
perceiving	18	4	466	3	perceiving
percent	11	35	2060	3	perc_ent
perch	12	45	1883	3	perch___
perchance	18	6	639	3	perchance
perched	15	47	1324	3	perch_ed
percher	14	33	1342	3	perch_er
perchers	15	36	1152	3	perchers
perches	14	37	1795	3	perch_es
percoid	12	3	1232	3	percoi_d
percoids	13	3	966	3	percoids
percussing	15	4	522	3	percussing
perduring	13	3	601	3	perduring
perfecting	18	4	751	3	perfecting
perfuming	17	8	405	3	perfuming
perfusing	15	6	563	3	perfusing
perilling	12	4	1000	3	perilling
periwig	13	4	516	3	periwi_g
perjuring	19	4	492	3	perjuring
permuting	14	4	655	3	permuting
pertain	9	27	1496	3	pertain_
pertains	10	21	1342	3	pertains
pervading	16	3	630	3	pervading
pestling	11	10	1025	3	pestling
petering	11	25	1681	3	petering
petting	10	37	2095	3	pe_tting
pettling	11	6	821	3	pettling
phrasing	14	3	801	3	phrasing
picking	16	34	1833	3	p_icking
piecing	12	4	1045	3	piec_ing
piercings	14	5	326	3	pierc_ings
pirating	11	3	1451	3	pirating
pishing	13	43	1437	3	p_ishing
pithing	13	40	1405	3	p_ithing
placing	12	38	1528	3	plac_ing
plashing	14	33	1106	3	plashing
plucking	17	35	772	3	plucking
pocking	16	39	1676	3	p_ocking
poncing	12	29	1358	3	ponc_ing
poohing	13	31	1232	3	p_oohing
porcine	11	3	1284	3	porc_ine
porcini	11	3	763	3	porc_ini
porcino	11	3	811	3	porc_ino
poring	9	42	2727	3	por__ing
porking	14	35	1581	3	por_king
porting	10	30	2178	3	por_ting
prating	10	34	2445	3	p_rating
praying	13	37	1732	3	p_raying
preacting	14	24	1253	3	preacting
preceding	15	12	936	3	preceding
prechill	15	4	619	3	prechill
precising	14	4	1327	3	precising
precoding	15	10	973	3	precoding
precuring	14	3	942	3	precuring
preeing	10	38	1767	3	p_reeing
preening	11	31	1584	3	preening
prepping	12	30	976	3	prepping
pressing	11	25	1644	3	pressing
prevuing	14	5	725	3	prevuing
preying	13	31	1455	3	p_reying
pricing	12	34	1734	3	p_ricing
pricking	17	32	1260	3	pricking
priding	11	33	1754	3	p_riding
priming	12	34	1737	3	p_riming
prising	10	33	2145	3	p_rising
prizing	19	35	1468	3	p_rizing
probing	12	33	1444	3	p_robing
prosing	10	33	1938	3	p_rosing
proving	13	42	1407	3	p_roving
pruning	10	3	1173	3	p_runing
prying	12	41	1480	3	p_r_ying
purchasing	18	9	353	3	purchasing
pureeing	11	3	727	3	pureeing
purfling	14	6	776	3	purfling
purging	11	33	1418	3	pur_ging
purling	10	36	2029	3	pur_ling
purpling	13	6	854	3	purpling
purring	10	45	1582	3	pur_ring
pursing	10	37	1555	3	pur_sing
pursuing	11	4	623	3	pursuing
pushing	13	36	1545	3	p_ushing
quenching	24	4	392	3	quenching
ranching	14	17	1204	3	ranching
reacting	11	33	1789	3	reacting
recking	14	43	1992	3	re_cking
reechoing	15	4	529	3	reechoing
reracking	16	3	931	3	reracking
rerising	9	30	1778	3	rerising
rescuing	11	3	962	3	rescuing
roaching	14	32	1043	3	roaching
ruching	13	36	1293	3	_ruching
scorching	17	3	563	3	scorching
seething	12	3	902	3	seething
serging	9	34	1667	3	ser_ging
sering	7	47	3181	3	ser__ing
serrying	12	16	770	3	serrying
serving	11	30	1498	3	ser_ving
sketching	19	3	508	3	sketching
smirching	17	4	439	3	smirching
speccing	15	30	664	3	spe_ccing
specking	17	35	973	3	spe_cking
starching	15	3	859	3	starching
synching	17	22	771	3	synching
teachings	15	29	655	3	teachings
teething	12	3	716	3	teething
terming	10	40	1600	3	ter_ming
touching	14	32	1134	3	touching
trenching	15	22	765	3	trenching
upreaching	18	4	411	3	upreaching
urchin	11	3	874	3	_urchin_
urchins	12	3	886	3	_urchins
verging	12	38	1230	3	ver_ging
versing	11	23	1419	3	ver_sing
vetchling	18	4	359	3	vetchling
vouching	17	30	823	3	vouching
watching	17	30	1117	3	watching
weighing	16	3	528	3	weighing
welshing	15	29	652	3	welshing
winching	17	35	990	3	winching
witching	17	34	1063	3	witching
worthing	15	17	805	3	worthing
wrecking	18	32	815	3	wrecking
wrenching	18	27	627	3	wrenching
xeroxing	15	3	451	3	xeroxing
yerking	15	36	881	3	yer_king
zecchin	23	4	370	3	zecchin_
zecchini	24	4	238	3	zecchini
zecchino	24	4	266	3	zecchino
zecchins	24	4	353	3	zecchins
zechin	20	13	770	3	ze_chin_
zechins	21	13	712	3	ze_chins
zeroing	17	3	834	3	zer_oing

Search took 9 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	146162	0.436	409841.7
2	DLD Change Limit	146162	337	7.923	18447.8
3	Display Results	337	337	0.156	2160.3
	(SQL Overall)	178691	337	8.515	20985.4