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

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

76 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
catered	10	31	1778	(None)
cantered	11	34	1599	1	cantered
capered	12	30	1404	1	capered
caterer	9	28	1595	1	caterer
cratered	11	4	969	1	cratered
watered	11	30	1496	1	watered
altered	8	32	1575	2	altered
bantered	11	33	1365	2	bantered
bartered	11	31	1303	2	bartered
battered	11	33	1507	2	battered
cambered	15	12	900	2	cambered
cameoed	12	3	838	2	cameoed
cancered	13	24	1155	2	cancered
cankered	15	30	1022	2	cankered
caperer	11	30	1340	2	caperer
captured	13	3	657	2	captured
cared	8	60	5009	2	ca__red
careered	11	3	950	2	careered
cater	7	48	4072	2	cater__
cateran	9	3	1377	2	cateran
caterers	10	28	1441	2	caterers
cateress	10	23	1161	2	cateress
caters	8	53	3650	2	cater_s
catted	9	54	2247	2	cat_ted
caverned	14	3	616	2	caverned
centered	11	25	1352	2	centered
cered	8	52	2744	2	c__ered
chaptered	17	17	680	2	chaptered
chartered	15	15	840	2	chartered
chattered	15	19	800	2	chattered
cheered	13	37	1330	2	cheered
clattered	12	17	842	2	clattered
clavered	14	18	763	2	clavered
cohered	13	35	1469	2	cohered
cottered	11	25	1174	2	cottered
covered	13	33	1529	2	covered
cowered	13	32	1465	2	cowered
entered	8	27	1888	2	entered
faltered	12	28	1100	2	faltered
fathered	15	15	1043	2	fathered
gartered	10	31	960	2	gartered
gathered	13	14	938	2	gathered
haltered	12	31	1257	2	haltered
hatred	10	48	1433	2	hat_red
havered	14	40	1145	2	havered
lagered	9	23	1115	2	lagered
latened	8	7	1192	2	latened
laterad	8	3	1085	2	laterad
lathered	12	15	1233	2	lathered
layered	11	25	941	2	layered
mastered	11	26	1401	2	mastered
mattered	11	24	1291	2	mattered
matured	10	3	1004	2	matured
metered	10	35	1401	2	metered
mitered	10	32	1323	2	mitered
nattered	9	20	1163	2	nattered
natured	8	3	896	2	natured
paltered	11	30	1250	2	paltered
papered	12	25	1317	2	papered
pattered	11	27	1421	2	pattered
petered	10	33	1497	2	petered
raftered	12	3	767	2	raftered
sabered	10	32	1302	2	sabered
scattered	12	19	736	2	scattered
tabered	10	33	1159	2	tabered
tapered	10	26	1293	2	tapered
tattered	9	20	1145	2	tattered
uncatered	12	3	740	2	uncatered
uttered	8	27	1244	2	uttered
wafered	14	28	843	2	wafered
wagered	12	29	933	2	wagered
waitered	12	3	876	2	waitered
waterbed	14	3	645	2	waterbed
waterer	10	33	1408	2	waterer
wavered	14	29	1043	2	wavered
yattered	12	23	954	2	yattered

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	76	3.030	35535.0
3	Display Results	76	76	0.033	2303.0
	(SQL Overall)	178691	76	3.439	51960.2