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

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

392 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
rascal	8	5	1112	(None)
pascal	10	8	1237	1	pascal
rascals	9	5	966	1	rascals
basal	7	57	2228	2	bas_al
berascal	12	4	485	2	berascal
caecal	10	37	1373	2	caecal
casual	8	11	1286	2	casual
faecal	11	35	981	2	faecal
fascial	12	5	830	2	fascial
faucal	11	33	996	2	faucal
fiscal	11	3	933	2	fiscal
jacal	14	3	1370	2	ja_cal
laical	8	3	1232	2	laical
lascar	8	6	857	2	lascar
mescal	10	41	1348	2	mescal
nasal	5	62	1759	2	nas_al
nasial	6	4	1328	2	nasial
pascals	11	6	1001	2	pascals
paschal	14	15	724	2	paschal
racial	8	34	1924	2	racial
radial	7	40	2039	2	radial
radical	10	33	1279	2	radical
ramal	7	46	2224	2	ra_mal
rascally	13	4	773	2	rascally
ratal	5	50	2511	2	ra_tal
rescale	9	32	1547	2	rescale
reseal	6	48	1964	2	reseal
vasal	8	55	1629	2	vas_al
vassal	9	7	924	2	vassal
aal	3	90	5867	3	_a__al
acyl	9	53	1429	3	_a_cyl
aecial	8	48	1731	3	_aecial
algal	6	65	1822	3	_algal
anal	4	80	3752	3	_a_nal
annal	5	65	2076	3	_annal
apical	10	9	1390	3	apical
appal	9	53	1522	3	_appal
areal	5	59	2873	3	_areal
areca	7	56	1863	3	areca_
arecas	8	48	1744	3	arecas
argal	6	50	2339	3	_argal
arsenal	7	3	938	3	arsenal
artal	5	55	2547	3	_artal
arval	8	60	1701	3	_arval
asci	6	65	1914	3	_asc_i
ascot	7	65	2251	3	_ascot
ascus	7	50	1358	3	_ascus
asea	4	63	2718	3	_asea_
ashcan	11	3	584	3	_ashcan
asocial	9	9	865	3	_asocial
assai	5	7	1154	3	_assai
assail	6	6	1015	3	_assail
assay	8	7	1028	3	_assay
astral	6	69	1928	3	_astral
asyla	8	3	933	3	_asyla
aural	5	44	2896	3	_aural
axal	11	65	2049	3	_a_xal
axial	12	45	1519	3	_axial
baal	6	70	3311	3	ba__al
bacca	11	10	1218	3	bacca_
baccae	12	11	970	3	baccae
banal	7	59	2599	3	ba_nal
barbal	10	40	1666	3	barbal
barca	9	13	1943	3	barca_
barcas	10	10	1660	3	barcas
basalt	8	35	1958	3	bas_alt
bascule	11	3	657	3	bascule
bashaw	14	34	930	3	bashaw
basil	7	51	2227	3	bas_il
basinal	9	3	1003	3	basinal
berascals	13	4	350	3	berascals
brasil	8	7	1386	3	bras_il
buccal	12	4	824	3	buccal
byssal	11	3	499	3	byssal
cabal	9	52	2215	3	ca_bal
caca	8	55	2808	3	ca_ca_
cacao	9	54	2000	3	ca_cao
cacas	9	56	2798	3	ca_cas
caeca	9	39	1513	3	caeca_
calcar	10	3	1275	3	calcar
canal	7	54	2804	3	ca_nal
cancan	10	3	1410	3	cancan
cancel	10	53	1668	3	cancel
cantal	8	41	2203	3	cantal
caracal	11	3	1251	3	caracal
carcel	10	50	1867	3	carcel
carnal	8	39	1920	3	carnal
carpal	10	37	1625	3	carpal
casa	6	56	3086	3	cas_a_
casas	7	53	2784	3	cas_as
casbah	13	3	790	3	casbah
cascabel	14	17	450	3	cascabel
cascable	14	15	1062	3	cascable
cascade	12	11	860	3	cascade
cascara	11	3	831	3	cascara
cashaw	14	43	979	3	cashaw
casuals	9	14	1052	3	casuals
catcall	11	3	915	3	catcall
caudal	9	16	1148	3	caudal
causal	8	14	1320	3	causal
cecal	9	46	1911	3	_cecal
cercal	10	3	1412	3	cercal
chasmal	14	15	821	3	chasmal
coastal	9	4	1104	3	coastal
coccal	9	3	1022	3	coccal
costal	8	54	1951	3	costal
craal	7	41	1775	3	cra__al
cranial	9	21	1468	3	cranial
crestal	9	3	1213	3	crestal
crissal	9	3	741	3	crissal
crustal	9	3	902	3	crustal
crystal	12	3	743	3	crystal
cuspal	10	3	788	3	cuspal
daedal	8	4	908	3	daedal
decal	8	55	2323	3	_decal
dismal	9	24	1224	3	dismal
distal	7	36	1577	3	distal
dossal	7	55	1030	3	dossal
ducal	8	48	1642	3	_ducal
easel	5	45	2111	3	eas_el
epical	10	4	1339	3	epical
escar	7	40	1199	3	_escar
facial	11	36	1563	3	facial
fallal	9	36	1269	3	fallal
farfal	12	34	1018	3	farfal
fasces	11	49	1454	3	fasces
fascia	11	4	870	3	fascia
fasciae	12	4	752	3	fasciae
fascias	12	5	841	3	fascias
fatal	8	48	1937	3	fa_tal
faucals	12	32	656	3	faucals
faucial	12	5	732	3	faucial
faunal	9	47	1159	3	faunal
fecal	10	51	1921	3	_fecal
festal	9	42	1356	3	festal
fiscals	12	3	800	3	fiscals
focal	10	49	1767	3	_focal
fracas	11	3	1199	3	fra_cas
fractal	12	3	762	3	fractal
gasbag	10	3	541	3	gasbag
gascon	9	33	972	3	gascon
gasman	9	29	1174	3	gasman
gastral	8	32	955	3	gastral
gavial	10	3	1008	3	gavial
gayal	9	3	1271	3	ga_yal
graal	6	43	1650	3	gra__al
gradual	9	3	694	3	gradual
grayscale	15	4	265	3	grayscale
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	2311	3	ha_mal
hammal	13	45	1206	3	hammal
hartal	9	4	1547	3	hartal
hassel	9	56	1421	3	hassel
instal	6	7	1219	3	instal
jacals	15	3	987	3	ja_cals
jackal	19	3	761	3	jackal
kasbah	15	3	518	3	kasbah
kasha	12	47	1072	3	kasha_
kashas	13	33	1190	3	kashas
kraal	9	45	1182	3	kra__al
labial	8	47	1434	3	labial
larval	9	4	850	3	larval
lascars	9	7	901	3	lascars
local	7	48	2027	3	_local
macaw	12	3	1176	3	ma_caw
madcap	13	3	633	3	madcap
magical	12	3	978	3	magical
mammal	9	51	1275	3	mammal
manual	8	3	1346	3	manual
marasca	11	3	682	3	marasca_
marascas	12	4	738	3	marascas
marcel	10	37	1485	3	marcel
marshal	12	3	897	3	marshal
masa	6	50	3472	3	mas_a_
masala	8	3	1181	3	mas_ala
masas	7	56	3041	3	mas_as
mascara	11	3	802	3	mascara
mascon	10	36	1274	3	mascon
mascot	10	40	1607	3	mascot
massa	7	55	1892	3	massa_
massas	8	51	1646	3	massas
mescals	11	29	1155	3	mescals
mesial	8	48	1808	3	mesial
mezcal	19	36	785	3	mezcal
miasmal	11	7	674	3	miasmal
miscall	11	3	964	3	miscall
miskal	12	37	1026	3	miskal
missal	8	43	1490	3	missal
musca	9	3	1176	3	musca_
muscae	10	4	1067	3	muscae
muscat	10	3	1465	3	muscat
musical	11	3	955	3	musical
narial	6	3	1795	3	narial
narwal	9	3	894	3	narwal
nasals	6	33	1246	3	nas_als
natal	5	39	2149	3	na_tal
naval	8	53	1583	3	na_val
paca	8	51	3224	3	pa_ca_
pacas	9	60	2940	3	pa_cas
paleal	8	47	1667	3	paleal
palpal	10	41	1205	3	palpal
papal	9	58	2067	3	pa_pal
parcel	10	39	1547	3	parcel
parral	8	55	1753	3	parral
paschals	15	6	647	3	paschals
pasha	10	54	1718	3	pasha_
pashas	11	51	1706	3	pashas
passel	8	51	1700	3	passel
pasta	7	66	2453	3	pasta_
pastas	8	54	2287	3	pastas
pastel	8	59	1871	3	pastel
pastil	8	50	1832	3	pastil
pausal	8	15	1196	3	pausal
phaseal	12	4	567	3	phaseal
phrasal	12	4	616	3	phras_al
pical	9	55	2437	3	_pical
plical	10	4	1168	3	plical
postal	8	43	1753	3	postal
rabat	7	28	3222	3	ra_bat
race	6	67	4626	3	ra_c_e
raced	8	76	3531	3	ra_ced
racer	7	52	3302	3	ra_cer
races	7	49	4324	3	ra_ces
rachial	12	20	1217	3	rachial
racily	11	7	1517	3	ra_cily
rack	10	62	3488	3	ra_c_k
rackle	12	39	1729	3	ra_ckle
racks	11	50	2885	3	ra_cks
racon	7	54	2214	3	ra_con
racy	9	58	2568	3	ra_c_y
radar	6	13	1672	3	ra_dar
radiale	8	38	1352	3	radiale
radials	8	36	1463	3	radials
radian	7	41	1727	3	radian
radicals	11	26	1015	3	radicals
radicel	10	27	887	3	radicel
radula	7	4	931	3	radula
raga	5	59	3081	3	ra_ga_
ragas	6	53	2606	3	ra_gas
ragbag	10	4	546	3	ragbag
raglan	7	37	1150	3	raglan
ragman	9	40	1371	3	ragman
ragtag	8	3	664	3	ragtag
raia	4	66	3838	3	ra_ia_
raias	5	46	3112	3	ra_ias
rail	4	61	4776	3	ra__il
railcar	9	4	548	3	railcar
raita	5	46	2307	3	raita_
raitas	6	44	1767	3	raitas
raja	11	79	1868	3	ra_ja_
rajah	15	57	1142	3	ra_jah
rajas	12	73	1772	3	ra_jas
rambla	10	35	1093	3	rambla
ramtil	8	3	1102	3	ramtil
rance	7	50	2851	3	ranc_e
rances	8	46	2544	3	rances
ranch	10	50	1979	3	ranc_h
rancho	11	43	1085	3	rancho
rancid	9	5	1386	3	rancid
rancor	8	8	1037	3	rancor
randan	7	3	1525	3	randan
ransack	13	4	646	3	ransack
ranula	6	3	1181	3	ranula
raphae	11	43	1173	3	raphae
rappel	10	42	1195	3	rappel
ras	3	75	7539	3	ras___
rascality	14	4	599	3	rascal~~ity~~
rase	4	61	4998	3	ras__e
rased	6	50	3393	3	ras_ed
raser	5	56	3341	3	ras_er
rasers	6	45	2678	3	rasers
rases	5	54	4721	3	ras_es
rash	7	60	3993	3	ras__h
rasher	9	50	2412	3	rasher
rashes	9	53	3015	3	rashes
rashly	12	34	1021	3	rashly
rasing	7	43	3083	3	rasing
rasorial	8	4	822	3	rasorial
rasp	6	60	2916	3	ras__p
rasped	9	47	1520	3	rasped
rasper	8	39	1733	3	rasper
rasps	7	43	1666	3	ras_ps
raspy	10	65	1170	3	ras_py
rassle	6	38	1320	3	rassle
raster	6	47	3144	3	raster
rasure	6	3	1142	3	rasure
ratals	6	42	1958	3	ra_tals
ratan	5	37	2266	3	ra_tan
ratbag	9	5	656	3	ratbag
ratch	10	42	2136	3	ratc_h
ratel	5	42	2488	3	ra_tel
rattail	7	3	780	3	rattail
rattan	6	36	1360	3	rattan
ravel	8	46	2151	3	ra_vel
raya	7	52	2482	3	ra_ya_
rayah	11	60	1350	3	ra_yah
rayas	8	59	2205	3	ra_yas
real	4	57	5029	3	r__eal
reassail	8	4	575	3	reassail
recall	8	38	1572	3	r_ecall
recap	9	57	1802	3	r_ecap
recoal	8	41	1797	3	recoal
rectal	8	44	1813	3	rectal
redcap	11	5	849	3	redcap
redial	7	49	2311	3	redial
regal	6	50	2379	3	r_egal
regnal	7	48	1293	3	regnal
renal	5	59	2950	3	r_enal
rental	6	39	2202	3	rental
repeal	8	47	1828	3	repeal
resail	6	44	1873	3	resail
resale	6	40	2554	3	res_ale
resat	5	51	3968	3	res_at
resaw	8	41	1725	3	res_aw
resay	8	53	2054	3	res_ay
rescaled	11	33	1130	3	rescaled
rescales	10	34	1457	3	rescales
rescue	8	3	1300	3	rescue
reseals	7	39	1766	3	reseals
reseat	6	41	3149	3	reseat
reseau	6	42	1621	3	reseau
resell	6	42	1520	3	resell
resoak	10	3	1109	3	resoak
retial	6	47	2499	3	retial
retral	6	44	1974	3	retral
reveal	9	41	1505	3	reveal
rhinal	9	5	1019	3	rhinal
rial	4	59	3809	3	r__ial
rictal	8	31	1318	3	rictal
ritual	6	3	1062	3	ritual
rival	8	52	1650	3	r_ival
riyal	8	44	1343	3	r_iyal
roscoe	8	3	976	3	roscoe
rostral	7	3	1133	3	rostral
royal	8	50	1470	3	r_oyal
rugal	6	59	1609	3	r_ugal
rural	5	58	2117	3	r_ural
rustical	10	4	839	3	rustical
sabal	7	54	2248	3	sa_bal
sacral	8	34	1441	3	sacral
sal	3	64	6288	3	__s_al
salal	5	54	2570	3	sa_lal
sambal	10	52	1518	3	sambal
sandal	7	33	1728	3	sandal
sashay	12	3	836	3	sashay
scab	8	59	2671	3	__scab
scad	7	57	2577	3	__scad
scag	7	66	2689	3	__scag
scald	8	48	1812	3	__scald
scale	7	46	2914	3	__scale
scall	7	44	2037	3	__scall
scalp	9	52	1798	3	__scalp
scaly	10	47	1872	3	__scaly
scam	8	59	3235	3	__scam
scan	6	55	3045	3	__scan
scar	6	64	3420	3	__scar
scat	6	58	4837	3	__scat
seal	4	56	5437	3	__seal
sial	4	59	3883	3	__sial
sisal	5	42	1773	3	sis_al
sulcal	8	3	1127	3	sulcal
tamal	7	35	2262	3	ta_mal
tarnal	6	37	1650	3	tarnal
tarsal	6	33	1527	3	tarsal
tassel	6	60	1477	3	tassel
thecal	11	33	1030	3	thecal
tical	7	60	2149	3	_tical
tincal	8	39	1336	3	tincal
tragical	11	4	821	3	tragical
tramcar	11	3	559	3	tramcar
tussal	6	28	832	3	tussal
unseal	6	33	1547	3	unseal
upscale	11	13	632	3	upscale
uracil	8	3	1154	3	ura_cil
usual	5	3	1018	3	_usual
vagal	9	46	1363	3	va_gal
valval	12	39	886	3	valval
vandal	10	37	1383	3	vandal
vasa	7	65	2297	3	vas_a_
vascula	12	4	585	3	vascula
vassals	10	5	795	3	vassals
vatical	12	3	998	3	vatical
vesical	12	15	981	3	vesical
vestal	9	46	1557	3	vestal
visual	9	3	880	3	visual
vocal	10	47	1564	3	_vocal
wadmal	12	3	728	3	wadmal
wassail	10	5	613	3	wassail
yasmak	15	3	459	3	yasmak

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.143	1249587.4
2	DLD Change Limit	112716	392	6.030	18692.5
3	Display Results	392	392	0.110	3563.6
	(SQL Overall)	178691	392	6.283	28440.4