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

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

57 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
teargassing	13	5	200	(None)
degassing	12	3	482	3	de__gassing
harassing	13	4	698	3	_har_assing
teargassed	12	5	215	3	teargass_ed
teargasses	11	4	306	3	teargass_es
amassing	11	3	800	4	__a_massing
bargaining	14	4	521	4	_bargaining
bearbaiting	16	4	316	4	bearbaiting
brassing	11	26	1230	4	__br_assing
canvassing	16	4	380	4	_canvassing
caressing	12	3	880	4	_car_essing
cuirassing	13	4	302	4	cuir_assing
declassing	14	4	512	4	de_classing
decreasing	14	4	651	4	decrea_sing
degaussing	13	4	229	4	de__gaussing
degreasing	13	4	542	4	degrea_sing
depressing	14	4	809	4	depr_essing
earmarking	17	4	358	4	_earmarking
egressing	11	4	685	4	_egr_essing
embarrassing	17	6	153	4	embarrassing
engrossing	12	12	464	4	_engrossing
erasing	8	3	1796	4	_e_r_a_sing
gassing	9	42	1633	4	____gassing
grassing	10	33	1197	4	__gr_assing
harnessing	14	4	390	4	_harnessing
hearsing	12	3	938	4	hear___sing
orgasming	13	4	311	4	__orgasming
outgassing	12	4	535	4	_outgassing
overpassing	17	4	664	4	overpassing
percussing	15	4	522	4	pe_rcussing
rearguing	11	3	560	4	rearg__uing
rearousing	11	5	645	4	rear_ousing
rearranging	13	4	378	4	rearranging
rearresting	12	4	596	4	rearresting
reassessing	12	4	399	4	reassessing
recrossing	13	8	697	4	recr_ossing
redressing	12	4	782	4	redr_essing
regressing	12	4	814	4	regr_essing
repassing	12	24	942	4	re__passing
repressing	13	3	1039	4	repr_essing
reraising	10	3	1377	4	re_r_aising
stargazing	21	9	332	4	starga_zing
surpassing	13	4	383	4	_surpassing
targeting	11	3	730	4	t_arg_eting
tarmacking	19	4	423	4	t_armacking
tarnishing	14	4	515	4	t_arnishing
teargas	8	3	701	4	tearga_s___
teargases	10	4	480	4	tearga_s_es
tearing	8	40	2149	4	tear____ing
teasing	8	39	1851	4	te___a_sing
telecasting	14	4	379	4	telecasting
terracing	12	3	770	4	te_rra_cing
terrorising	12	5	502	4	terrorising
thrashing	16	3	568	4	t_hr_ashing
trashing	12	26	1322	4	t__r_ashing
trespassing	14	4	231	4	trespassing
trussing	9	26	865	4	t__r_ussing

Search took 9 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	57	8.503	17501.9
3	Display Results	57	57	0.030	1900.0
	(SQL Overall)	178691	57	8.953	19958.8