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

Here are the results of your fuzzy-string dictionary search for “clippers” 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
clippers	14	36	884	(None)
chippers	17	35	1088	1	chippers
clappers	14	33	1083	1	clappers
clipper	13	37	1032	1	clipper_
flippers	15	33	800	1	flippers
lippers	11	34	1644	1	_lippers
slippers	12	37	1123	1	slippers
calipers	12	4	944	2	cali_pers
cappers	13	44	1940	2	c_appers
chipper	16	39	1258	2	chipper_
chirpers	15	35	813	2	chirpers
choppers	17	41	1046	2	choppers
ciphers	14	37	999	2	c_iphers
clampers	14	32	1189	2	clampers
clapper	13	40	1186	2	clapper_
claspers	12	44	1091	2	claspers
clickers	16	39	1020	2	clickers
climbers	14	31	841	2	climbers
clingers	11	38	1066	2	clingers
clinkers	14	33	983	2	clinkers
clipped	14	43	983	2	clippe_d
clivers	12	34	1175	2	cli_vers
coppers	13	35	1975	2	c_oppers
crappers	14	40	1102	2	crappers
crimpers	14	31	893	2	crimpers
cripplers	15	31	499	2	cripplers
crispers	12	30	944	2	crispers
croppers	14	33	1148	2	croppers
cruppers	14	31	732	2	cruppers
cuppers	13	37	1221	2	c_uppers
dippers	12	36	1518	2	_dippers
drippers	13	32	794	2	drippers
eclipsers	13	4	264	2	eclipsers
flappers	15	38	838	2	flappers
flipper	14	38	914	2	flipper_
floppers	15	33	746	2	floppers
gippers	12	32	1208	2	_gippers
grippers	13	35	813	2	grippers
kippers	15	32	1143	2	_kippers
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
nippers	11	30	1262	2	_nippers
quippers	21	8	481	2	quippers
rippers	11	41	1503	2	_rippers
shippers	15	30	1231	2	shippers
sippers	11	31	1775	2	_sippers
skippers	16	31	820	2	skippers
slappers	12	37	1095	2	slappers
slipper	11	37	1298	2	slipper_
slippery	15	27	586	2	slippery
snippers	12	29	972	2	snippers
tippers	11	34	1435	2	_tippers
trippers	12	32	1016	2	trippers
whippers	18	32	904	2	whippers
zippers	20	33	1038	2	_zippers

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	121059	0.390	458182.1
2	DLD Change Limit	121059	59	3.640	33258.0
3	Display Results	59	59	0.033	1787.9
	(SQL Overall)	178691	59	4.063	43980.1