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

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

79 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
nippers	11	30	1262	(None)
dippers	12	36	1518	1	dippers
gippers	12	32	1208	1	gippers
kippers	15	32	1143	1	kippers
lippers	11	34	1644	1	lippers
nappers	11	42	1486	1	nappers
nipper	10	37	1571	1	nipper_
rippers	11	41	1503	1	rippers
sippers	11	31	1775	1	sippers
snippers	12	29	972	1	snippers
tippers	11	34	1435	1	tippers
zippers	20	33	1038	1	zippers
boppers	13	39	1192	2	boppers
cappers	13	44	1940	2	cappers
chippers	17	35	1088	2	chippers
ciphers	14	37	999	2	ciphers
clippers	14	36	884	2	clippers
coppers	13	35	1975	2	coppers
cuppers	13	37	1221	2	cuppers
diapers	10	47	1391	2	diapers
dipper	11	40	1779	2	dipper_
drippers	13	32	794	2	drippers
flippers	15	33	800	2	flippers
gipper	11	42	1530	2	gipper_
grippers	13	35	813	2	grippers
gyppers	15	23	550	2	gyppers
hipper	13	38	1802	2	hipper_
hoppers	14	31	1514	2	hoppers
kipper	14	34	1421	2	kipper_
knappers	16	31	564	2	knappers
lappers	11	37	1746	2	lappers
limpers	11	38	1522	2	limpers
lippens	11	32	853	2	lippens
lipper	10	42	1963	2	lipper_
lispers	9	45	1432	2	lispers
loppers	11	30	1410	2	loppers
mappers	13	33	1378	2	mappers
moppers	13	34	1246	2	moppers
napper	10	37	1828	2	napper_
nappes	10	45	1562	2	nappe_s
nickers	13	44	1509	2	nickers
niffers	13	28	736	2	niffers
niggers	9	31	1132	2	niggers
nipped	11	36	1585	2	nippe_d
nippier	11	31	983	2	nippier_
nipples	11	31	966	2	nipples
niters	6	46	2421	2	ni_ters
peppers	10	33	1144	2	peppers
pipers	10	43	1866	2	pi_pers
poppers	10	34	1486	2	poppers
quippers	21	8	481	2	quippers
rappers	11	36	1844	2	rappers
ripper	10	35	1865	2	ripper_
ripplers	12	33	711	2	ripplers
sappers	11	35	1890	2	sappers
shippers	15	30	1231	2	shippers
simpers	11	30	1412	2	simpers
sipper	10	39	2099	2	sipper_
sippets	11	33	1018	2	sippets
skippers	16	31	820	2	skippers
slippers	12	37	1123	2	slippers
snappers	12	35	1017	2	snappers
snipers	9	33	1177	2	sni_pers
snipper	11	39	1133	2	snipper_
snippets	12	22	562	2	snippets
suppers	11	33	1470	2	suppers
tappers	11	34	1654	2	tappers
tipper	10	39	1841	2	tipper_
tippets	11	33	937	2	tippets
tipplers	12	33	635	2	tipplers
toppers	11	39	1460	2	toppers
trippers	12	32	1016	2	trippers
uppers	10	29	1229	2	_uppers
vipers	11	49	1453	2	vi_pers
whippers	18	32	904	2	whippers
wipers	11	54	1608	2	wi_pers
yappers	14	40	1225	2	yappers
zappers	20	39	1163	2	zappers
zipper	19	38	1312	2	zipper_

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.123	1452772.4
2	DLD Change Limit	107671	79	3.326	32372.5
3	Display Results	79	79	0.016	4937.5
	(SQL Overall)	178691	79	3.465	51570.3