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

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

89 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
deficits	14	4	727	(None)
deficit	13	3	967	1	deficit_
defects	13	45	1152	2	defec_ts
deficients	16	4	432	2	deficients
definite	12	3	932	2	definite
delicts	10	40	1225	2	delic_ts
delimits	11	3	757	2	delimits
depicts	12	35	846	2	depic_ts
elicits	9	3	1123	2	_elicits
befits	11	47	1150	3	bef__its
debility	14	4	863	3	debility
debits	9	42	1450	3	de__bits
deceits	10	28	1088	3	de_ceits
decocts	12	3	783	3	decoc_ts
dedicate	12	3	1280	3	dedicate
dedicates	13	3	1169	3	dedicates
deducts	11	6	659	3	deduc_ts
defacers	14	23	799	3	defacers
defaces	13	32	1340	3	defac_es
defacing	15	23	868	3	defacing
defats	10	51	1455	3	def__ats
defaults	12	4	333	3	defaults
defeats	11	35	1123	3	def_eats
defecate	14	3	879	3	defecate
defecates	15	3	859	3	defecates
defect	12	48	1617	3	defec_t_
defiant	11	3	1192	3	defiant_
deficient	15	4	702	3	deficient
defiers	11	39	1399	3	defi_ers
defies	10	46	2405	3	def__ies
defilers	12	43	947	3	defilers
defiles	11	40	1684	3	defi_les
defiling	13	28	1246	3	defiling
definers	12	42	1119	3	definers
defines	11	41	1868	3	defi_nes
definiens	13	4	530	3	definiens
defining	13	37	1180	3	defining
defis	9	67	1750	3	def__i_s
deflects	14	33	673	3	deflects
defocus	13	3	528	3	defoc_us
defrosts	12	4	483	3	defrosts
deicers	10	36	1273	3	de_icers
deices	9	41	1937	3	de_ic_es
deicide	11	4	940	3	de_icide
deicides	12	4	930	3	de_icides
deicing	11	3	1219	3	de_icing
deictic	12	3	770	3	de_ictic
deictics	13	4	556	3	de_ictics
deifies	11	33	1745	3	de_ifies
deists	7	49	1643	3	de_i_sts
deities	8	26	2192	3	de_ities
deixis	14	3	724	3	de_ixi_s
dejects	17	38	922	3	dejec_ts
delicate	11	3	1549	3	delicate
delicates	12	3	1431	3	delicates
delicious	12	4	671	3	delicious
delict	9	43	2033	3	delic_t_
delights	13	4	733	3	delights
delimit	10	3	1173	3	delimit_
delists	8	44	1417	3	deli_sts
demerits	11	3	1076	3	demerits
demits	9	49	1807	3	de__mits
deorbits	11	4	461	3	deorbits
depict	11	35	1479	3	depic_t_
deposits	11	3	884	3	deposits
desists	8	36	1172	3	desi_sts
detects	10	40	1109	3	detec_ts
deticks	14	3	735	3	detic_ks
deviants	12	3	673	3	deviants
devices	13	32	1258	3	devic_es
dicots	9	49	1579	3	d__icots
digits	8	41	1453	3	d__igits
dixits	14	42	1031	3	d__ixits
domicils	13	4	507	3	domicils
edicts	9	49	1170	3	_edic_ts
elicit	8	4	1720	3	_elicit_
evicts	11	36	855	3	_evic_ts
felicity	16	4	791	3	felicity
ficins	11	35	1398	3	__ficins
helicity	16	4	850	3	helicity
penicils	12	4	786	3	penicils
recits	8	36	2135	3	re__cits
refects	12	40	1274	3	refec_ts
refights	15	5	588	3	refights
refits	9	40	1765	3	ref__its
relicts	9	44	1459	3	relic_ts
revisits	11	3	742	3	revisits
sericins	10	3	1246	3	sericins
solicits	10	3	1102	3	solicits

Search took 9 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	146162	0.420	425454.8
2	DLD Change Limit	146162	89	7.533	19402.9
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	7.983	22383.9