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

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

70 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
ripsnorting	14	5	153	(None)
disporting	14	3	982	3	di_sporting
distorting	12	3	959	3	di_storting
missorting	13	4	712	3	mi_ssorting
reassorting	12	4	502	3	reassorting
reporting	12	5	1390	3	rep__orting
resorting	10	6	1461	3	r_es_orting
riposting	12	3	606	3	rip__osting
ripsnorter	12	5	126	3	ripsnort_er
ripsnorters	13	5	128	3	ripsnorters
snorting	9	26	1337	3	___snorting
assorting	10	3	730	4	__assorting
consorting	13	4	1074	4	cons_orting
deporting	13	6	959	4	dep__orting
dipnetting	14	5	362	4	dip_netting
discording	15	4	766	4	di_scording
disgorging	14	5	501	4	di_sgorging
disparting	14	3	893	4	di_sparting
disrooting	12	4	775	4	di_srooting
disserting	12	13	1085	4	di_sserting
escorting	12	3	771	4	__escorting
exporting	19	3	732	4	exp__orting
ignoring	10	3	648	4	_i_gnor_ing
importing	14	3	819	4	_i_mporting
inserting	10	9	1424	4	_ins_erting
insnaring	10	4	631	4	_insnar_ing
intorting	10	3	1141	4	_i_ntorting
minoring	11	3	1147	4	mi__nor_ing
misforming	18	4	540	4	mi_sforming
misparting	15	3	808	4	mi_sparting
misrouting	13	4	722	4	mi_srouting
misstarting	14	12	520	4	misstarting
miswording	17	4	486	4	mi_swording
nonsporting	14	4	482	4	nonsporting
outsnoring	11	4	561	4	outsnor_ing
porting	10	30	2178	4	__p__orting
presorting	13	3	998	4	pres_orting
reasserting	12	4	615	4	reasserting
redshirting	16	4	326	4	redshirting
reexporting	21	4	342	4	reexporting
reimporting	16	4	409	4	reimporting
reinserting	12	5	690	4	reins_erting
reknotting	15	6	423	4	r_eknotting
repenting	12	23	1655	4	repen__ting
replotting	13	5	704	4	rep_lotting
repotting	12	5	1112	4	rep__otting
rescoring	12	3	1060	4	r_escor_ing
reshooting	14	3	622	4	r_eshooting
resonating	11	3	1126	4	r_esonating
resorbing	12	6	935	4	r_es_orbing
respotting	13	4	711	4	r_espotting
resprouting	14	4	505	4	resprouting
restarting	11	3	1066	4	r_estarting
restoring	10	3	1461	4	r_estor_ing
retorting	10	6	1327	4	r__etorting
rioting	8	27	1639	4	ri___o_ting
ripening	11	3	857	4	ripen___ing
ripsawing	15	4	287	4	rips__awing
shorting	12	25	1480	4	___shorting
snooting	9	28	1320	4	___snooting
snoring	8	39	1720	4	___snor_ing
snouting	9	25	1192	4	___snouting
sorting	8	32	2181	4	___s_orting
sporting	11	24	1546	4	___sporting
supporting	15	4	556	4	sup_porting
transporting	15	5	578	4	transporting
trapshooting	18	5	250	4	trapshooting
upshooting	16	4	255	4	_upshooting
upstarting	13	4	388	4	_upstarting
visoring	12	3	837	4	vi_s_or_ing

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	70	9.016	16506.1
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	9.466	18877.1