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

Here are the results of your fuzzy-string dictionary search for “erects” with Change Limit: [1] [2] [3]

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.

80 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
erects	8	41	1618	(None)
ejects	15	40	995	1	ejects
elects	8	33	1500	1	elects
erect	7	41	2933	1	erect_
eructs	8	36	1079	1	eructs
arecas	8	48	1744	2	arecas
berets	8	58	2252	2	bere_ts
bracts	10	56	1777	2	bracts
brents	8	47	1727	2	brents
coerects	12	5	854	2	coerects
crests	8	52	1870	2	crests
defects	13	45	1152	2	defects
dejects	17	38	922	2	dejects
detects	10	40	1109	2	detects
directs	10	27	1026	2	directs
drecks	13	45	920	2	drecks
edicts	9	49	1170	2	edicts
educts	9	43	989	2	educts
effects	15	3	528	2	effects
egests	7	44	1125	2	egests
egrets	7	27	1224	2	egre_ts
eject	14	50	1604	2	eject_
ejecta	15	33	739	2	ejecta
elect	7	43	2703	2	elect_
enacts	8	40	1297	2	enacts
epacts	10	50	1039	2	epacts
erected	10	32	1399	2	erected
erecter	9	31	1339	2	erecter
erecters	10	26	1161	2	erecters
erectly	12	5	748	2	erectly
erector	9	35	1381	2	erector
erectors	10	35	1426	2	erectors
ergots	7	45	1237	2	ergots
ericas	8	3	1546	2	ericas
eruct	7	40	2235	2	eruct_
erupts	8	34	890	2	erupts
events	9	48	1407	2	events
everts	9	45	1489	2	everts
evicts	11	36	855	2	evicts
exacts	15	35	961	2	exacts
execs	14	53	972	2	exec_s
exerts	13	37	1229	2	exerts
expects	18	6	688	2	expects
exsects	16	5	557	2	exsects
frets	8	55	2340	2	fre_ts
gerents	8	26	1292	2	gerents
greats	7	63	1839	2	greats
greets	7	51	1742	2	greets
perfects	15	10	735	2	perfects
preacts	11	32	1136	2	preacts
precis	10	34	1670	2	precis
precuts	11	17	1047	2	precuts
prests	8	40	2126	2	prests
reacts	8	36	1660	2	reacts
recits	8	36	2135	2	_recits
recks	11	56	2513	2	_recks
recs	6	57	3418	2	_rec_s
recta	7	42	2026	2	_recta
recti	7	36	1962	2	_recti
recto	7	45	2080	2	_recto
rectos	8	57	1878	2	_rectos
rectus	8	33	1463	2	_rectus
recuts	8	38	1737	2	_recuts
reerects	10	31	992	2	reerects
reests	6	46	1889	2	reests
refects	12	40	1274	2	refects
rejects	16	39	1069	2	rejects
rents	5	59	3518	2	_rents
rerents	7	33	1942	2	rerents
resects	9	41	1559	2	resects
rests	5	49	3587	2	_rests
rets	4	53	5256	2	_re_ts
sects	7	56	2289	2	_sects
selects	9	19	1214	2	selects
tercets	9	35	1244	2	tercets
tracts	8	50	1907	2	tracts
treats	6	48	2169	2	treats
trets	5	59	2802	2	tre_ts
wrecks	15	41	888	2	wrecks
wrests	9	53	1308	2	wrests

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	80	2.580	31996.5
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	2.953	60511.7