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

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

74 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
wauchting	18	4	347	(None)
waughting	17	4	312	1	waughting
watching	17	30	1117	2	watch_ing
yachting	17	3	493	2	ya_chting
aching	12	65	2197	3	_a_ch_ing
acting	9	59	2098	3	_a_c_ting
arching	13	62	1669	3	_arch_ing
auditing	10	3	903	3	_auditing
baching	15	60	1775	3	ba_ch_ing
batching	16	37	1209	3	batch_ing
cacheting	17	3	715	3	ca_cheting
caching	15	63	1750	3	ca_ch_ing
catching	16	37	1277	3	catch_ing
caucusing	14	4	380	3	caucusing
claughting	17	4	248	3	claughting
couching	16	32	1326	3	couch_ing
daunting	10	33	1040	3	dau_nting
dauting	9	38	1476	3	dau__ting
douching	15	34	984	3	douch_ing
draughting	16	4	288	3	draughting
ducting	11	37	1359	3	_duc_ting
educating	13	3	793	3	educating
eructing	11	21	1017	3	eruc_ting
euchring	14	3	661	3	_euchring
faceting	14	3	878	3	fa_ceting
faulting	12	23	773	3	fau_lting
fraughting	18	4	306	3	fraughting
hatching	17	33	1221	3	hatch_ing
hatchling	18	4	495	3	hatchling
haunting	12	35	1005	3	hau_nting
jaunting	16	32	863	3	jau_nting
latching	14	37	1202	3	latch_ing
laughing	13	3	593	3	laugh_ing
launching	15	4	478	3	launch_ing
lichting	14	26	851	3	_lichting
marching	16	43	1219	3	march_ing
matching	16	35	1239	3	match_ing
mouching	16	31	1058	3	mouch_ing
ouching	13	43	1490	3	_ouch_ing
oughting	13	3	595	3	_oughting
parching	16	43	1305	3	parch_ing
patching	16	32	1275	3	patch_ing
pouching	16	32	1041	3	pouch_ing
racheting	15	3	779	3	ra_cheting
ranching	14	17	1204	3	ranch_ing
ratcheting	16	4	378	3	ratcheting
ruching	13	36	1293	3	_ruch_ing
saucing	10	3	1100	3	sauc__ing
taunting	9	35	1093	3	tau_nting
tauting	8	33	1638	3	tau__ting
touching	14	32	1134	3	touch_ing
trauchling	16	4	347	3	trauchling
vacating	14	3	1036	3	va_cating
vaulting	12	22	723	3	vau_lting
vaunting	12	33	875	3	vau_nting
vouching	17	30	823	3	vouch_ing
wafting	14	39	1166	3	wa__fting
waisting	12	36	1521	3	wa_isting
waiting	11	36	1895	3	wa__iting
wanting	11	42	2017	3	wa__nting
washing	14	51	1928	3	wa_sh_ing
wasting	11	44	2284	3	wa__sting
waucht	14	39	941	3	waucht___
wauchted	17	5	337	3	waucht_ed
wauchts	15	28	528	3	waucht__s
wauking	15	34	1001	3	wau__king
wauling	11	27	1311	3	wau__ling
weighting	17	4	478	3	weighting
welching	17	28	736	3	welch_ing
wenching	17	32	886	3	wench_ing
whishting	19	8	356	3	whishting
winching	17	35	990	3	winch_ing
witching	17	34	1063	3	witch_ing
yachtings	18	4	266	3	ya_chtings

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	74	6.890	21573.4
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	7.343	24334.9