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

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

66 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
niching	13	36	1243	(None)
inching	13	44	1432	1	inching
miching	15	29	1180	1	miching
nicking	14	35	1632	1	nicking
nighing	12	34	1006	1	nighing
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
enriching	15	4	615	2	enriching
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
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
necking	14	39	1389	2	necking
neighing	13	5	552	2	neighing
nibbing	12	33	955	2	nibbing
nickling	15	27	870	2	nickling
niding	8	32	1798	2	ni_ding
nilling	8	36	1956	2	nilling
nimming	12	35	814	2	nimming
nipping	12	34	1287	2	nipping
nixing	14	33	1149	2	ni_xing
nocking	14	36	1511	2	nocking
noshing	11	46	1277	2	noshing
notching	14	28	858	2	notching
nothing	11	35	1190	2	nothing
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
snicking	15	36	1023	2	snicking
snitching	15	3	591	2	snitching
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 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.423	422437.4
2	DLD Change Limit	107671	66	2.873	37476.9
3	Display Results	66	66	0.033	2000.0
	(SQL Overall)	178691	66	3.329	53677.1