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

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

45 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
crumbers	14	33	824	(None)
clumbers	14	39	1041	1	clumbers
crumber	13	33	964	1	crumber_
cumbers	13	45	1541	1	c_umbers
cambers	13	40	1744	2	c_ambers
chambers	17	34	1062	2	chambers
clambers	14	42	1129	2	clambers
climbers	14	31	841	2	climbers
clubbers	14	37	858	2	clubbers
clumber	13	40	1144	2	clumber_
combers	13	45	1662	2	c_ombers
crabbers	14	35	875	2	crabbers
crambes	13	3	996	2	crambe_s
crammers	14	36	935	2	crammers
cribbers	14	30	644	2	cribbers
crimmers	14	29	854	2	crimmers
crimpers	14	31	893	2	crimpers
cruisers	10	43	827	2	cruisers
crullers	10	4	730	2	crullers
crumbed	14	37	847	2	crumbe_d
crumbier	14	5	636	2	crumbier_
crumbles	14	32	968	2	crumbles
crumbs	12	40	923	2	crumb__s
crumbums	16	4	273	2	crumbums
crumpets	14	33	594	2	crumpets
cruppers	14	31	732	2	cruppers
crushers	13	40	1009	2	crushers
cubers	10	53	1835	2	c_u_bers
cucumbers	17	4	249	2	cucumbers
cumber	12	40	1670	2	c_umber_
cummers	13	37	1348	2	c_ummers
curbers	11	55	1438	2	c_urbers
drubbers	13	38	603	2	drubbers
drummers	13	31	616	2	drummers
grubbers	13	31	620	2	grubbers
grumblers	14	24	502	2	grumblers
lumbers	11	38	1591	2	_lumbers
numbers	11	37	1124	2	_numbers
plumbers	14	41	851	2	plumbers
rubbers	11	39	1319	2	_rubbers
rumblers	12	36	1074	2	_rumblers
rummers	11	35	1365	2	_rummers
scrubbers	15	4	337	2	scrubbers
slumbers	12	31	1027	2	slumbers
umbers	10	42	1521	2	__umbers

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	121059	0.403	443402.0
2	DLD Change Limit	121059	45	3.423	35366.3
3	Display Results	45	45	0.033	1363.6
	(SQL Overall)	178691	45	3.859	46305.0