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

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

51 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
plumber	13	33	998	(None)
clumber	13	40	1144	1	clumber
lumber	10	38	1777	1	_lumber
plumbed	14	31	727	1	plumbed
plumbers	14	41	851	1	plumbers
plumbery	17	31	553	1	plumbery
plumier	11	35	1004	1	plumier
plummer	13	29	852	1	plummer
plumper	13	31	877	1	plumper
slumber	11	38	1100	1	slumber
blubber	10	39	929	2	blubber
clamber	13	33	1174	2	clamber
climber	13	44	913	2	climber
clubber	13	31	959	2	clubber
clumbers	14	39	1041	2	clumbers
crumber	13	33	964	2	crumber
cumber	12	40	1670	2	_cumber
dumber	11	44	1417	2	_dumber
flubber	14	28	771	2	flubber
glummer	12	41	798	2	glummer
lamber	10	44	1849	2	_lamber
limber	10	43	1679	2	_limber
lubber	10	42	1462	2	_lubber
lumbar	10	36	1059	2	_lumbar
lumbers	11	38	1591	2	_lumbers
lumper	10	38	1665	2	_lumper
number	10	39	1322	2	_number
plucker	15	36	824	2	plucker
plugger	11	37	843	2	plugger
plumb	11	45	1407	2	plumb__
plumbic	15	4	396	2	plumbic
plumbs	12	45	933	2	plumb_s
plumbum	15	4	373	2	plumbum
plume	9	48	1946	2	plum_e_
plumed	11	44	1288	2	plum_ed
plumes	10	43	1813	2	plum_es
plummet	13	27	835	2	plummet
plummier	14	3	412	2	plummier
plumped	14	31	864	2	plumped
plumpen	13	27	640	2	plumpen
plumpers	14	35	729	2	plumpers
plunder	10	38	1050	2	plunder
plunger	10	42	1124	2	plunger
plunker	13	39	1065	2	plunker
plusher	12	40	1038	2	plusher
pumper	12	44	1555	2	p_umper
slubber	11	30	1076	2	slubber
slumbers	12	31	1027	2	slumbers
slumbery	15	29	604	2	slumbery
slummer	11	37	1120	2	slummer
umber	9	46	1759	2	__umber

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.360	496363.9
2	DLD Change Limit	107671	51	3.203	33615.7
3	Display Results	51	51	0.013	3923.1
	(SQL Overall)	178691	51	3.576	49969.5