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

Here are the results of your fuzzy-string dictionary search for “humbuggers” with Change Limit: [1] [2] [3] [4] [5]

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.

78 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
humbuggers	19	5	182	(None)
humbugger	18	5	190	1	humbugger_
humbuggery	22	5	123	1	humbuggery
hamburgers	18	13	266	2	hamburgers
humbugged	19	4	176	2	humbugge_d
humbuggeries	21	6	113	2	humbuggeries
buggers	11	43	1566	3	___buggers
debuggers	14	4	271	3	_debuggers
hamburger	17	11	310	3	hamburger_
huggers	12	42	1159	3	h___uggers
humblers	15	37	980	3	humb__lers
humbugging	20	5	140	3	humbugging
humbugs	15	3	424	3	humbu_g__s
humdingers	17	4	212	3	humdingers
muggers	11	36	1193	3	__m_uggers
ambushers	16	4	343	4	_ambushers
baggers	11	39	1569	4	___baggers
budgers	11	43	1492	4	___budgers
bugger	10	44	1872	4	___bugger_
buggery	14	36	793	4	___buggery
buglers	10	51	1532	4	___buglers
bulgers	10	52	1514	4	___bulgers
bumblers	14	37	1073	4	bumb__lers
burgers	10	39	1857	4	___burgers
chuggers	15	5	486	4	__chuggers
cumberers	15	17	600	4	cumb_erers
cumbers	13	45	1541	4	cumb___ers
debugger	13	4	312	4	_debugger_
fumblers	15	31	871	4	fumb__lers
hamburgs	16	4	348	4	hamburg__s
harbingers	16	4	394	4	harbingers
hiphugger	19	5	137	4	hiphugger_
hoggers	12	45	1248	4	h___oggers
homagers	14	8	683	4	hom__agers
homburgs	16	4	274	4	homburg__s
hotdoggers	16	5	193	4	hotdoggers
hugger	11	47	1312	4	h___ugger_
humanizers	24	4	395	4	humanizers
humblebees	19	5	210	4	humblebees
humbleness	17	4	462	4	humbleness
humbler	14	34	1194	4	humb__ler_
humbles	14	32	1580	4	humb__le_s
humbug	14	3	480	4	humbu_g___
humdinger	16	4	218	4	humdinger_
hummers	14	38	1306	4	hum___mers
hummuses	15	4	445	4	hummu_se_s
humours	12	8	644	4	humou___rs
humpers	14	27	1352	4	hum___pers
humungous	15	5	208	4	hum_ungous
humuses	12	3	760	4	hum_u_se_s
hungers	11	40	1330	4	h___ungers
husbanders	16	5	291	4	husbanders
impugners	14	57	347	4	_impugners
jumblers	19	35	832	4	jumb__lers
luggers	9	37	1348	4	___luggers
lumberers	13	19	601	4	lumb_erers
lumbers	11	38	1591	4	lumb___ers
muggars	11	31	664	4	__m_uggars
muggees	11	33	888	4	__m_uggees
mugger	10	39	1470	4	__m_ugger_
muggurs	11	31	510	4	__m_uggurs
mumblers	14	32	876	4	mumb__lers
numberers	13	16	515	4	numb_erers
numbers	11	37	1124	4	numb___ers
outbulges	12	13	474	4	outbulge_s
outriggers	12	4	296	4	outriggers
pluggers	12	29	702	4	__pluggers
ruggers	9	46	1231	4	___ruggers
rumblers	12	36	1074	4	rumb__lers
rummagers	14	4	303	4	rum_magers
rumrunners	12	5	136	4	rumrunners
sluggers	10	34	848	4	__sluggers
smugger	11	32	705	4	_sm_ugger_
smugglers	13	26	343	4	_sm_ugglers
tuggers	9	37	1144	4	___tuggers
tumblers	12	31	1062	4	tumb__lers
umbers	10	42	1521	4	_umb___ers
umbrages	13	3	662	4	_umbrage_s

Search took 10 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	161450	0.453	394461.4
2	DLD Change Limit	161450	78	9.296	17367.7
3	Display Results	78	78	0.033	2363.6
	(SQL Overall)	178691	78	9.782	18267.3