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

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

79 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
endgame	11	4	523	(None)
endgames	12	4	542	1	endgames
endogamy	15	4	298	2	endogamy
enflame	12	3	657	2	enflame
enframe	12	4	736	2	enframe
engage	8	28	1210	2	en_gage
beldame	12	3	723	3	beld_ame
bename	10	33	1607	3	ben__ame
dame	7	71	4031	3	__d_ame
degame	10	27	1318	3	_degame
edge	6	57	1968	3	e_dg__e
enamel	8	12	1011	3	en__amel
enate	5	44	2815	3	en__ate
encage	9	37	1350	3	en_cage
encamp	12	3	594	3	en_camp
encase	8	37	1436	3	en_case
enchase	12	3	947	3	enchase
enclave	12	5	753	3	enclave
endamage	12	4	331	3	endamage
endameba	13	5	293	3	end_ameba
endash	10	29	712	3	end_ash
endear	7	41	1001	3	endea_r
endeared	10	3	805	3	endeared
endears	8	37	1005	3	endears
endite	7	38	1759	3	end_ite
endive	10	33	1047	3	end_ive
endnote	8	5	574	3	endnote
endogamic	15	4	407	3	endogamic
endogamies	14	4	424	3	endogamies
endorse	8	7	920	3	endorse
endosome	11	4	680	3	endosome
endpaper	13	4	388	3	endpaper
endplate	11	4	708	3	endplate
endue	6	42	1535	3	end__ue
endure	7	40	1414	3	end_ure
endways	14	4	444	3	endways
endwise	11	3	646	3	endwise
enface	11	25	1035	3	en_face
enflamed	14	5	572	3	enflamed
enflames	13	5	704	3	enflames
enframed	14	6	626	3	enframed
enframes	13	5	745	3	enframes
engaged	10	37	983	3	en_gaged
engager	9	27	860	3	en_gager
engages	9	29	1249	3	en_gages
engine	7	11	1486	3	en_gine
engram	9	3	1065	3	engram_
engramme	13	4	405	3	engramme
engrams	10	3	807	3	engrams
engrave	11	3	713	3	engrave
enigma	9	3	564	3	enig_ma
enigmas	10	4	517	3	enigmas
enlace	8	22	1323	3	en_lace
enolase	7	3	1019	3	enolase
enplane	9	3	972	3	enplane
enrage	7	27	1507	3	en_rage
enslave	10	3	627	3	enslave
ensnare	7	6	712	3	ensnare
enzyme	20	5	434	3	en_zyme
ergate	7	3	1514	3	e_rgate
exogamy	20	4	280	3	exogamy
game	7	66	4432	3	___game
gendarme	12	4	352	3	gendarme
headgate	13	4	648	3	headgate
indagate	10	4	719	3	indagate
inflame	12	5	696	3	inflame
ingate	7	30	1824	3	in_gate
madame	11	3	985	3	mad_ame
name	6	56	3741	3	_n__ame
negate	7	29	1557	3	_negate
nongame	10	3	818	3	nongame
penname	11	32	855	3	pen_name
pregame	12	3	955	3	pregame
rename	8	27	1881	3	ren__ame
renegade	10	4	513	3	renegade
undrape	10	4	933	3	undrape
untame	8	25	1360	3	un_tame
vendace	13	5	736	3	vend_ace
xenogamy	21	4	249	3	xenogamy

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.436	409841.7
2	DLD Change Limit	134027	79	5.876	22809.2
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	6.342	28175.8