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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

192 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
pech	11	61	2545	(None)
lech	9	68	2544	1	lech
peach	12	54	2249	1	peach
pec	7	67	4441	1	pec_
pechs	12	55	1620	1	pechs
peck	12	57	3068	1	peck
pecs	8	46	3410	1	pecs
peh	8	67	4096	1	pe_h
perch	12	45	1883	1	perch
tech	9	59	2544	1	tech
yech	12	72	2053	1	yech
arch	9	86	2844	2	arch
bach	11	61	3139	2	bach
beach	12	46	2389	2	beach
beck	12	62	2657	2	beck
beech	12	43	1550	2	beech
belch	12	44	1550	2	belch
bench	12	56	1950	2	bench
beth	9	66	2923	2	beth
ceca	8	48	2078	2	ceca
deck	11	58	2775	2	deck
deco	7	61	2597	2	deco
each	9	55	3058	2	each
eche	9	75	2028	2	_eche
echo	9	66	1595	2	_echo
echt	9	57	2290	2	_echt
ecu	5	68	2823	2	_ecu
edh	7	69	2156	2	_edh
eh	5	83	3996	2	_e_h
epoch	12	4	820	2	epoch
etch	9	54	1914	2	etch
eth	6	66	3098	2	_eth
feck	13	49	2343	2	feck
feh	9	61	3609	2	fe_h
fetch	13	49	1347	2	fetch
geck	11	57	2199	2	geck
heck	13	58	2649	2	heck
heh	9	60	3962	2	he_h
heth	10	70	2802	2	heth
heuch	13	53	1233	2	heuch
ich	8	62	2774	2	_ich
inch	9	54	2082	2	inch
itch	9	56	1917	2	itch
keck	9	49	2071	2	keck
kench	14	55	1392	2	kench
ketch	14	49	1202	2	ketch
leach	10	54	2252	2	leach
leech	10	49	1321	2	leech
letch	10	52	1580	2	letch
lich	9	62	3084	2	lich
loch	9	55	2713	2	loch
lych	12	60	1576	2	lych
mach	11	61	3447	2	mach
merch	12	54	1796	2	merch
mesh	9	68	2300	2	mesh
meth	9	58	2784	2	meth
much	11	52	2403	2	much
neck	10	54	2366	2	neck
ouch	9	57	2463	2	ouch
pac	7	90	5408	2	pac_
paca	8	51	3224	2	paca
pace	8	63	4577	2	pace
pacha	12	65	1806	2	pacha
pack	12	55	3544	2	pack
pacs	8	58	4218	2	pacs
pact	8	66	4872	2	pact
pacy	11	53	2868	2	pacy
pah	8	88	5359	2	p_ah
parch	12	51	2300	2	parch
pash	9	56	3813	2	pash
patch	12	52	2122	2	patch
path	9	91	3491	2	path
pe	4	76	4903	2	pe__
pea	5	66	5724	2	pe_a
peace	9	50	2608	2	peace
peachy	16	45	1084	2	peachy
peag	7	54	3134	2	peag
peak	10	65	3520	2	peak
peal	6	86	4810	2	peal
pean	6	61	4717	2	pean
pear	6	97	4523	2	pear
peas	6	57	5506	2	peas
peat	6	59	6793	2	peat
pecan	9	19	1903	2	pecan
pechan	13	5	1154	2	pechan
peched	14	49	1534	2	peched
pecks	13	57	2443	2	pecks
pecky	16	55	1509	2	pecky
ped	6	67	5152	2	pe_d
peds	7	58	3524	2	peds
pee	5	60	6651	2	pe_e
peed	7	62	3918	2	peed
peek	10	60	3143	2	peek
peel	6	55	3561	2	peel
peen	6	59	3808	2	peen
peep	8	58	3369	2	peep
peer	6	62	3835	2	peer
pees	6	52	5737	2	pees
peg	6	58	4306	2	pe_g
pegs	7	55	3176	2	pegs
pehs	9	56	2576	2	pehs
pein	6	58	3494	2	pein
peke	10	59	2620	2	peke
pele	6	55	3955	2	pele
pelf	9	70	3145	2	pelf
pelt	6	76	5108	2	pelt
pen	5	65	5884	2	pe_n
pence	9	49	2445	2	pence
pend	7	59	3453	2	pend
pens	6	56	4964	2	pens
pent	6	65	5907	2	pent
peon	6	56	3524	2	peon
pep	7	64	4708	2	pe_p
pepo	8	76	2215	2	pepo
peps	8	51	3451	2	peps
per	5	63	5309	2	pe_r
pere	6	64	5026	2	pere
peri	6	56	3697	2	peri
perk	10	62	3284	2	perk
perm	8	58	3463	2	perm
perp	8	90	2989	2	perp
pert	6	67	5932	2	pert
perv	9	72	2481	2	perv
pes	5	72	5978	2	pe_s
peso	6	69	2582	2	peso
pest	6	55	5529	2	pest
pet	5	64	7730	2	pe_t
pets	6	62	4833	2	pets
pew	8	64	4230	2	pe_w
pews	9	57	3153	2	pews
pic	7	60	4682	2	pic_
pica	8	58	3149	2	pica
pice	8	46	4109	2	pice
pick	12	59	3381	2	pick
pics	8	56	3391	2	pics
piece	9	67	1799	2	piece
pinch	12	56	1930	2	pinch
pish	9	61	2791	2	pish
pitch	12	50	1841	2	pitch
pith	9	54	3269	2	pith
pleach	13	42	1124	2	pleach
plench	13	40	1081	2	plench
poach	12	49	1786	2	poach
pock	12	61	2929	2	pock
poco	8	68	2615	2	poco
poh	8	67	4053	2	p_oh
pooch	12	48	1530	2	pooch
pooh	9	60	2738	2	pooh
porch	12	59	1862	2	porch
posh	9	54	2732	2	posh
pouch	12	46	1708	2	pouch
preach	13	36	1392	2	preach
psych	15	5	496	2	psych
puce	8	51	2788	2	puce
puck	12	49	2794	2	puck
pugh	10	66	1923	2	pugh
punch	12	51	1842	2	punch
push	9	55	2662	2	push
reach	10	51	2388	2	reach
rec	5	56	4546	2	rec_
reck	10	61	3056	2	reck
recs	6	57	3418	2	recs
resh	7	65	2345	2	resh
retch	10	48	1830	2	retch
rich	9	70	2554	2	rich
sec	5	59	4532	2	sec_
secs	6	50	3389	2	secs
sect	6	74	4362	2	sect
spec	8	58	2197	2	spec_
speck	13	51	1565	2	speck
specs	9	69	1667	2	specs
speech	13	4	756	2	speech
such	9	64	2481	2	such
tach	9	61	3275	2	tach
teach	10	52	2112	2	teach
techs	10	69	1583	2	techs
techy	13	56	1201	2	techy
tench	10	56	2000	2	tench
teth	7	63	2788	2	teth
teuch	10	52	1485	2	teuch
vetch	13	44	1184	2	vetch
wecht	13	4	1544	2	wecht
welch	13	44	1149	2	welch
wench	13	62	1478	2	wench
wich	12	57	2474	2	wich
wych	15	40	1188	2	wych
yeah	10	67	2541	2	yeah
yecch	15	55	809	2	yecch
yechs	13	61	1258	2	yechs
yechy	16	51	908	2	yechy
yeh	9	71	3577	2	ye_h
yuch	12	58	1853	2	yuch

Search took 2 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	29872	0.080	2233637.5
2	DLD Change Limit	29872	192	0.920	32469.6
3	Display Results	192	192	0.046	4173.9
	(SQL Overall)	178691	192	1.046	170832.7