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

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

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.

50 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
shortchanging	23	7	107	(None)
shortchange	20	5	169	3	shortchang__e
shortchanged	22	6	133	3	shortchang_ed
shortchanger	21	7	134	3	shortchang_er
shortchangers	22	7	111	3	shortchangers
shortchanges	21	5	162	3	shortchang_es
outcharging	18	4	378	4	__outcharging
rechanging	17	4	604	4	___rechanging
shortcoming	19	5	195	4	shortc__oming
shortcutting	18	8	159	4	shortc_utting
shortening	14	4	530	4	short__en_ing
shortwaving	21	5	150	4	short_wa_ving
straphanging	19	5	166	4	s_traphanging
surcharging	18	5	230	4	s_ur_charging
changing	15	32	1151	5	_____changing
chitchatting	23	5	105	5	ch_itchatting
exchanging	24	4	309	5	___exchanging
hotching	17	30	931	5	_ho_tch___ing
interchanging	20	5	299	5	interchanging
merchanting	19	4	431	5	_mer_chanting
mortgaging	15	4	288	5	_mort_ga_ging
orphaning	15	4	499	5	__or_phan_ing
outcharming	19	4	358	5	__outcharming
outranging	12	3	800	5	__out_ranging
outthanking	19	4	343	5	__outthanking
overcharging	22	4	422	5	over_charging
overhanging	19	4	632	5	__overhanging
portaging	13	4	684	5	_port__a_ging
precharging	20	4	375	5	__precharging
recharging	17	4	529	5	___recharging
rehanging	14	3	756	5	___r_ehanging
scootching	18	4	336	5	scootch___ing
scorching	17	3	563	5	scor_ch___ing
scotching	17	3	565	5	sco_tch___ing
shirttailing	16	5	126	5	shirt_tailing
shortcomings	20	5	118	5	shortc__omings
shortenings	15	4	268	5	short__en_ings
shorthair	15	4	302	5	short_ha__i_r
shorthairs	16	7	281	5	short_ha__irs
shorthand	16	4	375	5	short_ha___nd
shorthanded	19	5	225	5	short_han_ded
shorthands	17	4	349	5	short_han__ds
shorting	12	25	1480	5	short_____ing
shortlisting	16	5	164	5	short_listing
shotgunning	16	5	89	5	sho_t_gunning
showcasing	19	4	206	5	sho_wc_a_sing
smoothening	17	5	211	5	smoot_hen_ing
stanging	10	40	1365	5	s___t__anging
supercharging	22	6	242	5	supercharging
unchanging	17	4	522	5	___unchanging

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	124790	0.390	458182.1
2	DLD Change Limit	124790	50	9.000	13865.6
3	Display Results	50	50	0.033	1515.2
	(SQL Overall)	178691	50	9.423	18963.3