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

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

59 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
defaulting	15	4	339	(None)
defatting	14	3	610	2	defa_tting
desalting	11	3	884	2	desa_lting
faulting	12	23	773	2	__faulting
assaulting	11	4	292	3	assaulting
befalling	15	22	650	3	befa_lling
befouling	15	3	498	3	befoul_ing
daunting	10	33	1040	3	d__aunting
dauting	9	38	1476	3	d__au_ting
dealing	9	43	2323	3	de_a_l_ing
debating	12	32	1373	3	deba__ting
debauching	19	4	247	3	debauching
debuting	12	26	863	3	de_bu_ting
decanting	13	25	1063	3	deca_nting
deducting	14	3	684	3	de_ducting
defacing	15	23	868	3	defa__cing
defalcating	18	4	434	3	defalcating
defaming	15	23	846	3	defa__ming
defanging	15	3	533	3	defa_nging
default	11	4	789	3	default___
defaulted	14	4	331	3	default_ed
defaulter	13	4	313	3	default_er
defaulters	14	4	238	3	defaulters
defaults	12	4	333	3	default__s
defeating	14	23	1197	3	def_eating
defecating	17	23	778	3	defecating
defecting	16	25	1022	3	def_ecting
defiling	13	28	1246	3	def_il_ing
deflating	14	26	1071	3	def_lating
deflecting	17	3	650	3	deflecting
defrauding	16	4	292	3	defrau_ding
defrosting	15	4	449	3	defrosting
defueling	14	25	509	3	def_ueling
defuelling	15	7	354	3	defuelling
defunding	15	21	612	3	def_unding
defusing	13	22	793	3	def_u_sing
defuzing	22	19	525	3	def_u_zing
degaussing	13	4	229	3	degaussing
degusting	12	3	616	3	de_gusting
delating	10	31	1960	3	dela__ting
demasting	13	3	845	3	dema_sting
demounting	14	4	496	3	demounting
depainting	14	15	615	3	depainting
departing	13	4	951	3	depa_rting
deputing	12	23	879	3	de_pu_ting
derailing	11	20	1131	3	derail_ing
derating	10	32	2228	3	dera__ting
deratting	11	3	951	3	dera_tting
detailing	11	25	1041	3	detail_ing
devaluating	16	4	505	3	devaluating
devaluing	14	3	483	3	deva_luing
effulging	17	4	215	3	_effulging
exalting	16	3	803	3	_exa_lting
exulting	16	3	764	3	_e_xulting
refalling	13	20	1042	3	refa_lling
refuting	12	19	1190	3	ref_u_ting
resaluting	11	3	739	3	resaluting
resulting	10	3	1108	3	re_sulting
vaulting	12	22	722	3	__vaulting

Search took 6 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	140603	0.423	422437.4
2	DLD Change Limit	140603	59	5.453	25784.5
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	5.906	30255.8