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

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

74 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
blunger	10	41	1201	(None)
bludger	11	41	956	1	bludger
blunder	10	38	1315	1	blunder
blunge	9	43	1148	1	blunge_
blunged	11	43	1013	1	blunged
blungers	11	46	984	1	blungers
blunges	10	42	1222	1	blunges
blunter	9	45	1203	1	blunter
lunger	7	57	2042	1	_lunger
plunger	10	42	1124	1	plunger
banger	9	44	2363	2	b_anger
binger	9	49	2345	2	b_inger
blander	10	37	1516	2	blander
blanker	13	46	1202	2	blanker
blender	10	46	1384	2	blender
blinder	10	39	1298	2	blinder
blinker	13	41	1021	2	blinker
blogger	11	44	831	2	blogger
blonder	10	40	1194	2	blonder
blubber	10	39	929	2	blubber
blucher	14	33	1022	2	blucher
bludge	10	42	1097	2	bludge_
bludged	12	43	931	2	bludged
bludgers	12	39	785	2	bludgers
bludges	11	45	1112	2	bludges
bluer	7	49	1849	2	blu__er
bluffer	15	39	688	2	bluffer
blunders	11	39	1134	2	blunders
blunted	10	42	1066	2	blunted
blurter	9	41	983	2	blurter
blusher	12	41	1311	2	blusher
bluster	9	42	1531	2	bluster
bouncer	11	38	1133	2	bouncer
bounder	10	42	1553	2	bounder
bringer	10	42	1335	2	bringer
budger	10	46	1770	2	b_udger
bugger	10	44	1872	2	b_ugger
bulger	9	49	1735	2	b_ulger
bunged	10	52	1879	2	b_unged
bungee	9	63	1977	2	b_ungee
bungler	10	46	1148	2	b_ungler
bunker	12	45	1937	2	b_unker
bunter	8	50	2038	2	b_unter
burger	9	40	2079	2	b_urger
clanger	10	41	1349	2	clanger
clinger	10	38	1215	2	clinger
clunker	13	41	945	2	clunker
flanger	11	34	1262	2	flanger
flinger	11	37	1051	2	flinger
flunker	14	38	936	2	flunker
grunger	9	38	978	2	grunger
hunger	10	40	1520	2	_hunger
linger	7	52	2600	2	_linger
longer	7	58	2320	2	_longer
lounger	8	46	1021	2	lounger
luger	6	53	2208	2	_lu_ger
lugger	8	39	1655	2	_lugger
lunge	6	53	2380	2	_lunge_
lunged	8	54	1827	2	_lunged
lungee	7	51	1981	2	_lungee
lungers	8	38	1709	2	_lungers
lunges	7	61	2342	2	_lunges
lunier	6	46	1760	2	_lunier
lunker	10	47	1834	2	_lunker
plugger	11	37	843	2	plugger
plunder	10	38	1050	2	plunder
plunge	9	38	1105	2	plunge_
plunged	11	43	952	2	plunged
plungers	11	37	940	2	plungers
plunges	10	40	1161	2	plunges
plunker	13	39	1065	2	plunker
slinger	8	34	1383	2	slinger
slugger	9	36	1068	2	slugger
younger	11	38	716	2	younger

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	74	3.003	35854.5
3	Display Results	74	74	0.013	5692.3
	(SQL Overall)	178691	74	3.156	56619.5