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

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

53 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
niffer	12	37	844	(None)
differ	13	39	1084	1	differ
niffers	13	28	736	1	niffers
sniffer	13	31	890	1	sniffer
biffed	15	44	988	2	biffed
buffer	14	45	1268	2	buffer
coffer	14	41	1286	2	coffer
deffer	13	44	1130	2	deffer
differs	14	33	997	2	differs
doffer	13	39	1135	2	doffer
duffer	13	47	1166	2	duffer
fifer	11	55	1997	2	fi_fer
gaffer	13	43	1013	2	gaffer
goffer	13	40	951	2	goffer
iffier	12	3	676	2	_iffier
infer	8	42	1503	2	_infer
knifer	13	59	856	2	kni_fer
liefer	9	52	957	2	liefer
lifer	8	58	2215	2	li_fer
lifter	9	38	1481	2	lifter
miffed	15	39	871	2	miffed
miffier	15	3	702	2	miffier
naffed	13	40	833	2	naffed
nicer	7	46	1829	2	ni_cer
nicker	12	38	1870	2	nicker
niffered	15	4	414	2	niffered
niftier	10	32	871	2	niftier
nigger	8	97	1357	2	nigger
nigher	10	36	1275	2	nigher
nipper	10	37	1571	2	nipper
niter	5	50	2897	2	ni_ter
offer	11	43	1138	2	_offer
piaffer	15	10	444	2	piaffer
pilfer	11	3	916	2	pilfer
puffer	14	46	1073	2	puffer
rifer	8	47	2198	2	ri_fer
riffed	13	38	1156	2	riffed
riffler	13	32	835	2	riffler
rifler	9	40	1426	2	rifler
sifter	9	45	1623	2	sifter
sniffed	14	31	818	2	sniffed
sniffers	14	25	712	2	sniffers
sniffier	14	35	664	2	sniffier
sniffler	14	29	683	2	sniffler
snifter	10	34	962	2	snifter
snuffer	13	31	885	2	snuffer
stiffer	13	31	939	2	stiffer
suffer	12	43	1451	2	suffer
tiffed	13	36	839	2	tiffed
titfer	9	40	952	2	titfer
unifier	10	22	1186	2	unifier
whiffer	19	10	532	2	whiffer
zaffer	21	39	715	2	zaffer

Search took 3 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.346	516448.0
2	DLD Change Limit	82551	53	2.140	38575.2
3	Display Results	53	53	0.016	3312.5
	(SQL Overall)	178691	53	2.502	71419.3