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

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

71 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
croppers	14	33	1148	(None)
choppers	17	41	1045	1	choppers
coppers	13	35	1975	1	c_oppers
crappers	14	40	1102	1	crappers
cropper	13	33	1296	1	cropper_
cruppers	14	31	731	1	cruppers
droppers	13	31	859	1	droppers
boppers	13	39	1192	2	_boppers
cappers	13	44	1940	2	c_appers
cartoppers	16	4	373	2	cartoppers
chippers	17	35	1087	2	chippers
chompers	17	36	957	2	chompers
chopper	16	36	1189	2	chopper_
clappers	14	33	1083	2	clappers
clippers	14	36	883	2	clippers
coopers	11	40	1948	2	c_oopers
copers	10	46	2984	2	c_o_pers
copiers	11	42	1596	2	c_opiers
copper	12	43	2189	2	c_opper_
copperas	14	30	856	2	c_opperas
coppery	16	40	939	2	c_oppery
copters	11	36	2127	2	c_opters
crapper	13	39	1319	2	crapper_
creepers	12	31	862	2	creepers
crimpers	14	31	893	2	crimpers
cripplers	15	31	499	2	cripplers
crispers	12	30	943	2	crispers
croakers	14	28	850	2	croakers
crofters	13	35	889	2	crofters
crooners	10	39	1139	2	crooners
cropless	12	3	779	2	cropless
cropped	14	38	1206	2	croppe_d
croppies	14	31	1113	2	croppies
crosiers	10	33	1205	2	crosiers
crossers	10	39	1269	2	crossers
croupes	11	46	1310	2	croupe_s
croupiers	13	3	463	2	croupiers
crowders	14	39	879	2	crowders
crowers	12	46	1489	2	cro_wers
crowners	13	37	1074	2	crowners
crozers	18	41	1108	2	cro_zers
croziers	19	28	700	2	croziers
crupper	13	33	856	2	crupper_
cuppers	13	37	1219	2	c_uppers
drippers	13	32	793	2	drippers
dropper	12	32	987	2	dropper_
floppers	15	33	746	2	floppers
grippers	13	35	812	2	grippers
gropers	10	48	1385	2	gro_pers
groupers	11	35	863	2	groupers
hoppers	14	31	1514	2	_hoppers
loppers	11	30	1410	2	_loppers
moppers	13	34	1245	2	_moppers
poppers	10	34	1486	2	_poppers
propers	11	36	1903	2	pro_pers
prospers	12	30	1225	2	prospers
rappers	11	36	1844	2	_rappers
rippers	11	41	1502	2	_rippers
rompers	11	34	1224	2	_rompers
ropers	8	43	2590	2	_ro_pers
scrappers	15	4	584	2	scrappers
shoppers	15	30	1075	2	shoppers
stoppers	12	39	1057	2	stoppers
stroppers	13	5	670	2	stroppers
toppers	11	39	1460	2	_toppers
trappers	12	37	1102	2	trappers
trippers	12	32	1015	2	trippers
troopers	10	28	942	2	troopers
troupers	10	35	942	2	troupers
whoppers	18	29	753	2	whoppers
wrappers	15	30	693	2	wrappers

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.156	1145455.1
2	DLD Change Limit	121059	71	4.546	26629.8
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	4.732	37762.3