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

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

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.

65 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
floras	9	47	1569	(None)
flora	8	53	1710	1	flora_
florae	9	47	1388	1	florae
floral	9	43	1381	1	floral
florals	10	42	1006	1	florals
flotas	9	40	1300	1	flotas
agoras	7	6	1334	2	agoras
alohas	9	4	1170	2	alohas
boras	7	59	3830	2	_boras
fedoras	11	3	792	2	fedoras
fiords	10	49	862	2	fiords
fjords	17	40	535	2	fjords
flares	9	45	2170	2	flares
fleas	8	64	2366	2	fl_eas
flirs	8	55	1893	2	flir_s
flirts	9	54	1148	2	flirts
float	8	59	2857	2	flo_at
floats	9	68	1625	2	floats
flocks	15	47	1353	2	flocks
flocs	10	55	1923	2	flo_cs
floes	8	55	2814	2	flo_es
flogs	9	59	1996	2	flo_gs
flongs	10	50	1049	2	flongs
floods	10	45	1165	2	floods
floors	9	41	1235	2	floors
flops	10	59	2014	2	flo_ps
floret	9	3	2112	2	floret
florets	10	3	985	2	florets
florid	10	3	1145	2	florid
florin	9	3	1265	2	florin
florins	10	3	1164	2	florins
florist	10	3	1424	2	florist
floss	8	51	1826	2	flo_ss
flota	8	53	1564	2	flota_
flours	9	44	1405	2	flours
flouts	9	43	1527	2	flouts
flows	11	58	2236	2	flo_ws
fluors	9	43	1137	2	fluor_s
fora	7	59	3739	2	f_ora_
foram	10	51	2493	2	f_oram
forams	11	51	1591	2	f_orams
foray	11	50	2397	2	f_oray
forays	12	48	1300	2	f_orays
forbs	10	57	2080	2	f_orbs
fords	9	53	2818	2	f_ords
fores	8	58	4710	2	f_ores
forks	12	53	2468	2	f_orks
forms	10	53	2705	2	f_orms
forts	8	60	3445	2	f_orts
glorias	8	16	1032	2	glorias
horas	8	63	3310	2	_horas
ixoras	13	3	719	2	ixoras
koras	9	59	2711	2	_koras
liras	5	60	2198	2	_liras
loral	5	59	2782	2	_loral
loran	5	59	2509	2	_loran
lorans	6	51	1760	2	_lorans
lords	6	49	2350	2	_lords
lores	5	50	4540	2	_lores
loris	5	53	2915	2	_loris
lotas	5	59	2630	2	_lotas
moras	7	64	3878	2	_moras
soras	5	50	4101	2	_soras
toras	5	55	4037	2	_toras
ultras	6	3	1019	2	ultras

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	65	2.390	34540.2
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	2.749	65002.2