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

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

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

168 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
royally	13	15	773	(None)
loyally	13	12	684	1	loyally
royalty	13	16	511	1	royalty
focally	15	18	855	2	focally
locally	12	17	972	2	locally
loyalty	13	11	434	2	loyalty
modally	13	3	840	2	modally
morally	12	4	1149	2	morally
nodally	11	3	791	2	nodally
orally	9	31	1359	2	_orally
ovally	12	27	844	2	_ovally
rally	8	47	2590	2	r__ally
really	9	33	1561	2	r_eally
regally	11	5	987	2	regally
retally	10	4	1368	2	retally
royal	8	50	1470	2	roya_l_
royals	9	37	1126	2	roya_ls
rurally	10	3	830	2	rurally
tonally	10	3	1137	2	tonally
totally	10	3	989	2	totally
vocally	15	18	834	2	vocally
zonally	19	3	800	2	zonally
aborally	13	4	706	3	aborally
ally	7	69	3564	3	___ally
amorally	13	4	809	3	amorally
anally	9	5	1350	3	_anally
anodally	12	4	629	3	anodally
areally	10	4	1124	3	areally
atonally	11	4	863	3	atonally
aurally	10	3	1054	3	aurally
aurorally	12	4	527	3	aurorally
axially	17	3	723	3	axially
bally	10	55	3010	3	__bally
banally	12	4	922	3	banally
basally	12	3	796	3	basally
bridally	14	4	645	3	bridally
broadly	13	3	715	3	bro_adly
brolly	11	45	1085	3	bro__lly
brutally	13	4	574	3	brutally
cavally	15	8	848	3	cavally
cecally	14	5	939	3	cecally
chally	14	43	1429	3	_chally
chorally	16	3	810	3	chorally
clonally	13	4	669	3	clonally
coaly	10	55	2159	3	co_a_ly
coevally	16	4	628	3	coevally
coitally	13	3	948	3	coitally
colly	10	49	2677	3	co__lly
coolly	11	48	1139	3	co_olly
coronally	14	4	841	3	coronally
costally	13	3	973	3	costally
coxalgy	20	4	260	3	coxalgy
coyly	13	56	1489	3	coy__ly
dally	9	53	2474	3	__dally
dolly	9	61	2520	3	do__lly
dorsally	12	4	683	3	dorsally
doyley	13	48	728	3	doy_ley
doyly	12	45	1401	3	doy__ly
drolly	10	54	1167	3	dro__lly
dually	10	32	1006	3	_dually
ducally	13	25	741	3	ducally
equally	19	3	687	3	equally
fatally	13	3	989	3	fatally
finally	13	3	1010	3	finally
florally	14	4	703	3	florally
folly	11	50	2260	3	fo__lly
formally	16	3	824	3	formally
foully	12	3	901	3	fo_ully
frontally	15	4	611	3	frontally
frugally	15	4	440	3	frugally
fugally	14	3	560	3	fugally
gally	9	50	2617	3	__gally
globally	14	4	461	3	globally
golly	9	51	2110	3	go__lly
gyrally	14	3	558	3	gyrally
holly	11	48	2443	3	ho__lly
ideally	11	3	779	3	ideally
jolly	15	45	1751	3	jo__lly
jovially	21	4	475	3	jovially
joyfully	24	4	283	3	joyfully
jurally	17	3	696	3	jurally
leally	9	40	1261	3	_leally
legally	11	3	813	3	legally
lolly	8	51	2066	3	lo__lly
lovably	15	18	706	3	lovably
loyal	8	45	1348	3	loya_l_
loyaler	10	3	508	3	loyaler
mesally	12	11	979	3	mesally
misally	12	11	1106	3	misally
molly	10	52	2249	3	mo__lly
mortally	13	3	993	3	mortally
movably	17	16	704	3	movably
nasally	10	5	744	3	nasally
navally	13	6	647	3	navally
normally	13	4	788	3	normally
notably	12	19	999	3	notably
nounally	11	4	648	3	nounally
novelly	13	4	651	3	novelly
otalgy	10	3	535	3	_otalgy
pally	10	57	2712	3	__pally
papally	14	3	797	3	papally
payably	17	17	709	3	payably
penally	12	11	1177	3	penally
perorally	14	4	822	3	perorally
postally	13	3	1027	3	postally
probably	17	4	641	3	probably
provably	18	4	621	3	provably
racially	13	3	962	3	racially
radially	12	3	978	3	radially
rallye	9	51	1016	3	r__allye
rascally	13	4	773	3	rascally
ratably	12	17	1151	3	ratably
ravelly	13	26	835	3	ravelly
rawly	11	51	1583	3	r__awly
realty	9	27	1369	3	r_ealty
recall	8	38	1572	3	recall_
recalls	9	26	1362	3	recalls
rectally	13	3	971	3	rectally
refall	9	43	1439	3	refall_
refalls	10	33	1224	3	refalls
retrally	11	3	1052	3	retrally
ribaldly	14	4	281	3	ribaldly
ritually	11	6	748	3	ritually
rivalry	13	5	403	3	rivalry
riyal	8	44	1343	3	riya_l_
riyals	9	41	1108	3	riya_ls
robalo	8	3	893	3	roba_lo
robalos	9	3	768	3	robalos
rocaille	10	4	538	3	rocaille
roily	8	61	2111	3	ro__ily
roll	4	63	3165	3	ro__ll_
rolls	5	53	2623	3	ro__lls
roomily	12	3	728	3	roomily
ropable	11	16	1133	3	ropable
ropily	11	33	1244	3	ro_pily
rosary	9	28	1035	3	rosa_ry
roselle	7	3	1024	3	roselle
rosily	9	39	1471	3	ro_sily
rostrally	12	4	609	3	rostrally
rotary	9	24	1130	3	rota_ry
roughly	14	50	729	3	roughly
rouille	7	3	749	3	rouille
roundly	11	3	672	3	roundly
roupily	12	4	665	3	roupily
rowable	12	15	1030	3	rowable
rowdily	14	3	608	3	rowdily
royalism	13	12	847	3	royalism
royalist	11	13	1198	3	royalist
sally	8	51	2971	3	__sally
socially	13	3	854	3	socially
sororally	12	4	639	3	sororally
squally	19	3	767	3	squally
tally	8	45	2686	3	__tally
tidally	11	3	793	3	tidally
tomalley	13	4	328	3	tomalley
trevally	14	4	634	3	trevally
tribally	13	4	732	3	tribally
trolly	9	40	1236	3	tro__lly
usually	10	6	606	3	usually
vagally	14	3	583	3	vagally
venally	13	11	956	3	venally
virally	13	3	965	3	virally
vitally	13	3	967	3	vitally
vocably	17	15	715	3	vocably
wally	11	46	2509	3	__wally
wofully	16	4	452	3	wofully
womanly	15	3	585	3	womanly
woolly	12	40	851	3	wo_olly

Search took 7 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	134027	0.423	422437.4
2	DLD Change Limit	134027	168	6.250	21444.3
3	Display Results	168	168	0.063	2666.7
	(SQL Overall)	178691	168	6.736	26527.8