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

Here are the results of your fuzzy-string dictionary search for “hitches” 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
hitches	15	36	1627	(None)
aitches	12	30	1436	1	aitches
bitches	14	41	1706	1	bitches
ditches	13	32	1571	1	ditches
fitches	15	35	1619	1	fitches
hatches	15	34	2027	1	hatches
hitched	16	33	1225	1	hitched
hitcher	15	37	1200	1	hitcher
hitchers	16	37	999	1	hitchers
hotches	15	38	1436	1	hotches
hutches	15	36	1352	1	hutches
itches	11	49	1621	1	_itches
pitches	14	36	1775	1	pitches
witches	15	27	1579	1	witches
batches	14	40	1961	2	batches
birches	14	34	1232	2	birches
bitched	15	32	1292	2	bitched
bitchen	14	34	973	2	bitchen
botches	14	37	1602	2	botches
britches	15	27	868	2	britches
butches	14	43	1536	2	butches
catches	14	43	2076	2	catches
chinches	18	36	936	2	chinches
cinches	14	42	1577	2	cinches
cutches	14	32	1645	2	cutches
ditched	14	37	1190	2	ditched
ditcher	13	40	1200	2	ditcher
ditchers	14	36	1036	2	ditchers
etches	11	42	1776	2	_etches
fetches	15	34	1389	2	fetches
fiches	14	52	1953	2	fi_ches
filches	15	34	1072	2	filches
finches	15	39	1419	2	finches
fitchee	15	27	1078	2	fitchee
fitchet	15	31	1356	2	fitchet
fitchets	16	30	741	2	fitchets
fitchew	18	27	680	2	fitchew
fitchews	19	27	477	2	fitchews
flitches	16	38	846	2	flitches
glitches	14	29	665	2	glitches
hatched	16	34	1446	2	hatched
hatchel	15	35	1075	2	hatchel
hatchels	16	36	867	2	hatchels
hatcher	15	33	1472	2	hatcher
hatchers	16	31	1317	2	hatchers
hatchet	15	33	1756	2	hatchet
hatchets	16	33	1038	2	hatchets
hitch	13	45	1547	2	hitch__
hither	12	44	1725	2	hit_her
hooches	15	38	1252	2	hooches
hootches	16	5	697	2	hootches
hotched	16	36	1092	2	hotched
hunches	15	39	1346	2	hunches
hutched	16	35	988	2	hutched
inches	11	44	1967	2	_inches
itched	12	38	1202	2	_itched
ketches	16	40	1219	2	ketches
kitchen	16	28	768	2	kitchen
kitchens	17	19	578	2	kitchens
kithes	13	50	1665	2	kit_hes
kitsches	17	3	407	2	kitsches
latches	12	33	2012	2	latches
letches	12	40	1548	2	letches
liches	11	47	2429	2	li_ches
litchis	12	3	837	2	litchis
matches	14	32	1978	2	matches
miches	13	43	2073	2	mi_ches
mutches	14	33	1428	2	mutches
niches	11	44	1914	2	ni_ches
nitchies	13	3	907	2	nitchies
notches	12	35	1365	2	notches
patches	14	33	2038	2	patches
pinches	14	41	1793	2	pinches
pitched	15	35	1292	2	pitched
pitcher	14	38	1371	2	pitcher
pitchers	15	32	1148	2	pitchers
quitches	22	3	619	2	quitches
ratches	12	36	2046	2	ratches
retches	12	33	1851	2	retches
riches	11	50	2208	2	ri_ches
rotches	12	35	1570	2	rotches
snitches	13	14	898	2	snitches
stitches	13	14	1059	2	stitches
switches	16	15	913	2	switches
thatches	16	3	751	2	thatches
tithes	9	47	2021	2	tit_hes
twitches	16	15	637	2	twitches
unhitches	17	4	307	2	unhitches
vetches	15	34	1126	2	vetches
watches	15	30	1737	2	watches
wiches	14	44	1875	2	wi_ches
winches	15	47	1437	2	winches
witched	16	30	1219	2	witched
withes	12	46	2084	2	wit_hes
zilches	21	32	630	2	zilches

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	95	3.126	34443.7
3	Display Results	95	95	0.030	3166.7
	(SQL Overall)	178691	95	3.279	54495.6