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

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

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.

77 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
handgun	12	4	462	(None)
handguns	13	4	436	1	handguns
handful	14	12	725	2	handful
handout	11	3	1410	2	handout
hangul	10	4	921	2	han_gul
hangup	12	7	729	2	han_gup
hindgut	12	4	501	2	hindgut
wangun	10	3	710	2	wan_gun
adnoun	7	5	703	3	_adnoun
antigun	8	4	796	3	_antigun
candour	10	42	1024	3	candour
cangue	9	10	1244	3	can_gue
dadgum	11	3	458	3	da_dgum
gangue	8	13	1057	3	gan_gue
hadron	10	29	1375	3	ha_dron
hagdon	11	8	828	3	hagd_on
halogen	11	3	839	3	halogen
hand	8	68	3371	3	hand___
handax	17	4	958	3	hand_ax
handbag	14	9	586	3	handbag
handcar	13	3	737	3	handcar
handcuff	20	4	255	3	handcuff
handed	11	49	1998	3	hand_ed
hander	10	45	2643	3	hand_er
handers	11	42	2433	3	handers
handfuls	15	11	575	3	handfuls
handgrip	15	4	380	3	handgrip
handier	11	38	1744	3	handier
handily	14	36	1087	3	handily
handing	12	35	1889	3	handing
handle	10	42	1929	3	hand_le
handled	12	41	1453	3	handled
handler	11	35	1616	3	handler
handles	11	40	2065	3	handles
handling	13	23	1271	3	handling
handoff	17	5	648	3	handoff
handouts	12	3	823	3	handouts
hands	9	53	2738	3	hand__s
handsaw	14	3	553	3	handsaw
handsel	11	30	872	3	handsel
handset	11	30	1682	3	handset
handsewn	15	4	362	3	handsewn
handsful	15	4	408	3	handsful
handy	12	55	2087	3	hand__y
handyman	17	4	523	3	handyman
handymen	17	4	498	3	handymen
hang	8	55	3555	3	han_g__
hangar	10	41	1451	3	han_gar
hangdog	13	4	313	3	hangdog
hanged	11	42	2239	3	han_ged
hanger	10	40	2325	3	han_ger
hanging	12	35	1870	3	han_ging
hangman	13	3	781	3	hangman
hangmen	13	3	738	3	hangmen
hangout	11	4	1139	3	hangout
hangs	9	57	2672	3	han_g_s
hangups	13	6	481	3	han_gups
hanuman	12	3	713	3	hanuman
harden	10	57	1853	3	hard_en
hardpan	13	3	644	3	hardpan
hindguts	13	4	301	3	hindguts
landau	7	3	1061	3	landau_
landaus	8	3	1034	3	landaus
landman	10	3	892	3	landman
landmen	10	3	855	3	landmen
langue	7	10	1217	3	lan_gue
langur	7	10	930	3	lan_gur
nandin	7	3	1303	3	nand_in
pandour	10	40	821	3	pandour
pangen	9	41	1591	3	pan_gen
randan	7	3	1525	3	rand_an
sandbur	10	10	535	3	sandbur
sandman	10	3	1017	3	sandman
sandmen	10	3	941	3	sandmen
wangan	10	3	1122	3	wan_gan
wanguns	11	3	502	3	wan_guns
wanigan	11	3	521	3	wanigan

Search took 7 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	134027	0.403	443402.0
2	DLD Change Limit	134027	77	6.096	21986.1
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	6.529	27368.8