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

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

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

101 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
favus	11	43	1173	(None)
favas	11	56	1859	1	favas
faves	11	53	3142	1	faves
amus	6	55	2961	2	_amus
anus	4	71	3111	2	_anus
aves	7	61	4260	2	_aves
avos	7	72	2701	2	_avos
babus	9	56	2033	2	babus
casus	7	64	1925	2	casus
caves	10	56	3970	2	caves
clavus	11	34	735	2	clavus
eaves	8	52	3199	2	eaves
fabs	9	86	3586	2	fa_bs
faces	10	64	3943	2	faces
facts	10	70	2189	2	facts
fades	9	49	3286	2	fades
fados	9	56	2073	2	fados
fads	8	69	3987	2	fa_ds
fags	8	69	3912	2	fa_gs
fails	8	56	3148	2	fails
fairs	8	58	2544	2	fairs
fakes	12	60	3248	2	fakes
falls	8	57	2765	2	falls
fames	10	57	3592	2	fames
famous	11	4	1239	2	famous
fanes	8	46	3989	2	fanes
fangs	9	62	2408	2	fangs
fanos	8	59	2650	2	fanos
fans	7	62	4737	2	fa_ns
fanum	10	3	1344	2	fanum
fanums	11	3	726	2	fanums
fards	9	66	2984	2	fards
fares	8	58	5287	2	fares
farls	8	57	3111	2	farls
farms	10	63	2495	2	farms
faros	8	55	3202	2	faros
farts	8	83	3684	2	farts
fas	6	82	6293	2	fa__s
fasts	8	64	2968	2	fasts
fates	8	51	3923	2	fates
fats	7	62	5250	2	fa_ts
faun	7	62	2662	2	fa_un
fauns	8	45	1675	2	fauns
fauve	11	47	1207	2	fauve
fauves	12	56	1042	2	fauves
faux	14	65	1907	2	fa_ux
fava	10	68	2026	2	fav_a
fave	10	55	3296	2	fav_e
favism	14	3	791	2	favism
favor	11	47	1245	2	favor
favors	12	42	1140	2	favors
favour	12	43	833	2	favour
favours	13	43	709	2	favours
favuses	13	3	618	2	favuses
fawns	11	59	1426	2	fawns
faxes	15	57	2665	2	faxes
fays	10	85	3536	2	fa_ys
fazes	17	55	2721	2	fazes
fetus	8	58	1654	2	fetus
feus	7	58	3075	2	f_eus
ficus	10	50	1549	2	ficus
fives	11	60	2736	2	fives
flatus	9	43	1078	2	flatus
flus	7	56	2654	2	f_lus
focus	10	58	1588	2	focus
fucus	10	55	1589	2	fucus
fugus	9	59	1401	2	fugus
habus	10	63	1714	2	habus
hakus	12	51	1411	2	hakus
haves	11	60	3487	2	haves
javas	15	59	1542	2	javas
kagus	10	58	1203	2	kagus
kavas	12	59	1995	2	kavas
lavas	8	54	2222	2	lavas
laves	8	60	3915	2	laves
lavs	7	67	3415	2	lav_s
magus	8	53	1875	2	magus
manus	7	59	2493	2	manus
mavis	10	56	2272	2	mavis
naevus	9	3	459	2	naevus
naves	8	70	3038	2	naves
nevus	8	46	1139	2	nevus
oaves	8	49	2561	2	oaves
paves	10	48	3392	2	paves
pavis	10	64	2273	2	pavis
rakus	9	44	1367	2	rakus
ramus	7	64	1828	2	ramus
raves	8	54	4197	2	raves
saves	8	58	3863	2	saves
tabus	7	48	2092	2	tabus
talus	5	54	2326	2	talus
taus	4	63	4273	2	ta_us
tavs	7	56	3097	2	tav_s
taxus	12	55	1248	2	taxus
vagus	9	67	1381	2	vagus
varus	8	59	2118	2	varus
vatus	8	61	1464	2	vatus
vaus	7	59	2892	2	va_us
vavs	10	57	2043	2	vav_s
wamus	10	55	1468	2	wamus
waves	11	56	3392	2	waves

Search took 2 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	53800	0.330	541487.9
2	DLD Change Limit	53800	101	1.500	35866.7
3	Display Results	101	101	0.030	3366.7
	(SQL Overall)	178691	101	1.860	96070.4