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

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

247 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
favelas	13	3	702	(None)
favela	12	3	703	1	favela_
favellas	14	4	616	1	favellas
akelas	10	3	1119	2	_akelas
faenas	9	44	1276	2	fa_enas
fanegas	11	4	571	2	fanegas
favas	11	56	1859	2	fav__as
favella	13	3	617	2	favella
faves	11	53	3142	2	fave__s
foveas	12	3	862	2	fove_as
foveolas	14	13	511	2	foveolas
gavels	10	59	1109	2	gavel_s
navels	9	57	1269	2	navel_s
ravels	9	47	1707	2	ravel_s
abeles	8	47	1939	3	_abeles
abelias	9	32	1356	3	_abelias
akela	9	3	1134	3	_akela_
alas	4	63	5812	3	_a__las
amebas	10	3	1145	3	_amebas
aneles	6	46	2629	3	_aneles
anlas	5	56	2693	3	_a_nlas
areas	5	59	3577	3	_are_as
arecas	8	48	1744	3	_arecas
arenas	6	50	2199	3	_arenas
areolas	7	10	1386	3	_areolas
arepas	8	55	1570	3	_arepas
atlas	5	58	2158	3	_a_tlas
avellan	10	3	729	3	_avellan
avens	8	64	1933	3	_ave_ns
avers	8	51	2731	3	_ave_rs
averts	9	57	1524	3	_averts
aves	7	61	4260	3	_ave__s
avgas	9	69	1213	3	_av_gas
axels	12	63	1363	3	_axel_s
babels	10	52	1672	3	babel_s
bagels	9	57	1231	3	bagel_s
balas	7	69	3721	3	ba__las
bevels	11	39	1398	3	bevel_s
cabalas	11	35	1600	3	cabalas
calesas	9	4	1183	3	calesas
callas	8	45	2675	3	ca_llas
camelias	12	5	1030	3	camelias
camels	10	52	1708	3	camel_s
cameras	11	3	1336	3	cameras
candelas	11	3	953	3	candelas
canellas	10	3	1056	3	canellas
canolas	9	3	1399	3	canolas
canulas	9	3	1285	3	canulas
capelan	11	3	900	3	capelan
capelans	12	3	801	3	capelans
carvels	12	49	1459	3	carvel_s
catenas	9	3	1311	3	catenas
cavallas	13	6	684	3	cavallas
caveat	11	4	1772	3	cave_at
caveats	12	3	980	3	caveats
caveman	14	3	707	3	caveman
caverns	12	45	1025	3	caverns
cavers	11	50	2684	3	cave_rs
caves	10	56	3970	3	cave__s
cavils	11	40	1439	3	cavil_s
cervelas	13	4	467	3	cervelas
chelas	11	38	1720	3	_chelas
davens	10	46	1291	3	dave_ns
devels	10	43	1390	3	devel_s
easels	6	59	1455	3	easel_s
eaves	8	52	3199	3	eave__s
fablers	12	48	1261	3	fablers
fables	11	49	2167	3	fa_bles
fabular	12	28	869	3	fabular
faceless	13	26	917	3	faceless
facemask	19	4	212	3	facemask
facers	11	55	1944	3	face_rs
faces	10	64	3943	3	face__s
facets	11	63	1665	3	face_ts
facials	12	33	1074	3	facials
facias	11	34	1580	3	fa_cias
facula	11	29	1223	3	facula_
faculae	12	32	1035	3	faculae
facular	12	28	1044	3	facular
fadeins	11	6	850	3	fadeins
fadeless	12	25	832	3	fadeless
faders	10	51	1746	3	fade_rs
fades	9	49	3286	3	fade__s
faecal	11	35	981	3	fa_ecal
faeces	11	47	1312	3	fa_eces
faena	8	50	1420	3	fa_ena_
failles	10	29	1413	3	failles
fails	8	56	3148	3	fa_il_s
fajitas	17	3	425	3	fajitas
fakeers	14	44	667	3	fakeers
fakers	13	42	1953	3	fake_rs
fakes	12	60	3248	3	fake__s
falbalas	13	4	547	3	falbalas
fallal	9	36	1269	3	fa_llal
fallals	10	33	1019	3	fa_llals
fallers	10	39	1799	3	fallers
falls	8	57	2765	3	fa__lls
fameless	13	25	920	3	fameless
fames	10	57	3592	3	fame__s
famulus	12	3	504	3	famulus
fanega	10	5	578	3	fanega_
fanes	8	46	3989	3	fane__s
fangas	10	50	1720	3	fa_ngas
fardels	11	38	989	3	fardel_s
farers	9	59	2405	3	fare_rs
fares	8	58	5287	3	fare__s
farfals	13	26	850	3	farfals
farfels	13	34	821	3	farfel_s
farinas	10	32	1524	3	farinas
farles	9	60	2578	3	fa_rles
farls	8	57	3111	3	fa_rl_s
fascias	12	5	841	3	fascias
fates	8	51	3923	3	fate__s
fatless	10	32	1220	3	fatless
fatwas	12	4	905	3	fa_twas
faucals	12	32	656	3	faucals
faulds	10	43	896	3	fa_ulds
faults	9	45	1355	3	fa_ults
faunas	9	40	1363	3	fa_unas
fauves	12	56	1042	3	fauve__s
fava	10	68	2026	3	fav__a_
fave	10	55	3296	3	fave___
faveolate	15	10	462	3	faveolate
favisms	15	3	544	3	favisms
favors	12	42	1140	3	fav_ors
favours	13	43	709	3	favours
favus	11	43	1173	3	fav__us
favuses	13	3	618	3	favuses
faxes	15	57	2665	3	faxe__s
fazendas	21	4	307	3	fazendas
fazes	17	55	2721	3	faze__s
feels	8	52	2304	3	f_eel_s
fellas	9	51	1696	3	f_ellas
fells	8	53	2738	3	f__ells
felts	8	53	2454	3	f__elts
ferulas	10	31	1075	3	ferulas
fetas	8	56	2440	3	f__etas
fevers	12	54	1489	3	feve_rs
fibulas	12	22	856	3	fibulas
fields	10	42	1104	3	f_ields
fivers	12	44	2092	3	five_rs
fives	11	60	2736	3	five__s
fjelds	17	41	447	3	f_jelds
fleas	8	64	2366	3	f_le_as
fovea	11	3	1048	3	fove_a_
foveae	12	3	756	3	fove_ae
foveal	12	3	770	3	fove_al
foveola	13	11	501	3	foveola_
foveolae	14	10	432	3	foveolae
foveolar	14	9	374	3	foveolar
foveoles	14	9	664	3	foveoles
fuels	8	71	1735	3	f_uel_s
fusels	9	44	1245	3	fusel_s
galas	6	57	3164	3	ga__las
galeas	7	46	1851	3	gale_as
galenas	8	33	1034	3	galenas
gamelan	10	10	664	3	gamelan
gamelans	11	11	584	3	gamelans
gavel	9	58	1518	3	gavel__
gaveled	12	39	913	3	gaveled
gavials	11	3	660	3	gavials
gravels	11	36	1114	3	gravel_s
halalas	10	42	1408	3	halalas
havens	12	45	1404	3	have_ns
havers	12	47	2148	3	have_rs
haves	11	60	3487	3	have__s
hawalas	13	34	835	3	hawalas
hazels	18	57	1008	3	hazel_s
hovels	12	54	1334	3	hovel_s
javas	15	59	1542	3	jav__as
javelin	17	30	698	3	javelin
javelinas	19	35	358	3	javelinas
javelins	18	27	773	3	javelins
kabalas	13	39	1106	3	kabalas
kamalas	13	33	912	3	kamalas
kavas	12	59	1995	3	kav__as
kevels	13	44	1071	3	kevel_s
kvells	13	34	661	3	_kvells
labels	8	45	1568	3	label_s
lamellas	10	9	816	3	lamellas
lapels	8	37	1204	3	lapel_s
lavas	8	54	2222	3	lav__as
laveers	10	32	936	3	laveers
lavers	9	45	2636	3	lave_rs
laves	8	60	3915	3	lave__s
levels	9	41	1328	3	level_s
maculas	11	31	1402	3	maculas
manilas	9	39	1587	3	manilas
marvels	12	38	1009	3	marvel_s
masalas	9	3	1205	3	masalas
mavens	11	43	1297	3	mave_ns
nalas	5	55	2836	3	na__las
navel	8	70	1657	3	navel__
naves	8	70	3038	3	nave__s
novellas	11	7	634	3	novellas
novels	9	55	1250	3	novel_s
novenas	10	3	689	3	novenas
oaves	8	49	2561	3	oave__s
paellas	9	4	1141	3	paellas
pakehas	16	3	531	3	pakehas
panels	8	47	1652	3	panel_s
patellas	10	3	910	3	patellas
pavers	11	50	2182	3	pave_rs
paves	10	48	3392	3	pave__s
payolas	12	14	897	3	payolas
qabalas	18	28	950	3	qabalas
radulas	8	3	958	3	radulas
ramblas	11	27	1026	3	ramblas
ranulas	7	3	1177	3	ranulas
ratels	6	45	1821	3	ratel_s
ravel	8	46	2151	3	ravel__
raveled	11	41	1363	3	raveled
raveler	10	42	1246	3	raveler
ravelers	11	33	1086	3	ravelers
ravelin	10	22	1102	3	ravelin
ravelins	11	30	1160	3	ravelins
ravelly	13	26	835	3	ravelly
ravens	9	39	1688	3	rave_ns
ravers	9	46	2818	3	rave_rs
raves	8	54	4197	3	rave__s
reveals	10	38	1272	3	reveals
revels	9	42	2057	3	revel_s
saveloy	13	3	466	3	saveloy
saveloys	14	4	401	3	saveloys
savers	9	38	2592	3	save_rs
saves	8	58	3863	3	save__s
tablas	8	37	1616	3	ta_blas
taels	5	68	2207	3	ta_el_s
talas	5	59	3589	3	ta__las
tavernas	11	36	504	3	tavernas
taverns	10	31	780	3	taverns
travels	10	47	1129	3	travel_s
uveas	8	49	1228	3	_uve_as
uvulas	9	4	652	3	_uvulas
veals	8	49	2619	3	__veals
vela	7	57	2554	3	__vela_
velar	8	58	1763	3	__velar
velars	9	39	1372	3	__velars
velds	9	56	1558	3	__velds
wallas	9	57	1939	3	wa_llas
waveless	14	3	748	3	waveless
wavelet	13	3	1094	3	wavelet
wavelets	14	3	615	3	wavelets
wavers	12	50	2247	3	wave_rs
waves	11	56	3392	3	wave__s
waveys	15	59	701	3	wave_ys
zarebas	18	3	630	3	zarebas

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	134027	0.406	440125.6
2	DLD Change Limit	134027	247	7.173	18684.9
3	Display Results	247	247	0.093	2655.9
	(SQL Overall)	178691	247	7.672	23291.3