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

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

85 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
florally	14	4	703	(None)
aborally	13	4	706	2	aborally
amorally	13	4	808	2	amorally
chorally	16	3	810	2	chorally
clonally	13	4	669	2	clonally
floral	9	43	1381	2	flora_l_
florals	10	42	1006	2	flora_ls
floridly	15	5	459	2	floridly
focally	15	18	855	2	f_ocally
formally	16	3	824	2	f_ormally
globally	14	4	461	2	globally
locally	12	17	972	2	_locally
loyally	13	12	684	2	_loyally
morally	12	4	1149	2	_morally
orally	9	31	1359	2	__orally
plurally	13	4	580	2	plurally
adorably	14	4	644	3	adorably
anodally	12	4	628	3	anodally
astrally	11	4	888	3	astrally
atonally	11	4	863	3	atonally
aurally	10	3	1053	3	_aurally
aurorally	12	4	526	3	aurorally
clinally	13	4	723	3	clinally
colorably	16	4	615	3	colorably
dorsally	12	4	683	3	_dorsally
facially	16	3	764	3	facially
fatally	13	3	989	3	f_atally
faunally	14	4	543	3	faunally
favorably	20	4	360	3	favorably
federally	16	4	529	3	federally
festally	14	3	754	3	festally
feudally	15	5	482	3	feudally
figurally	16	4	363	3	figurally
filially	14	4	700	3	filially
finally	13	3	1010	3	f_inally
fiscally	16	4	607	3	fiscally
flatly	12	31	1021	3	fl__atly
floaty	12	42	1094	3	flo_a_ty
floppily	18	4	377	3	floppily
flora	8	53	1710	3	flora___
florae	9	47	1388	3	flora__e
floras	9	47	1569	3	flora__s
flossily	14	3	452	3	flossily
flotilla	11	4	329	3	flotilla
fluidally	16	4	315	3	fluidally
folly	11	50	2260	3	f_o__lly
foray	11	50	2397	3	f_ora__y
formably	18	4	666	3	f_ormably
foully	12	3	901	3	f_o_ully
frailly	13	3	731	3	f__railly
frilly	12	41	1144	3	f__rilly
frontally	15	4	611	3	frontally
frugally	15	4	440	3	frugally
fugally	14	3	560	3	f_ugally
gyrally	14	3	558	3	_gyrally
immorally	16	4	516	3	immorally
jurally	17	3	695	3	_jurally
leally	9	40	1261	3	_l_eally
legally	11	3	813	3	_legally
lolly	8	51	2066	3	_lo__lly
loral	5	59	2782	3	_lora_l_
lordly	10	3	875	3	_lor_dly
lovably	15	18	706	3	_lovably
loyalty	13	11	434	3	_loyalty
modally	13	3	839	3	_modally
mortally	13	3	993	3	_mortally
neurally	11	3	792	3	neurally
nodally	11	3	791	3	_nodally
nonorally	12	4	691	3	nonorally
normally	13	4	788	3	_normally
ovally	12	27	844	3	__ovally
perorally	14	4	820	3	perorally
rally	8	47	2590	3	___rally
retrally	11	3	1052	3	retrally
royally	13	15	773	3	_royally
rurally	10	3	829	3	_rurally
sororally	12	4	638	3	sororally
spirally	13	4	801	3	spirally
tonally	10	3	1137	3	_tonally
totally	10	3	989	3	_totally
unmorally	14	4	570	3	unmorally
uxorially	19	4	405	3	uxorially
virally	13	3	964	3	_virally
vocally	15	18	834	3	_vocally
zonally	19	3	800	3	_zonally

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.186	960704.3
2	DLD Change Limit	146162	85	6.783	21548.3
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	6.999	25530.9