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

Here are the results of your fuzzy-string dictionary search for “peched” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

96 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
peched	14	49	1534	(None)
eched	11	69	1922	1	_eched
leched	12	37	1600	1	leched
peached	15	43	1588	1	peached
pecked	15	50	1910	1	pecked
perched	15	47	1324	1	perched
teched	12	40	1443	1	teched
ached	11	92	2783	2	_ached
arched	12	57	1732	2	arched
bached	14	55	1989	2	bached
beached	15	45	1655	2	beached
becked	15	54	1776	2	becked
belched	15	40	1184	2	belched
benched	15	47	1394	2	benched
cached	14	54	1920	2	cached
decked	14	52	1762	2	decked
eche	9	75	2028	2	_eche_
eches	10	63	2216	2	_eches
echoed	12	52	1115	2	_echoed
etched	12	36	1370	2	etched
fetched	16	37	1047	2	fetched
gecked	14	69	1193	2	gecked
inched	12	45	1448	2	inched
itched	12	38	1202	2	itched
kecked	12	51	1317	2	kecked
leached	13	37	1504	2	leached
lecher	11	34	1585	2	lecher
leches	11	54	2131	2	leches
leeched	13	36	950	2	leeched
letched	13	39	1205	2	letched
meshed	12	44	1593	2	meshed
miched	14	39	1339	2	miched
necked	13	47	1506	2	necked
niched	12	55	1406	2	niched
ouched	12	43	1693	2	ouched
paced	10	69	3168	2	pac_ed
packed	15	48	2260	2	packed
parched	15	40	1369	2	parched
pashed	12	59	2314	2	pashed
patched	15	35	1462	2	patched
peaced	11	58	1891	2	peaced
peacher	14	42	1607	2	peacher
peaches	14	41	2005	2	peaches
peahen	11	34	1013	2	peahen
peaked	13	61	1740	2	peaked
pealed	9	53	2281	2	pealed
pech	11	61	2545	2	pech__
pechan	13	5	1154	2	pechan
pechs	12	55	1620	2	pech_s
pecker	14	46	1536	2	pecker
pecten	10	27	1110	2	pecten
peed	7	62	3918	2	pe__ed
peeked	13	43	1458	2	peeked
peeled	9	41	1971	2	peeled
peened	9	43	1816	2	peened
peeped	11	39	1539	2	peeped
peered	9	38	1949	2	peered
peeved	12	41	1289	2	peeved
pegged	11	48	1191	2	pegged
peined	9	49	1884	2	peined
peised	9	48	1768	2	peised
pelted	9	46	1776	2	pelted
pended	10	38	1901	2	pended
penned	9	42	1761	2	penned
pepped	10	31	1340	2	pepped
percher	14	33	1342	2	percher
perches	14	37	1795	2	perches
perked	13	46	1769	2	perked
permed	11	52	1735	2	permed
petted	9	41	2152	2	petted
picked	15	44	2131	2	picked
pieced	11	39	1210	2	piec_ed
pinched	15	38	1245	2	pinched
pished	12	48	1706	2	pished
pitched	15	35	1292	2	pitched
pithed	12	46	1561	2	pithed
pleached	16	33	806	2	pleached
poached	15	42	1240	2	poached
pocked	15	48	1898	2	pocked
pooched	15	28	1008	2	pooched
poohed	12	39	1252	2	poohed
pouched	15	36	1277	2	pouched
preached	16	34	1206	2	preached
psyched	18	4	391	2	psyched
punched	15	35	1217	2	punched
pushed	12	50	1746	2	pushed
reached	13	46	1908	2	reached
rechew	14	3	1021	2	rechew
recked	13	48	2180	2	recked
retched	13	38	1427	2	retched
ruched	12	43	1463	2	ruched
specced	14	26	670	2	specced
specked	16	32	901	2	specked
tetched	13	30	1077	2	tetched
welched	16	29	883	2	welched
wenched	16	39	1091	2	wenched

Search took 3 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	82551	0.340	525561.8
2	DLD Change Limit	82551	96	2.486	33206.4
3	Display Results	96	96	0.030	3200.0
	(SQL Overall)	178691	96	2.856	62566.9