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

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

64 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
truncated	12	4	458	(None)
truncate	10	4	628	1	truncate_
truncates	11	4	584	1	truncates
tunicated	12	25	749	2	t_unicated
aduncate	11	4	557	3	aduncate_
brunched	16	31	785	3	brunc_hed
coruscated	15	4	446	3	coruscated
crenated	11	30	1391	3	cren_ated
crunched	16	32	816	3	crunc_hed
cuneated	11	3	1010	3	_cuneated
educated	12	3	794	3	edu_cated
enunciated	13	4	497	3	enunciated
eructated	12	4	564	3	eructated
eructed	10	22	865	3	eru_c_ted
furcated	14	3	759	3	_furcated
grunted	9	33	928	3	grun__ted
inundated	11	4	475	3	inundated
lunated	8	3	1082	3	_lun_ated
muricated	14	4	824	3	muricated
pronated	11	4	1405	3	pron_ated
punctated	14	4	505	3	_punctated
ruinated	9	3	952	3	_ruinated
strunted	9	5	724	3	strun__ted
sulcated	11	3	1037	3	_sulcated
taunted	8	43	1096	3	taun__ted
tincted	10	3	727	3	t_inc_ted
trabeated	12	4	684	3	trabeated
tranced	10	44	1417	3	tranc__ed
transacted	13	4	663	3	transacted
transited	10	4	1060	3	transited
translated	11	4	929	3	translated
treated	8	36	1870	3	tr__eated
trenched	14	28	985	3	trenc_hed
trifurcated	17	5	224	3	trifurcated
trinketed	14	4	425	3	trinketed
tritiated	10	4	752	3	tritiated
trounced	11	3	503	3	trounc__ed
truanted	9	3	537	3	tru_anted
truced	9	53	1205	3	tru_c__ed
trucked	14	39	1081	3	tru_c_ked
truckled	15	32	731	3	tru_ckled
trumpeted	14	4	305	3	trumpeted
truncating	13	4	423	3	truncating
truncation	12	4	545	3	truncation
trundled	10	30	639	3	trun_dled
trunked	12	35	841	3	trun__ked
trusted	8	34	1279	3	tru__sted
tunicate	10	33	1004	3	t_unicate_
tunicates	11	26	874	3	t_unicates
unacted	10	3	1273	3	__unacted
unbated	10	33	1773	3	__unbated
uncaged	11	33	1412	3	__uncaged
uncaked	14	35	1435	3	__uncaked
uncarted	11	3	1205	3	__uncarted
uncased	10	42	1695	3	__uncased
uncoated	11	3	1496	3	__uncoated
uncrated	11	4	1631	3	__uncrated
undated	9	31	1846	3	__undated
ungated	9	27	1721	3	__ungated
unmated	10	33	1702	3	__unmated
unrated	8	26	2155	3	__unrated
unsated	8	34	1993	3	__unsated
urinated	9	3	1161	3	urin_ated
urticated	12	4	769	3	urticated

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	148641	0.423	422437.4
2	DLD Change Limit	148641	64	6.733	22076.5
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	7.189	24856.2