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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

145 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
dispatching	20	14	352	(None)
despatching	20	12	265	1	despatching
mispatching	21	13	343	1	mispatching
mismatching	21	12	340	2	mismatching
dethatching	21	4	224	3	dethatching
disbranching	21	5	248	3	disbranching
disparaging	16	4	472	3	disparaging
disparting	14	3	893	3	dispa_rting
dispatch	16	5	455	3	dispatch___
dispatched	19	9	388	3	dispatch_ed
dispatcher	18	5	326	3	dispatch_er
dispatchers	19	7	246	3	dispatchers
dispatches	18	7	458	3	dispatch_es
displacing	16	4	641	3	displac_ing
disputing	13	3	776	3	disput__ing
disrating	11	7	1455	3	disrat__ing
distancing	14	4	708	3	distanc_ing
ditching	15	34	994	3	di___tching
patching	16	32	1275	3	___patching
repatching	18	4	499	3	_repatching
snatching	15	3	636	3	__snatching
batching	16	37	1209	4	___batching
birdwatching	24	5	76	4	birdwatching
bitching	16	36	1062	4	bi___tching
catching	16	37	1277	4	___catching
debauching	19	4	247	4	d_ebauching
despairing	14	4	506	4	despa_iring
despatch	16	4	322	4	despatch___
despatched	19	5	323	4	despatch_ed
despatches	18	7	404	4	despatch_es
despiting	13	17	932	4	despit__ing
detaching	16	3	726	4	d_eta_ching
diapausing	14	4	287	4	diapa_using
dictating	13	3	888	4	dictat__ing
dilating	10	27	1491	4	di_lat__ing
diphthong	19	5	234	4	di_pht_hong
disabling	13	3	775	4	dis_a_bling
disabusing	14	4	461	4	dis_abusing
disarming	13	3	880	4	dis_a_rming
disavowing	18	4	395	4	dis_avowing
disbanding	15	4	558	4	disba_nding
disbarring	14	4	528	4	disba_rring
discanting	14	4	945	4	disca_nting
discarding	15	4	734	4	disca_rding
discasing	13	3	943	4	disca__sing
discing	11	39	1459	4	dis___c_ing
discoing	12	5	1145	4	dis___coing
disdaining	13	4	599	4	disda_ining
diseasing	11	3	1083	4	disea__sing
disfavoring	19	5	257	4	disfavoring
disfrocking	22	5	296	4	disfrocking
disgracing	15	8	674	4	disgrac_ing
dishing	12	40	1710	4	dis____hing
disjecting	21	7	724	4	dis_jecting
dismantling	15	4	339	4	dismantling
dismasting	14	4	638	4	disma_sting
dismaying	16	5	682	4	disma__ying
dispelling	14	4	761	4	disp_elling
dispending	15	4	792	4	disp_ending
dispensing	14	4	823	4	disp_ensing
dispeopling	17	4	328	4	dispeopling
dispersing	14	4	930	4	disp_ersing
dispiriting	15	4	594	4	dispiriting
displanting	15	4	604	4	displanting
displaying	17	4	631	4	disp_laying
displeasing	15	4	493	4	displeasing
disploding	15	7	587	4	disp_loding
displuming	16	4	437	4	disp_luming
disporting	14	3	982	4	disp_orting
disposing	13	3	993	4	disp__osing
dispraising	15	4	604	4	dispraising
dispreading	16	4	591	4	dispreading
disprizing	23	4	792	4	disp_rizing
disproving	17	4	629	4	disp_roving
dissaving	14	3	696	4	dissa__ving
disseating	12	11	1178	4	disseat__ing
dissecting	14	13	947	4	dis_secting
dissipating	15	5	631	4	dissipat__ing
distaining	12	4	890	4	dista_ining
distasting	12	4	802	4	dista_sting
distracting	15	6	926	4	distracting
districting	15	5	901	4	districting
disvaluing	15	7	443	4	disva_luing
enswathing	17	4	268	4	enswat_hing
hatching	17	33	1221	4	___hatching
hitching	17	33	1052	4	hi___tching
impacting	16	3	594	4	_impa_cting
impeaching	20	4	337	4	_impeaching
inarching	15	4	634	4	_i_narching
inswathing	17	4	297	4	inswat_hing
itching	13	40	1168	4	_i___tching
latching	14	37	1202	4	___latching
matching	16	35	1239	4	___matching
misacting	14	3	908	4	mis_a_cting
misatoning	13	4	644	4	mis_atoning
misdating	13	10	1066	4	misdat__ing
miseating	12	12	1543	4	miseat__ing
mismating	14	12	1182	4	mismat__ing
mispaging	15	3	780	4	mispa__ging
mispainting	16	4	529	4	mispainting
misparsing	15	4	661	4	mispa_rsing
misparting	15	3	808	4	mispa_rting
mispatch	17	4	385	4	mispatch___
mispatched	20	5	383	4	mispatch_ed
mispatches	19	7	410	4	mispatch_es
misplacing	17	4	591	4	misplac_ing
mispricing	17	4	671	4	mispric_ing
misrating	12	10	1485	4	misrat__ing
misspacing	17	8	498	4	misspa_c_ing
misteaching	19	4	453	4	misteaching
mistouching	19	4	299	4	mistouching
outcatching	19	4	311	4	outcatching
outmatching	19	4	333	4	outmatching
outpitching	19	6	297	4	outpitching
outwatching	20	4	301	4	outwatching
parching	16	43	1305	4	___parching
pitching	16	34	1111	4	___pitching
potlatching	19	5	211	4	potlatching
rematching	18	4	491	4	_rematching
researching	17	4	342	4	researching
resketching	21	4	227	4	resketching
respacing	14	3	889	4	respa_c_ing
restitching	17	4	400	4	restitching
scathing	14	26	970	4	__scat_hing
scotching	17	3	565	4	__scotching
scratching	18	4	453	4	_scratching
scutching	17	3	522	4	__scutching
searching	15	3	834	4	__searching
sketching	19	3	508	4	__sketching
smutching	17	3	485	4	__smutching
snitching	15	3	591	4	__snitching
spacing	12	36	1449	4	__spa_c_ing
spatting	11	31	1176	4	__spat_ting
splotching	18	4	286	4	__splotching
stanching	15	3	808	4	__stanching
starching	15	3	859	4	__starching
stitching	15	4	710	4	__stitching
swathing	15	24	871	4	__swat_hing
switching	18	3	570	4	__switching
thatching	18	3	514	4	__thatching
unlatching	16	4	315	4	_unlatching
unstitching	17	4	264	4	unstitching
unswathing	17	4	330	4	unswat_hing
watching	17	30	1117	4	___watching
witching	17	34	1063	4	wi___tching

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.453	394461.4
2	DLD Change Limit	148819	145	8.126	18313.9
3	Display Results	145	145	0.076	1907.9
	(SQL Overall)	178691	145	8.655	20646.0