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

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

83 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
miching	15	29	1180	(None)
niching	13	36	1243	1	niching
aching	12	65	2197	2	_aching
arching	13	62	1669	2	arching
baching	15	60	1775	2	baching
birching	16	32	846	2	birching
bitching	16	36	1062	2	bitching
caching	15	63	1750	2	caching
cinching	16	33	1022	2	cinching
dicing	10	57	1876	2	dic_ing
dicking	15	36	1761	2	dicking
dishing	12	40	1710	2	dishing
ditching	15	34	994	2	ditching
eching	12	63	1556	2	_eching
etching	13	45	1184	2	etching
filching	17	3	611	2	filching
fishing	14	39	1386	2	fishing
hitching	17	33	1052	2	hitching
icing	8	60	1775	2	_ic_ing
inching	13	44	1432	2	inching
itching	13	40	1168	2	itching
kicking	13	33	1402	2	kicking
kithing	15	34	1155	2	kithing
leching	13	46	1365	2	leching
lichting	14	26	851	2	lichting
licking	14	41	1828	2	licking
machine	14	3	1349	2	machine
macing	11	42	2155	2	mac_ing
marching	16	43	1219	2	marching
mashing	13	44	2224	2	mashing
matching	16	35	1239	2	matching
meshing	13	45	1381	2	meshing
miffing	16	29	840	2	miffing
miking	13	42	1846	2	mi_king
milchig	15	4	365	2	milchi_g
milding	11	36	1545	2	milding
milking	14	37	1276	2	milking
milling	10	32	2368	2	milling
milting	10	36	1912	2	milting
miming	11	43	1726	2	mi_ming
mincing	12	33	1433	2	mincing
minding	11	33	1789	2	minding
mining	9	42	2545	2	mi_ning
minting	10	30	2081	2	minting
miring	9	37	2380	2	mi_ring
miscuing	13	3	873	2	miscuing
missing	10	36	1907	2	missing
misting	10	36	2338	2	misting
mitring	10	35	1414	2	mitring
mixing	16	47	1394	2	mi_xing
mocking	16	36	1445	2	mocking
mooching	16	25	906	2	mooching
moshing	13	42	1488	2	moshing
mouching	16	31	1058	2	mouching
mucking	16	32	1382	2	mucking
mulching	16	28	710	2	mulching
munching	16	29	997	2	munching
mushing	13	42	1763	2	mushing
nicking	14	35	1632	2	nicking
nighing	12	34	1006	2	nighing
ouching	13	43	1490	2	ouching
peching	15	45	1390	2	peching
picking	16	34	1833	2	picking
pinching	16	37	1105	2	pinching
pishing	13	43	1437	2	pishing
pitching	16	34	1111	2	pitching
pithing	13	40	1405	2	pithing
ricing	9	48	2276	2	ric_ing
ricking	14	39	2023	2	ricking
ruching	13	36	1293	2	ruching
siccing	12	31	951	2	siccing
sicking	14	37	2017	2	sicking
sighing	12	33	1166	2	sighing
smirching	17	4	439	2	smirching
ticcing	12	30	863	2	ticcing
ticking	14	32	1875	2	ticking
tithing	11	35	1389	2	tithing
vicing	12	40	1424	2	vic_ing
wicking	17	34	1477	2	wicking
winching	17	35	990	2	winching
wishing	14	41	1489	2	wishing
witching	17	34	1063	2	witching
withing	14	38	1449	2	withing

Search took 5 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.156	1145455.1
2	DLD Change Limit	107671	83	3.940	27327.7
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	4.126	43308.5