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

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

57 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
chomper	16	38	1007	(None)
champer	16	38	1340	1	champer
chomped	17	32	977	1	chomped
chompers	17	36	957	1	chompers
chopper	16	36	1189	1	chopper
camper	12	47	2221	2	c_amper
chamber	16	40	1105	2	chamber
chamfer	17	39	985	2	chamfer
champed	17	41	1147	2	champed
champers	17	33	1161	2	champers
cheaper	14	40	1058	2	cheaper
cheeper	14	36	1074	2	cheeper
chimer	13	55	1720	2	chim_er
chipper	16	39	1258	2	chipper
chirper	14	35	996	2	chirper
choicer	14	19	789	2	choicer
choker	15	43	1437	2	cho_ker
chokier	16	3	804	2	chokier
choler	11	37	1715	2	cho_ler
chomp	14	48	1566	2	chomp__
chomps	15	51	1222	2	chomp_s
chooser	12	44	1296	2	chooser
chopped	17	45	1100	2	chopped
choppers	17	41	1045	2	choppers
choppier	17	28	664	2	choppier
chouser	12	52	1294	2	chouser
chowder	16	38	780	2	chowder
chromier	15	3	803	2	chromier
chumped	17	37	949	2	chumped
clamper	13	40	1299	2	clamper
clomped	14	39	897	2	clomped
comber	12	51	1850	2	c_omber
comer	9	58	3269	2	c_om_er
comped	13	59	1987	2	c_omped
compeer	13	38	1155	2	c_ompeer
compel	12	44	1289	2	c_ompel
compere	13	46	1662	2	c_ompere
cooper	10	42	2112	2	c_ooper
coper	9	53	3609	2	c_o_per
copper	12	43	2189	2	c_opper
crimper	13	65	1042	2	crimper
cropper	13	33	1296	2	cropper
hamper	13	45	1865	2	_hamper
homer	10	58	2845	2	_hom_er
homier	11	64	1699	2	_homier
hooper	11	45	1831	2	_hooper
hoper	10	58	2914	2	_ho_per
hopper	13	42	1848	2	_hopper
humper	13	41	1588	2	_humper
romper	10	42	1368	2	_romper
shopper	14	33	1262	2	shopper
stomper	11	41	1122	2	stomper
thumper	14	35	695	2	thumper
whimper	17	29	772	2	whimper
whomped	18	34	547	2	whomped
whooper	15	29	715	2	whooper
whopper	17	32	850	2	whopper

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.140	1276364.3
2	DLD Change Limit	107671	57	3.640	29579.9
3	Display Results	57	57	0.016	3562.5
	(SQL Overall)	178691	57	3.796	47073.5