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

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

92 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
dejecta	17	37	636	(None)
deject	16	45	1284	1	deject_
dejects	17	38	922	1	dejects
ejecta	15	33	739	1	_ejecta
defect	12	48	1617	2	defect_
defects	13	45	1152	2	defects
dejected	19	30	759	2	dejected
detect	9	42	1740	2	detect_
detects	10	40	1109	2	detects
eject	14	50	1604	2	_eject_
ejects	15	40	995	2	_ejects
reject	15	41	1628	2	reject_
rejects	16	39	1069	2	rejects
abject	17	13	770	3	abject_
beretta	9	3	846	3	beretta
celesta	9	4	764	3	celesta
cementa	11	28	1054	3	cementa
deceit	9	30	1821	3	deceit_
deceits	10	28	1088	3	deceits
decent	9	40	2370	3	decent_
decoct	11	3	1378	3	decoct_
decocts	12	3	783	3	decocts
deduct	10	6	1079	3	deduct_
deducts	11	6	659	3	deducts
deet	5	73	5658	3	de_e_t_
deets	6	53	3024	3	de_e_ts
defeat	10	38	1716	3	defeat_
defeats	11	35	1123	3	defeats
defecate	14	3	879	3	defecate
defected	15	28	997	3	defected
defector	14	27	795	3	defector
deflect	13	39	997	3	deflect_
deflects	14	33	673	3	deflects
dejecting	20	21	779	3	dejecting
dejection	19	17	866	3	dejection
delectate	12	4	874	3	delectate
delete	7	36	2070	3	dele_te
delict	9	43	2033	3	delict_
delicts	10	40	1225	3	delicts
delta	6	61	1777	3	d__elta
dement	9	38	2515	3	dement_
dementia	11	5	783	3	dementia
dements	10	30	1662	3	dements
depict	11	35	1479	3	depict_
depicts	12	35	846	3	depicts
desert	7	27	2549	3	desert_
deserts	8	25	1305	3	deserts
detected	12	28	973	3	detected
detecter	11	29	873	3	detecter
detector	11	27	832	3	detector
detent	7	36	2448	3	detent_
detente	8	33	1360	3	detente
detents	8	36	1515	3	detents
detest	7	41	2284	3	detest_
detests	8	37	1174	3	detests
devest	10	44	1870	3	devest_
devests	11	44	1047	3	devests
dicta	8	49	1563	3	d__icta
direct	9	38	1733	3	direct_
directs	10	27	1026	3	directs
disject	17	26	867	3	disject_
disjects	18	27	592	3	disjects
egesta	7	42	865	3	_egesta
ejected	17	29	765	3	_ejected
ejector	16	37	860	3	_ejector
elect	7	43	2703	3	_elect_
elects	8	33	1500	3	_elects
erect	7	41	2933	3	_erect_
erects	8	41	1618	3	_erects
exacta	15	33	739	3	_exacta
inject	15	32	1023	3	inject_
injects	16	25	745	3	injects
nepeta	8	3	789	3	nepe_ta
object	17	13	580	3	object_
objects	18	12	369	3	objects
perfecta	15	11	520	3	perfecta
peseta	8	3	1057	3	pese_ta
recta	7	42	2026	3	__recta
reeject	16	34	962	3	reeject_
reejects	17	33	608	3	reejects
refect	11	43	1933	3	refect_
refects	12	40	1274	3	refects
rejected	18	27	1011	3	rejected
rejectee	17	28	962	3	rejectee
rejecter	17	25	894	3	rejecter
rejector	17	23	772	3	rejector
resect	8	44	2470	3	resect_
resects	9	41	1559	3	resects
select	8	26	2117	3	select_
selects	9	19	1214	3	selects
seneca	8	3	979	3	senec_a
tecta	7	42	1552	3	__tecta

Search took 8 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.406	440125.6
2	DLD Change Limit	134027	92	6.736	19897.1
3	Display Results	92	92	0.030	3066.7
	(SQL Overall)	178691	92	7.172	24915.1