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

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

59 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
nighed	11	38	1129	(None)
neighed	12	13	589	1	neighed
niched	12	55	1406	1	niched
nigher	10	36	1275	1	nigher
sighed	11	37	1205	1	sighed
bighead	14	12	665	2	bighead
bighted	14	28	1092	2	bighted
digged	10	43	1465	2	digged
dighted	13	25	1149	2	dighted
dished	11	43	1871	2	dished
figged	12	40	1389	2	figged
fished	13	43	1631	2	fished
gigged	10	41	1229	2	gigged
gighe	10	13	973	2	gighe_
higher	13	46	1089	2	higher
highted	15	27	1016	2	highted
igged	8	60	1276	2	_igged
inched	12	45	1448	2	inched
jigged	16	44	1277	2	jigged
kithed	14	46	1301	2	kithed
knighted	17	4	512	2	knighted
lighted	12	29	1350	2	lighted
miched	14	39	1339	2	miched
nagged	9	39	1605	2	nagged
nibbed	11	43	1190	2	nibbed
niche	10	50	1679	2	niche_
niches	11	44	1914	2	niches
nicked	13	50	1968	2	nicked
nided	7	59	2087	2	ni_ded
nigger	8	97	1357	2	nigger
niggled	10	31	920	2	niggled
nigh	8	52	2066	2	nigh__
nighest	11	3	1069	2	nighest
nighs	9	50	1361	2	nigh_s
night	9	43	2785	2	nigh_t
nights	10	41	1772	2	nights
nighty	13	56	1127	2	nighty
nilled	7	39	1945	2	nilled
nimmed	11	36	857	2	nimmed
nipped	11	36	1585	2	nipped
nixed	13	57	1422	2	ni_xed
nogged	9	57	1633	2	nogged
noshed	10	44	1350	2	noshed
pigged	11	42	1415	2	pigged
pished	12	48	1706	2	pished
pithed	12	46	1561	2	pithed
rigged	9	45	1740	2	rigged
righted	12	29	1214	2	righted
sigher	10	38	1370	2	sigher
sighted	12	31	1152	2	sighted
signed	8	34	1375	2	signed
sughed	11	36	1020	2	sughed
thighed	15	3	526	2	thighed
tithed	10	41	1559	2	tithed
weighed	15	13	593	2	weighed
wigged	12	44	1358	2	wigged
wished	13	44	1751	2	wished
withed	13	44	1623	2	withed
zigged	18	41	1019	2	zigged

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	82551	0.110	1624463.6
2	DLD Change Limit	82551	59	3.936	20973.3
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	4.076	43839.8