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

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

72 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
niggers	9	31	1132	(None)
diggers	10	44	1339	1	diggers
jiggers	16	40	1018	1	jiggers
naggers	9	38	1265	1	naggers
nigger	8	97	1357	1	nigger_
nigglers	10	30	725	1	nigglers
riggers	9	36	1384	1	riggers
sniggers	10	31	709	1	sniggers
aggers	8	58	1779	2	_aggers
baggers	11	39	1569	2	baggers
bigger	10	43	1506	2	bigger_
bingers	10	45	1999	2	bingers
buggers	11	43	1566	2	buggers
chiggers	15	3	556	2	chiggers
daggers	10	37	1491	2	daggers
digger	9	46	1608	2	digger_
dingers	9	43	2138	2	dingers
doggers	10	44	1343	2	doggers
eggers	8	46	1258	2	_eggers
fingers	11	34	1843	2	fingers
foggers	12	41	1201	2	foggers
gaggers	10	34	1366	2	gaggers
gigglers	11	29	740	2	gigglers
gingers	9	41	1864	2	gingers
higglers	13	29	723	2	higglers
hingers	11	34	2021	2	hingers
hoggers	12	45	1248	2	hoggers
huggers	12	42	1159	2	huggers
jaggers	16	40	1289	2	jaggers
jigger	15	53	1305	2	jigger_
joggers	16	41	1069	2	joggers
keggers	13	35	703	2	keggers
laggers	9	42	1624	2	laggers
ligers	7	50	2204	2	li_gers
lingers	8	42	2330	2	lingers
loggers	9	46	1613	2	loggers
luggers	9	37	1348	2	luggers
muggers	11	36	1193	2	muggers
nagger	8	40	1612	2	nagger_
nickers	13	44	1509	2	nickers
nidgets	9	35	814	2	nidgets
niffers	13	28	736	2	niffers
niggard	10	4	494	2	niggard
niggards	11	4	412	2	niggards
niggler	9	36	1029	2	niggler_
niggles	9	35	1220	2	niggles
nigher	10	36	1275	2	nigher_
nippers	11	30	1262	2	nippers
niters	6	46	2421	2	ni_ters
nudgers	9	47	937	2	nudgers
nuggets	9	3	638	2	nuggets
piggery	14	26	619	2	piggery
pingers	10	40	2074	2	pingers
rigger	8	56	1671	2	rigger_
ringers	8	39	2295	2	ringers
ruggers	9	46	1231	2	ruggers
saggers	9	40	1708	2	saggers
sighers	11	37	1218	2	sighers
signers	8	47	1444	2	signers
singers	8	38	2470	2	singers
snigger	9	32	837	2	snigger_
snigglers	11	31	459	2	snigglers
swiggers	13	33	712	2	swiggers
taggers	9	35	1419	2	taggers
tigers	7	56	1651	2	ti_gers
triggers	10	25	784	2	triggers
tuggers	9	37	1144	2	tuggers
waggers	12	46	1308	2	waggers
wiggery	15	29	587	2	wiggery
wigglers	13	25	721	2	wigglers
wingers	11	39	2148	2	wingers
zingers	17	35	1485	2	zingers

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.140	1276364.3
2	DLD Change Limit	107671	72	3.390	31761.4
3	Display Results	72	72	0.016	4500.0
	(SQL Overall)	178691	72	3.546	50392.3