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

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

423 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
farfal	12	34	1018	(None)
farfals	13	26	850	1	farfals
farfel	12	43	1043	1	farfel
areal	5	59	2873	2	_areal
argal	6	50	2338	2	_argal
artal	5	55	2547	2	_artal
arval	8	60	1701	2	_arval
barbal	10	40	1666	2	barbal
carful	11	6	1097	2	carful
carnal	8	39	1920	2	carnal
carpal	10	37	1625	2	carpal
earful	9	5	896	2	earful
facial	11	36	1563	2	facial
faecal	11	35	981	2	faecal
fallal	9	36	1269	2	fallal
farad	9	57	2067	2	far_ad
fardel	10	47	1259	2	fardel
farfalle	14	4	506	2	farfalle
farfels	13	34	821	2	farfels
farl	7	63	3855	2	far__l
fatal	8	48	1937	2	fa_tal
faucal	11	33	996	2	faucal
faunal	9	47	1159	2	faunal
fearful	13	4	559	2	fearful
feral	8	54	2465	2	fer_al
ferial	9	46	2125	2	ferial
formal	11	32	1520	2	formal
hartal	9	4	1547	2	hartal
jarful	16	4	668	2	jarful
larval	9	4	850	2	larval
narial	6	3	1795	2	narial
narwal	9	3	894	2	narwal
parral	8	55	1753	2	parral
tarnal	6	37	1650	2	tarnal
tarsal	6	33	1527	2	tarsal
aal	3	90	5867	3	_a__al
aerial	6	46	2571	3	aerial
afar	7	67	2078	3	_a_far
affray	15	3	497	3	affray
alfa	7	76	2427	3	_alfa_
alfas	8	72	1904	3	_alfas
algal	6	65	1821	3	_algal
anal	4	80	3752	3	_a_nal
annal	5	65	2076	3	_annal
aortal	6	52	1751	3	aortal
appal	9	53	1522	3	_appal
arak	8	69	2957	3	_ar_ak
area	4	58	4339	3	_area_
areae	5	52	2974	3	_areae
areas	5	59	3577	3	_areas
arf	6	74	5337	3	_arf__
arfs	7	60	2996	3	_arf_s
argala	7	47	1266	3	_argala
argali	7	50	1374	3	_argali
argals	7	55	1770	3	_argals
argil	6	51	1688	3	_argil
argol	6	53	1726	3	_argol
arhat	8	3	2709	3	_arhat
aria	4	62	4542	3	_aria_
arias	5	54	3802	3	_arias
ariel	5	52	2897	3	_ariel
aril	4	58	4302	3	_ar_il
armful	11	6	716	3	_armful
arras	5	56	2613	3	_arras
array	8	63	1714	3	_array
artel	5	61	2274	3	_artel
artful	9	6	827	3	_artful
aryl	7	59	2234	3	_ar_yl
atrial	6	54	1894	3	atrial
aural	5	44	2896	3	_aural
awful	11	7	814	3	_awful
axal	11	65	2049	3	_a_xal
axial	12	45	1519	3	_axial
baal	6	70	3311	3	ba__al
bagful	12	3	721	3	bagful
banal	7	59	2599	3	ba_nal
barbel	10	43	1707	3	barbel
barca	9	13	1943	3	barca_
barcas	10	10	1660	3	barcas
barf	9	58	4440	3	barf__
barfed	12	54	1638	3	barfed
barfly	14	33	965	3	barfly
barfs	10	48	2600	3	barf_s
barman	10	35	1970	3	barman
barrel	8	45	1787	3	barrel
basal	7	57	2228	3	ba_sal
bharal	11	3	889	3	bhar_al
boral	7	58	3170	3	bor_al
boreal	8	48	1721	3	boreal
burial	8	41	1762	3	burial
bursal	8	44	1482	3	bursal
cabal	9	52	2215	3	ca_bal
caecal	10	37	1373	3	caecal
canal	7	54	2804	3	ca_nal
canful	11	6	1026	3	canful
cantal	8	41	2203	3	cantal
capful	13	6	817	3	capful
caracal	11	3	1251	3	caracal
carafe	11	54	1616	3	carafe
carat	7	50	4879	3	car_at
carcel	10	50	1867	3	carcel
careful	12	4	911	3	careful
carfare	12	3	1007	3	carfare
carfuls	12	4	913	3	carfuls
carinal	9	43	1822	3	carinal
carl	6	51	4478	3	car__l
carman	10	39	2074	3	carman
carol	7	51	2861	3	car_ol
carpale	11	34	1435	3	carpale
carpals	11	34	1462	3	carpals
carpel	10	54	1847	3	carpel
carrel	8	47	1863	3	carrel
cartel	8	50	2253	3	cartel
carvel	11	48	1757	3	carvel
casual	8	11	1286	3	casual
catfall	12	3	739	3	catfall
caudal	9	16	1148	3	caudal
causal	8	14	1320	3	causal
cercal	10	3	1412	3	cercal
cereal	8	3	1583	3	cereal
coral	7	60	3345	3	cor_al
corral	8	36	1625	3	corral
craal	7	41	1775	3	_craal
curial	8	40	1915	3	curial
curtal	8	39	1454	3	curtal
daedal	8	4	908	3	daedal
darbar	9	5	995	3	darbar
dareful	11	5	705	3	dareful
darnel	7	43	1218	3	darnel
dermal	9	36	1434	3	dermal
dorsal	7	46	1394	3	dorsal
dural	6	49	2389	3	dur_al
earflap	12	4	327	3	earflap
earfuls	10	3	686	3	earfuls
earl	4	58	3814	3	ear__l
earlap	8	3	718	3	earlap
earwax	16	6	473	3	earwax
facia	10	32	1846	3	facia_
faciae	11	29	1341	3	faciae
facials	12	33	1074	3	facials
facias	11	34	1580	3	facias
factful	15	3	637	3	factful
factual	12	4	672	3	factual
facula	11	29	1223	3	facula
faena	8	50	1420	3	faena_
faenas	9	44	1276	3	faenas
fail	7	48	4024	3	fa__il
fairway	16	4	433	3	fairway
falafel	13	8	390	3	falafel
falbala	12	3	587	3	falbala
fall	7	55	3531	3	fa__ll
fallals	10	33	1019	3	fallals
fanfare	13	3	667	3	fanfare
fanfic	14	3	631	3	fanfic
fanfold	14	8	537	3	fanfold
fanga	9	61	1962	3	fanga_
fangas	10	50	1719	3	fangas
fantail	10	3	1023	3	fantail
far	6	77	6260	3	far___
faraday	14	4	563	3	faraday
farads	10	47	1327	3	farads
faraway	16	4	541	3	faraway
farce	10	49	2532	3	far_ce
farced	12	52	1653	3	farced
farcer	11	50	1608	3	farcer
farces	11	52	2332	3	farces
farci	10	59	1931	3	far_ci
farcical	15	4	695	3	farcical
farcie	11	48	1647	3	farcie
farcy	13	52	1709	3	far_cy
fard	8	56	3906	3	far__d
farded	11	45	1895	3	farded
fardels	11	38	989	3	fardels
fards	9	66	2984	3	far_ds
fare	7	63	5446	3	far__e
fared	9	58	4234	3	far_ed
farer	8	67	3314	3	far_er
farers	9	59	2405	3	farers
fares	8	58	5287	3	far_es
farina	9	46	1823	3	farina
farinas	10	32	1523	3	farinas
faring	10	52	3128	3	faring
farle	8	69	2924	3	far_le
farles	9	60	2578	3	farles
farls	8	57	3111	3	far_ls
farm	9	59	3453	3	far__m
farmable	15	3	820	3	farmable
farmed	12	51	1765	3	farmed
farmer	11	50	1737	3	farmer
farms	10	63	2495	3	far_ms
faro	7	61	3692	3	far__o
faros	8	55	3202	3	far_os
farrago	11	4	492	3	farrago
farrow	12	30	997	3	farrow
fart	7	68	6056	3	far__t
farted	10	51	2178	3	farted
farts	8	83	3684	3	far_ts
fascial	12	5	830	3	fascial
fateful	13	9	751	3	fateful
fatwa	11	6	806	3	fatwa_
fatwas	12	4	905	3	fatwas
faucals	12	32	656	3	faucals
faucial	12	5	732	3	faucial
fauna	8	48	1651	3	fauna_
faunae	9	52	1037	3	faunae
faunas	9	40	1363	3	faunas
fava	10	68	2026	3	fa_va_
favas	11	56	1859	3	fa_vas
favela	12	3	703	3	favela
feal	7	139	4042	3	f__eal
fecal	10	51	1921	3	f_ecal
fecial	11	47	1462	3	fecial
ferals	9	42	1664	3	fer_als
ferbam	13	3	900	3	ferbam
feria	8	59	2271	3	feria_
feriae	9	56	1860	3	feriae
ferias	9	50	2039	3	ferias
ferrel	9	28	1020	3	ferrel
ferula	9	30	1117	3	ferula
festal	9	42	1356	3	festal
fetal	8	56	2337	3	f_etal
fetial	9	57	1619	3	fetial
feudal	10	3	768	3	feudal
filarial	11	4	786	3	filarial
filial	9	30	1325	3	filial
final	8	39	2203	3	f_inal
finial	9	28	1418	3	finial
firman	11	22	1134	3	firman
fiscal	11	3	933	3	fiscal
fitful	12	5	633	3	fitful
floral	9	43	1381	3	floral
foal	7	66	3092	3	f__oal
focal	10	49	1767	3	f_ocal
foetal	9	3	1188	3	foetal
fontal	9	3	1314	3	fontal
fora	7	59	3739	3	for_a_
foram	10	51	2493	3	for_am
foray	11	50	2397	3	for_ay
forbad	12	27	1050	3	forbad
forgat	10	40	1858	3	forgat
forkful	17	4	477	3	forkful
formals	12	33	1289	3	formals
format	11	30	2135	3	format
formful	15	4	518	3	formful
formol	11	29	1033	3	formol
formyl	14	27	644	3	formyl
foveal	12	3	770	3	foveal
fracas	11	3	1199	3	fracas
fractal	12	3	762	3	fractal
frae	7	53	3047	3	f_r_ae
frag	8	51	2627	3	f_r_ag
frail	8	52	2021	3	f_rail
frap	9	59	2581	3	f_r_ap
frat	7	56	4854	3	f_r_at
fray	10	54	2890	3	f_r_ay
frazil	18	4	722	3	frazil
freak	12	51	1524	3	f_reak
friar	8	54	1427	3	f_riar
frill	8	49	1756	3	f_rill
frugal	10	3	639	3	frugal
fugal	9	56	1303	3	f_ugal
fulfil	12	4	642	3	fulfil
fungal	10	38	873	3	fungal
furan	8	43	2001	3	fur_an
furfur	12	3	555	3	furfur
furfural	14	7	347	3	furfural
furl	7	70	3088	3	fur__l
garda	7	3	1676	3	garda_
gardai	8	3	966	3	gardai
gavial	10	3	1008	3	gavial
gayal	9	3	1271	3	ga_yal
gharial	11	3	734	3	gharial
goral	6	51	2575	3	gor_al
graal	6	43	1650	3	_graal
gyral	9	44	1278	3	gyr_al
hadal	9	55	1812	3	ha_dal
haemal	11	38	1164	3	haemal
halal	8	56	2359	3	ha_lal
hallal	9	44	1556	3	hallal
hamal	10	46	2310	3	ha_mal
hammal	13	45	1206	3	hammal
harl	7	57	4000	3	har__l
harmful	15	3	576	3	harmful
hartals	10	3	1302	3	hartals
hatful	12	10	874	3	hatful
herbal	11	25	1349	3	herbal
horal	8	63	2867	3	hor_al
irreal	6	5	782	3	irreal
jacal	14	3	1370	3	ja_cal
jackal	19	3	761	3	jackal
jarfuls	17	5	477	3	jarfuls
jarl	11	58	2813	3	jar__l
jarrah	16	3	668	3	jarrah
jarsful	17	4	460	3	jarsful
jural	12	51	2048	3	jur_al
karat	9	68	3759	3	kar_at
karma	11	34	1500	3	karma_
karmas	12	30	1373	3	karmas
kraal	9	45	1182	3	_kraal
labial	8	47	1433	3	labial
laical	8	3	1232	3	laical
lapful	11	5	648	3	lapful
lariat	6	6	2904	3	lariat
larva	8	3	1248	3	larva_
larvae	9	3	884	3	larvae
larvas	9	3	1023	3	larvas
lawful	12	3	549	3	lawful
loral	5	59	2782	3	lor_al
loreal	6	38	1431	3	loreal
mammal	9	51	1275	3	mammal
manful	11	6	1021	3	manful
manual	8	3	1346	3	manual
mara	6	74	4456	3	mar_a_
maras	7	54	4328	3	mar_as
marcel	10	37	1485	3	marcel
margay	12	3	1059	3	margay
maria	7	50	3288	3	maria_
marital	9	23	1418	3	marital
marka	11	46	2079	3	marka_
markas	12	47	1700	3	markas
marl	6	63	4161	3	mar__l
marram	10	3	1388	3	marram
marsala	9	3	958	3	marsala
marshal	12	3	897	3	marshal
martial	9	24	1541	3	martial
marvel	11	37	1200	3	marvel
moral	7	55	3343	3	mor_al
mortal	8	46	1685	3	mortal
mural	7	52	2510	3	mur_al
nakfa	12	3	609	3	nakfa_
nakfas	13	3	468	3	nakfas
narwals	10	3	698	3	narwals
narwhal	13	4	433	3	narwhal
nasal	5	62	1759	3	na_sal
nasial	6	4	1328	3	nasial
natal	5	39	2149	3	na_tal
naval	8	53	1583	3	na_val
normal	8	32	1353	3	normal
offal	11	3	624	3	_offal
oral	4	76	3812	3	_or_al
ovarial	10	3	761	3	ovarial
paleal	8	47	1667	3	paleal
palpal	10	41	1205	3	palpal
panful	11	7	974	3	panful
papal	9	58	2067	3	pa_pal
para	6	52	4217	3	par_a_
parae	7	63	3570	3	par_ae
paras	7	61	4304	3	par_as
parcel	10	39	1547	3	parcel
pardah	12	34	1282	3	pardah
parfait	12	3	1205	3	parfait
parfocal	15	6	539	3	parfocal
pariah	11	43	2058	3	pariah
parian	8	32	2396	3	parian
parka	11	51	2088	3	parka_
parkas	12	50	1802	3	parkas
parlay	11	37	1399	3	parlay
parol	7	48	2627	3	par_ol
parrals	9	44	1457	3	parrals
parrel	8	45	1598	3	parrel
partan	8	38	2056	3	partan
partial	9	26	1626	3	partial
pascal	10	8	1237	3	pascal
pausal	8	15	1196	3	pausal
portal	8	42	1846	3	portal
racial	8	34	1924	3	racial
radial	7	40	2039	3	radial
ramal	7	46	2224	3	ra_mal
rascal	8	5	1112	3	rascal
ratal	5	50	2511	3	ra_tal
real	4	57	5029	3	__real
rial	4	59	3809	3	__rial
rural	5	58	2117	3	rur_al
sabal	7	54	2248	3	sa_bal
sacral	8	34	1441	3	sacral
safrol	9	3	728	3	safrol
salal	5	54	2570	3	sa_lal
sambal	10	52	1518	3	sambal
sandal	7	33	1728	3	sandal
saran	5	37	3030	3	sar_an
sardar	7	30	1317	3	sardar
sarsar	6	30	1184	3	sarsar
seral	5	63	3638	3	ser_al
serial	6	46	2585	3	serial
serval	9	39	1341	3	serval
sural	5	59	3126	3	sur_al
tamal	7	35	2261	3	ta_mal
tarmac	10	3	1033	3	tarmac
tarpan	8	28	1429	3	tarpan
tarsals	7	25	1260	3	tarsals
tartan	6	42	1751	3	tartan
tartar	6	32	1475	3	tartar
tarzan	15	29	1075	3	tarzan
tearful	10	4	603	3	tearful
tergal	7	29	1283	3	tergal
trial	5	49	2635	3	_trial
unreal	6	44	1445	3	unreal
ureal	5	67	2268	3	_ureal
urial	5	48	2302	3	_urial
vagal	9	46	1363	3	va_gal
valval	12	39	886	3	valval
vandal	10	37	1383	3	vandal
vara	7	55	3088	3	var_a_
varas	8	60	2819	3	var_as
varia	8	58	2420	3	varia_
varias	9	50	1990	3	varias
varna	8	45	1617	3	varna_
varnas	9	42	1282	3	varnas
vasal	8	55	1629	3	va_sal
vassal	9	7	924	3	vassal
vatful	12	10	708	3	vatful
verbal	11	25	1366	3	verbal
vernal	9	35	1421	3	vernal
versal	9	30	1375	3	versal
viral	8	64	1959	3	vir_al
wadmal	12	3	728	3	wadmal
waeful	12	3	812	3	waeful
warfare	13	3	673	3	warfare
warsaw	12	3	619	3	warsaw
zaffar	21	38	504	3	zaffar
zarf	16	69	2912	3	zarf__
zarfs	17	47	1362	3	zarf_s
zoarial	16	4	692	3	zoarial

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	112716	0.140	1276364.3
2	DLD Change Limit	112716	423	5.893	19127.1
3	Display Results	423	423	0.123	3439.0
	(SQL Overall)	178691	423	6.156	29027.1