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

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

71 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
pinched	15	38	1245	(None)
cinched	15	39	1086	1	cinched
inched	12	45	1448	1	_inched
pincher	14	38	1271	1	pincher
pinches	14	41	1793	1	pinches
pitched	15	35	1292	1	pitched
punched	15	35	1217	1	punched
winched	16	31	1059	1	winched
benched	15	47	1394	2	benched
birched	15	34	991	2	birched
bitched	15	32	1292	2	bitched
bunched	15	43	1241	2	bunched
cinches	14	42	1577	2	cinches
clinched	16	34	738	2	clinched
ditched	14	37	1190	2	ditched
filched	16	30	742	2	filched
finches	15	39	1419	2	finches
flinched	17	31	670	2	flinched
hitched	16	33	1225	2	hitched
hunched	16	37	1049	2	hunched
incher	11	41	1403	2	_incher
inches	11	44	1967	2	_inches
itched	12	38	1202	2	_itched
lunched	13	39	1182	2	lunched
lynched	16	37	675	2	lynched
miched	14	39	1339	2	mi_ched
minced	11	41	1491	2	minc_ed
munched	15	34	1107	2	munched
niched	12	55	1406	2	ni_ched
painches	15	8	891	2	painches
parched	15	40	1369	2	parched
patched	15	35	1462	2	patched
paunched	16	4	552	2	paunched
peached	15	43	1588	2	peached
peched	14	49	1534	2	p_eched
perched	15	47	1323	2	perched
picked	15	44	2131	2	pi_cked
pieced	11	39	1210	2	piec_ed
pincer	10	40	1917	2	pinc_er
pinch	12	56	1930	2	pinch__
pincheck	21	4	338	2	pincheck
pinchers	15	35	1061	2	pinchers
pined	8	59	3532	2	pin__ed
pinged	10	43	2138	2	pin_ged
pinhead	13	34	707	2	pin_head
pinked	13	48	1988	2	pin_ked
pinned	9	48	1838	2	pin_ned
pinscher	15	4	480	2	pinscher
pinweed	13	4	693	2	pinweed
pished	12	48	1706	2	pi_shed
pitcher	14	38	1371	2	pitcher
pitches	14	36	1775	2	pitches
pithed	12	46	1561	2	pi_thed
poached	15	42	1240	2	poached
ponced	11	43	1481	2	ponc_ed
ponchoed	16	4	613	2	ponchoed
pooched	15	28	1008	2	pooched
pouched	15	36	1277	2	pouched
psyched	18	4	391	2	psyched
puncher	14	33	1167	2	puncher
punches	14	48	1613	2	punches
ranched	13	31	1360	2	ranched
synched	16	27	721	2	synched
tincted	10	3	727	2	tincted
wenched	16	39	1091	2	wenched
winced	12	44	1534	2	winc_ed
wincher	15	34	1065	2	wincher
winches	15	47	1437	2	winches
witched	16	30	1219	2	witched
zinced	18	41	941	2	zinc_ed
zincked	23	3	423	2	zincked

Search took 4 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	107671	0.123	1452772.4
2	DLD Change Limit	107671	71	3.516	30623.2
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	3.669	48702.9