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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

119 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
decimated	15	4	895	(None)
decimate	13	4	1112	1	decimate_
decimates	14	4	1069	1	decimates
decimator	14	4	773	2	decimator
decimeter	14	14	741	2	decimeter
decorated	13	3	1221	2	decorated
dedicated	14	3	1025	2	dedicated
delimited	13	4	659	2	delimited
depilated	13	3	965	2	depilated
deviated	13	3	1104	2	devi_ated
acclimated	17	4	515	3	acclimated
animated	11	16	1237	3	_animated
checkmated	24	5	254	3	checkmated
deactivated	18	4	373	3	deactivated
deaerated	11	3	1112	3	deaerated
dealated	10	32	1360	3	de_alated
deaminated	14	4	801	3	deaminated
debated	11	39	1608	3	de__bated
debited	11	33	1162	3	debi__ted
decameter	14	13	736	3	decameter
decamped	16	3	497	3	decam_ped
decanted	12	23	1049	3	dec_anted
decapitated	17	4	494	3	decapitated
decayed	14	30	933	3	dec__ayed
deceased	12	4	772	3	dec_eased
deciare	10	7	1066	3	deci_are_
deciares	11	5	1063	3	deci_ares
decided	12	43	1242	3	deci__ded
deciduate	13	4	506	3	deciduate_
deciliter	12	4	703	3	deciliter
decimal	12	3	808	3	decima__l
decimalized	26	4	610	3	decimalized
decimally	17	4	561	3	decimally
decimals	13	4	586	3	decima_ls
decimating	16	4	876	3	decimating
decimation	15	4	1162	3	decimation
decimators	15	4	750	3	decimators
decimeters	15	15	668	3	decimeters
decimetre	14	12	530	3	decimetre
decimetres	15	13	504	3	decimetres
declared	12	4	875	3	dec_lared
declawed	15	4	593	3	dec_lawed
decocted	14	3	769	3	dec_octed
decollated	14	13	628	3	decollated
decorate	11	3	1519	3	decorate_
decorates	12	3	1474	3	decorates
decreased	13	4	546	3	decreased
decrypted	18	4	277	3	decrypted
decussated	14	4	289	3	decussated
dedicate	12	3	1280	3	dedicate_
dedicatee	13	4	1034	3	dedicatee
dedicates	13	3	1169	3	dedicates
defeated	13	28	1216	3	de_feated
defecated	16	3	749	3	defecated
defiladed	15	14	347	3	defiladed
deflated	13	34	1230	3	de_flated
delated	9	37	2287	3	de__lated
delegated	12	3	837	3	delegated
delicate	11	3	1549	3	delicate_
delicates	12	3	1431	3	delicates
delighted	15	4	620	3	delighted
delimed	11	3	1072	3	delim__ed
delimiter	12	4	624	3	delimiter
delineated	12	4	624	3	delineated
delisted	10	3	1056	3	deli_sted
demasted	12	3	876	3	de__masted
demitted	12	28	877	3	demi_tted
demoted	11	43	1354	3	de__moted
denigrated	13	6	697	3	denigrated
denimed	11	5	923	3	denim__ed
denitrated	12	9	803	3	denitrated
dentated	10	4	1170	3	de_ntated
denudated	12	4	493	3	denudated
depicted	14	3	774	3	depi_cted
depilate	11	3	1170	3	depilate_
depilates	12	3	1092	3	depilates
depurated	13	3	818	3	depurated
deracinated	15	4	486	3	deracinated
derated	9	36	2350	3	de__rated
derivate	12	3	1120	3	derivate_
derivates	13	3	1009	3	derivates
derogated	12	3	868	3	derogated
desiccated	16	4	499	3	desiccated
designated	13	4	593	3	designated
desisted	10	3	978	3	desi_sted
desolated	11	3	965	3	desolated
despumated	16	4	319	3	despumated
detonated	11	3	821	3	detonated
deviate	11	3	1271	3	devi_ate_
deviates	12	3	1274	3	devi_ates
dictated	12	3	920	3	dic_tated
digitated	12	8	696	3	digitated
dilated	9	31	1582	3	d__ilated
dominated	13	3	988	3	dominated
echinated	15	4	648	3	_echinated
epilated	11	3	1075	3	_epilated
estimated	12	10	944	3	estimated
geminated	13	3	855	3	geminated
gemmated	14	33	629	3	ge_mmated
hesitated	13	7	778	3	hesitated
intimated	12	10	1089	3	intimated
levigated	14	4	564	3	levigated
levitated	13	4	641	3	levitated
mediated	12	30	1187	3	medi_ated
medicated	15	4	1007	3	medicated
meditated	13	4	808	3	meditated
peculated	14	23	1085	3	peculated
reanimated	13	4	700	3	reanimated
recited	10	43	1910	3	reci__ted
recoated	11	34	1679	3	rec_oated
recrated	11	29	1861	3	rec_rated
recreated	12	4	1254	3	recreated
reimaged	12	4	617	3	re_imaged
remated	10	35	2247	3	re__mated
resinated	10	4	1328	3	resinated
seriated	9	27	1702	3	seri_ated
speciated	14	20	754	3	speci_ated
ultimated	12	4	731	3	ultimated
vesicated	15	11	765	3	vesicated

Search took 10 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	148641	0.436	409841.7
2	DLD Change Limit	148641	119	9.046	16431.7
3	Display Results	119	119	0.110	1081.8
	(SQL Overall)	178691	119	9.592	18629.2