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

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

95 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
perch	12	45	1883	(None)
merch	12	54	1796	1	merch
parch	12	51	2300	1	parch
peach	12	54	2249	1	peach
pech	11	61	2545	1	pe_ch
porch	12	59	1862	1	porch
apercu	10	5	738	2	apercu
arch	9	86	2844	2	_arch
beach	12	46	2389	2	beach
beech	12	43	1550	2	beech
belch	12	44	1550	2	belch
bench	12	56	1950	2	bench
berth	10	49	1788	2	berth
birch	12	49	1402	2	birch
cerci	9	37	1639	2	cerci
curch	12	44	1541	2	curch
each	9	55	3058	2	_each
eparch	13	25	842	2	eparch
epoch	12	4	820	2	epoch
etch	9	54	1914	2	_etch
fetch	13	49	1347	2	fetch
gerah	9	3	1530	2	gerah
heuch	13	53	1233	2	heuch
kench	14	55	1392	2	kench
ketch	14	49	1202	2	ketch
larch	10	59	1979	2	larch
leach	10	54	2252	2	leach
lech	9	68	2544	2	le_ch
leech	10	49	1321	2	leech
letch	10	52	1580	2	letch
lurch	10	48	1463	2	lurch
march	12	56	2289	2	march
merc	8	72	2562	2	merc_
mercs	9	60	2045	2	mercs
mercy	12	59	1618	2	mercy
patch	12	52	2122	2	patch
peace	9	50	2608	2	peace
peachy	16	45	1084	2	peachy
pec	7	67	4441	2	pe_c_
pechs	12	55	1620	2	pe_chs
peck	12	57	3068	2	pe_ck
pecs	8	46	3410	2	pe_cs
peh	8	67	4096	2	pe__h
pence	9	49	2445	2	pence
per	5	63	5309	2	per__
perched	15	47	1324	2	perched
percher	14	33	1342	2	percher
perches	14	37	1795	2	perches
perdu	8	42	1627	2	perdu
perdy	11	54	1733	2	perdy
pere	6	64	5026	2	per_e
perea	7	50	2644	2	perea
peres	7	62	4664	2	peres
peri	6	56	3697	2	per_i
peril	7	54	2595	2	peril
peris	7	55	3707	2	peris
perish	11	46	1906	2	perish
perk	10	62	3284	2	per_k
perks	11	53	2580	2	perks
perky	14	53	1948	2	perky
perm	8	58	3463	2	per_m
perms	9	55	2451	2	perms
perp	8	90	2989	2	per_p
perps	9	55	2148	2	perps
perry	10	52	2271	2	perry
perse	7	54	2952	2	perse
pert	6	67	5932	2	per_t
perv	9	72	2481	2	per_v
pervs	10	51	1737	2	pervs
pierce	10	40	1039	2	pierce
pinch	12	56	1930	2	pinch
pitch	12	50	1841	2	pitch
pleach	13	42	1124	2	pleach
plench	13	40	1081	2	plench
poach	12	49	1786	2	poach
pooch	12	48	1530	2	pooch
pouch	12	46	1708	2	pouch
preach	13	36	1392	2	preach
psych	15	5	496	2	psych
punch	12	51	1842	2	punch
reach	10	51	2388	2	reach
retch	10	48	1830	2	retch
search	11	33	1242	2	search
speech	13	4	756	2	speech
teach	10	52	2112	2	teach
tech	9	59	2544	2	te_ch
tench	10	56	2000	2	tench
terce	7	57	2184	2	terce
teuch	10	52	1485	2	teuch
torch	10	74	2093	2	torch
vetch	13	44	1184	2	vetch
welch	13	44	1149	2	welch
wench	13	62	1478	2	wench
yecch	15	55	809	2	yecch
yech	12	72	2053	2	ye_ch

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	53800	0.310	576422.6
2	DLD Change Limit	53800	95	1.596	33709.3
3	Display Results	95	95	0.013	7307.7
	(SQL Overall)	178691	95	1.919	93116.7