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

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

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.

60 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
typecasting	19	5	196	(None)
telecasting	14	4	379	2	telecasting
forecasting	17	4	447	3	forecasting
linecasting	14	10	278	3	linecasting
precasting	15	16	983	3	_precasting
recasting	12	24	1423	3	__recasting
typecast	15	4	527	3	typecast___
typecasts	16	4	282	3	typecast__s
typesetting	17	5	222	3	typesetting
typewriting	20	5	201	3	typewriting
upcasting	14	3	482	3	_up_casting
yeasting	12	18	892	3	_y_e_asting
appeasing	14	4	634	4	appe_as_ing
asperating	13	4	956	4	aspera_ting
breasting	12	3	958	4	_bre_asting
bypassing	17	4	295	4	byp__assing
cablecasting	19	5	148	4	cablecasting
casting	10	46	2834	4	____casting
copycatting	21	5	198	4	copycatting
decanting	13	25	1063	4	__decanting
defecating	17	23	778	4	defeca_ting
demasting	13	3	845	4	__demasting
deprecating	17	7	728	4	depreca_ting
easting	8	49	2430	4	___e_asting
expecting	21	4	669	4	expec__ting
feasting	12	20	1132	4	__fe_asting
foretasting	15	5	442	4	foretasting
hyphenating	23	5	372	4	hyphena_ting
impasting	14	3	632	4	imp__asting
imprecating	18	4	490	4	impreca_ting
linecastings	15	5	155	4	linecastings
miscasting	15	5	707	4	_miscasting
operating	12	3	1372	4	_opera_ting
overcasting	17	4	851	4	overcasting
pasting	10	38	2655	4	__p__asting
prepasting	15	16	888	4	_prepasting
pretasting	13	23	928	4	_pretasting
recanting	12	24	1482	4	__recanting
repasting	12	23	1284	4	__repasting
repeating	12	26	1898	4	repe_a_ting
retasting	10	25	1341	4	__retasting
speciating	15	4	812	4	_speciating
spectating	15	4	662	4	_spectating
tasting	8	46	2421	4	t____asting
teasing	8	39	1851	4	t__e_as_ing
tempesting	15	4	445	4	tempe__sting
tenanting	10	3	621	4	t__enanting
testing	8	60	2105	4	t__e__sting
threating	13	10	1005	4	thre_a_ting
toasting	9	34	1058	4	t___oasting
tolerating	11	4	859	4	tolera_ting
tomcatting	15	4	243	4	t_omcatting
treating	9	25	1961	4	t_re_a_ting
truncating	13	4	423	4	trunca_ting
typecase	15	4	346	4	typecas___e
typecases	16	4	385	4	typecas__es
typesettings	18	5	125	4	typesettings
typewritings	21	6	140	4	typewritings
uppercasing	18	5	276	4	uppercas_ing
webcasting	18	4	248	4	_webcasting

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	148819	0.420	425454.8
2	DLD Change Limit	148819	60	8.626	17252.4
3	Display Results	60	60	0.030	2000.0
	(SQL Overall)	178691	60	9.076	19688.3