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

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

85 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
defunct	13	4	577	(None)
deduct	10	6	1079	2	dedu_ct
defect	12	48	1617	2	def_ect
defence	13	3	989	2	defence
deflect	13	39	997	2	deflect
defund	11	44	798	2	defun_d
defunds	12	37	675	2	defunds
adjunct	17	5	358	3	adjunct
bedunce	12	3	568	3	bedunce
daunt	6	59	2908	3	d_aun_t
debunk	13	6	511	3	debun_k
debunks	14	3	376	3	debunks
debut	8	60	2414	3	debu__t
decant	9	35	2422	3	decan_t
decency	15	3	745	3	decency
decent	9	40	2370	3	decen_t
decoct	11	3	1378	3	de_coct
deduce	10	7	925	3	dedu_ce
deducts	11	6	659	3	dedu_cts
deface	12	31	1386	3	def_ace
defang	11	3	775	3	defan_g
defangs	12	3	536	3	defangs
defat	9	54	2669	3	def__at
default	11	4	789	3	default
defeat	10	38	1716	3	def_eat
defects	13	45	1152	3	def_ects
defenced	15	3	720	3	defenced
defences	14	3	963	3	defences
defend	11	39	1049	3	defen_d
defends	12	35	877	3	defends
defense	11	3	750	3	defense
deffest	14	30	881	3	deffest
defiance	14	7	763	3	defiance
defiant	11	3	1192	3	defiant
deficit	13	3	968	3	deficit
define	10	47	1814	3	defin_e
defined	12	38	1382	3	defined
definer	11	44	1377	3	definer
defines	11	41	1868	3	defines
definite	12	3	933	3	definite
deflects	14	33	673	3	deflects
deforce	13	26	724	3	deforce
defrock	17	4	464	3	defrock
defrost	11	3	955	3	defrost
deft	8	55	4022	3	def___t
deftest	11	26	1171	3	deftest
defuel	10	34	893	3	defu_el
defuels	11	29	698	3	defuels
defunded	14	3	516	3	defunded
defuse	10	57	1272	3	defu_se
defused	12	52	1109	3	defused
defuser	11	51	1050	3	defuser
defuses	11	48	1459	3	defuses
defuze	19	48	784	3	defu_ze
defuzed	21	44	704	3	defuzed
defuzes	20	39	830	3	defuzes
degust	8	3	1025	3	degu_st
deject	16	45	1284	3	de_ject
delict	9	43	2033	3	de_lict
dement	9	38	2515	3	demen_t
demount	10	4	974	3	demoun_t
denounce	11	4	510	3	denounce
dent	5	71	5841	3	de__n_t
depict	11	35	1479	3	de_pict
detect	9	42	1740	3	de_tect
detent	7	36	2448	3	deten_t
detract	10	14	1463	3	detract
deuce	8	45	1749	3	de_u_ce
dezinc	18	3	605	3	dezinc_
dezincs	19	3	375	3	dezincs
disjunct	18	4	396	3	disjunct
duct	7	57	3546	3	d__u_ct
dunce	8	63	1926	3	d__unce
dunch	11	53	1626	3	d__unch
dunt	5	57	4687	3	d__un_t
educt	8	50	1710	3	_edu_ct
effect	14	3	744	3	_effect
eruct	7	40	2235	3	_eru_ct
refect	11	43	1933	3	ref_ect
refence	12	3	1224	3	refence
reflect	12	39	1371	3	reflect
refract	12	13	1160	3	refract
refund	10	48	1030	3	refun_d
refunds	11	44	862	3	refunds
reluct	8	39	1611	3	relu_ct

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	85	6.486	20664.0
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	6.919	25826.1