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

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

89 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
dorsally	12	4	683	(None)
dorsal	7	46	1394	2	dorsa_l_
dorsals	8	41	1084	2	dorsa_ls
formally	16	3	824	2	formally
morally	12	4	1149	2	mor_ally
mortally	13	3	993	2	mortally
normally	13	4	788	2	normally
orally	9	31	1359	2	_or_ally
aborally	13	4	706	3	abor_ally
adorably	14	4	644	3	ador_ably
aerially	11	9	1191	3	aerially
amorally	13	4	809	3	amor_ally
areally	10	4	1124	3	_areally
aurally	10	3	1054	3	aur_ally
basally	12	3	796	3	_basally
carnally	13	3	952	3	carnally
causally	13	5	661	3	causally
chorally	16	3	810	3	chor_ally
coastally	14	4	650	3	coastally
coevally	16	4	628	3	coevally
coitally	13	3	948	3	coitally
cordially	15	4	748	3	cordially
coronally	14	4	841	3	coronally
costally	13	3	973	3	costally
dally	9	53	2474	3	d___ally
dentally	12	11	1006	3	dentally
dismally	14	4	651	3	dismally
distally	12	3	955	3	distally
diurnally	13	4	406	3	diurnally
dolly	9	61	2520	3	do___lly
domically	17	4	910	3	domically
doorsill	9	4	376	3	doorsill_
doorsills	10	4	300	3	doorsills
dormancy	16	4	442	3	dormancy
dorsa	6	46	1728	3	dorsa___
dorsad	8	40	897	3	dorsa__d
dorsel	7	53	1550	3	dors_el_
dorsels	8	44	1257	3	dors_els
dossal	7	55	1030	3	dossa_l_
dossals	8	37	929	3	dossa_ls
drably	12	35	1161	3	d_r_ably
drawly	13	49	1072	3	d_r_awly
drolly	10	54	1167	3	d_r_olly
dually	10	32	1006	3	d__ually
ducally	13	25	741	3	d_ucally
durably	13	22	905	3	dur_ably
florally	14	4	703	3	flor_ally
focally	15	18	855	3	fo_cally
formably	18	4	666	3	formably
gorbelly	14	4	547	3	gorbelly
gyrally	14	3	558	3	gyr_ally
horsefly	17	4	487	3	horsefly
horsily	13	3	884	3	hors_ily
jovially	21	4	475	3	jovially
jurally	17	3	696	3	jur_ally
locally	12	17	972	3	lo_cally
loyally	13	12	684	3	lo_yally
mesally	12	11	979	3	_mesally
misally	12	11	1106	3	_misally
modally	13	3	840	3	mo_dally
nasally	10	5	744	3	_nasally
nodally	11	3	791	3	no_dally
normalcy	15	4	338	3	normalcy
nounally	11	4	648	3	nounally
ovally	12	27	844	3	_o_vally
phrasally	17	4	282	3	phrasally
portably	15	3	931	3	portably
postally	13	3	1027	3	postally
rally	8	47	2590	3	__r_ally
really	9	33	1561	3	__really
royally	13	15	773	3	ro_yally
rurally	10	3	830	3	rur_ally
sally	8	51	2971	3	___sally
serially	11	9	1284	3	serially
socially	13	3	854	3	socially
sororally	12	4	639	3	sororally
sortably	13	3	880	3	sortably
spousally	14	4	289	3	spousally
tarnally	11	3	827	3	tarnally
tonally	10	3	1137	3	to_nally
totally	10	3	989	3	to_tally
unreally	11	4	823	3	unreally
uxorially	19	4	405	3	uxorially
verbally	16	4	718	3	verbally
vernally	14	4	782	3	vernally
virally	13	3	965	3	vir_ally
vocally	15	18	834	3	vo_cally
workably	20	4	474	3	workably
zonally	19	3	800	3	zo_nally

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	146162	0.436	409841.7
2	DLD Change Limit	146162	89	7.003	20871.3
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	7.469	23924.4