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

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

81 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
kippers	15	32	1143	(None)
dippers	12	36	1518	1	dippers
gippers	12	32	1208	1	gippers
kipper	14	34	1421	1	kipper_
lippers	11	34	1644	1	lippers
nippers	11	30	1262	1	nippers
rippers	11	41	1503	1	rippers
sippers	11	31	1775	1	sippers
skippers	16	31	820	1	skippers
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
keepers	13	34	1098	2	keepers
kickers	12	40	1329	2	kickers
kidders	13	39	917	2	kidders
kiers	9	53	2009	2	ki__ers
killers	11	42	1558	2	killers
kilters	11	38	1360	2	kilters
kipped	15	31	1457	2	kippe_d
kippen	14	29	901	2	kippe_n
kippered	17	25	562	2	kippered
kipperer	16	29	472	2	kipperer
kipperers	17	23	382	2	kipperers
kissers	11	42	1129	2	kissers
kiters	10	52	1859	2	ki_ters
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
nappers	11	42	1486	2	nappers
nipper	10	37	1571	2	nipper_
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
skipper	15	33	957	2	skipper_
skippets	16	28	456	2	skippets
slippers	12	37	1123	2	slippers
snippers	12	29	972	2	snippers
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 6 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.376	475242.0
2	DLD Change Limit	107671	81	4.953	21738.5
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	5.359	33344.1