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

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

333 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
dismal	9	24	1224	(None)
dismals	10	20	1024	1	dismals
dismay	12	22	947	1	dismay
distal	7	36	1577	1	distal
dermal	9	36	1434	2	dermal
desman	9	3	1169	2	desman
dial	5	59	3506	2	di__al
disbar	9	3	851	2	disbar
dismaler	11	3	790	2	dismaler
dismally	14	4	651	2	dismally
dismast	10	3	1123	2	dismast
dismays	13	23	743	2	dismays
disme	8	57	1624	2	dism_e
dismes	9	56	1767	2	dismes
dispel	9	3	1032	2	dispel
distil	7	36	1643	2	distil
domal	8	56	1920	2	d_omal
dossal	7	55	1030	2	dossal
fiscal	11	3	933	2	fiscal
gimmal	11	24	751	2	gimmal
hiemal	11	33	950	2	hiemal
kismat	12	30	1167	2	kismat
miasmal	11	7	674	2	miasmal
miskal	12	37	1026	2	miskal
missal	8	43	1490	2	missal
seismal	9	3	730	2	seismal
sisal	5	42	1773	2	sis_al
visual	9	3	880	2	visual
abysmal	14	5	397	3	abysmal
aidman	9	24	1062	3	aidman
airmail	9	4	621	3	airmail
airman	8	24	1422	3	airman
animal	8	50	1625	3	animal
basal	7	57	2228	3	bas_al
biaxal	15	3	609	3	biaxal
bima	8	67	2383	3	bi_ma_
bimah	12	70	1327	3	bi_mah
bimas	9	55	2174	3	bi_mas
binal	7	53	2382	3	bi_nal
bitmap	12	3	561	3	bitmap
bromal	10	3	1365	3	bromal
brumal	10	4	950	3	brumal
busman	10	3	1025	3	busman
byssal	11	3	499	3	byssal
casual	8	11	1286	3	casual
chasmal	14	15	821	3	chasmal
chiasmal	15	28	503	3	chiasmal
chrismal	15	7	517	3	chrismal
citral	8	11	1389	3	citral
comal	9	51	2513	3	_comal
costal	8	54	1951	3	costal
crissal	9	3	741	3	crissal
cuspal	10	3	788	3	cuspal
daedal	8	4	908	3	daedal
dal	4	75	5495	3	d___al
daman	8	48	2116	3	d_aman
damar	8	41	1773	3	d_amar
dammar	11	43	890	3	dammar
damsel	9	14	803	3	damsel
daysman	13	3	505	3	daysman
deal	5	63	4741	3	d__eal
decal	8	55	2323	3	d_ecal
decimal	12	3	808	3	decimal
dedal	7	57	1902	3	d_edal
deism	8	41	1603	3	deism__
deisms	9	44	1104	3	deism_s
denial	7	47	2051	3	denial
dental	7	43	1917	3	dental
derma	8	49	1851	3	derma_
dermas	9	41	1681	3	dermas
desalt	7	5	1831	3	des_alt
deskman	14	4	432	3	deskman
desmans	10	3	900	3	desmans
desmid	10	4	836	3	desmid
devisal	11	3	691	3	devis_al
dhal	8	67	1928	3	d__hal
dials	6	49	2534	3	di__als
diamin	9	3	1252	3	diamin
diastral	9	4	699	3	diastral
dicta	8	49	1563	3	dicta_
diel	5	90	3460	3	di__el
diesel	7	44	1040	3	diesel
digamy	13	3	589	3	digamy
digital	9	3	706	3	digital
diktat	11	3	1069	3	diktat
dill	5	52	3997	3	di__ll
dim	6	81	4649	3	di_m__
dime	7	62	3764	3	di_m_e
dimer	8	56	2560	3	di_mer
dimes	8	58	3304	3	di_mes
dimly	11	49	1348	3	di_mly
dimmable	15	3	611	3	dimmable
dimmed	12	41	1032	3	dimmed
dimmer	11	41	1261	3	dimmer
dimple	11	35	1279	3	di_mple
dimply	14	33	974	3	di_mply
dims	7	54	3502	3	di_m_s
dinar	6	63	1989	3	di_nar
diobol	9	3	688	3	diobol
diol	5	73	2913	3	di__ol
dioxan	14	6	577	3	dioxan
dipsas	9	35	989	3	dipsas
diquat	16	3	976	3	diquat
diram	8	44	1947	3	di_ram
dirams	9	44	1370	3	dirams
dirham	12	37	827	3	dirham
dirl	5	74	3002	3	di__rl
dirndl	8	3	425	3	dirndl
dis	4	64	5989	3	dis___
disable	10	5	1643	3	disable
disarm	9	3	1047	3	disarm
disband	11	3	824	3	disband
disbars	10	3	1032	3	disbars
disbud	10	16	571	3	disbud
disc	7	61	2323	3	dis__c
discant	10	30	1725	3	discant
discard	11	3	1021	3	discard
discase	10	29	1286	3	discase
disced	10	49	1465	3	disced
disci	8	58	1502	3	dis_ci
disco	8	56	1607	3	dis_co
discos	9	49	1521	3	discos
discs	8	53	1626	3	dis_cs
discus	9	45	1211	3	discus
disdain	9	3	851	3	disdain
disease	8	32	1384	3	disease
diseur	7	3	884	3	diseur
dish	8	63	2833	3	dis__h
dished	11	43	1871	3	dished
dishelm	13	3	583	3	dishelm
dishes	10	46	2265	3	dishes
dishful	14	5	543	3	dishful
dishpan	13	10	552	3	dishpan
dishrag	12	4	627	3	dishrag
dishy	12	57	1235	3	dis_hy
disk	9	66	2583	3	dis__k
disked	12	50	1576	3	disked
disks	10	54	1747	3	dis_ks
disloyal	12	6	470	3	disloyal
dismalest	12	4	631	3	dismal~~est~~
dismantle	12	4	504	3	dismantle
dismasts	11	3	751	3	dismasts
dismayed	15	3	574	3	dismayed
dismiss	10	3	815	3	dismiss
dismissal	12	5	266	3	dism~~iss~~al
disomic	12	3	876	3	disomic
disown	10	3	695	3	disown
dispart	10	11	1528	3	dispart
dispels	10	3	1050	3	dispels
display	13	3	666	3	display
disposal	11	4	702	3	disposal
disrate	8	14	1852	3	disrate
diss	5	64	3448	3	dis__s
dissave	11	3	941	3	dissave
disseat	8	38	1692	3	disseat
dissed	8	52	2018	3	dissed
disses	7	52	2596	3	disses
distaff	14	6	768	3	distaff
distain	8	3	1378	3	distain
distally	12	3	955	3	distally
distant	8	35	1995	3	distant
distill	8	30	1132	3	distill
distils	8	30	1580	3	distils
disuse	7	40	1284	3	disuse
disvalue	12	4	443	3	disvalue
dita	5	60	3252	3	di_ta_
ditas	6	59	2367	3	di_tas
diurnal	8	4	488	3	diurnal
diva	8	59	2088	3	di_va_
divan	9	61	1484	3	di_van
divas	9	54	1858	3	di_vas
diwan	9	57	1255	3	di_wan
dogma	9	61	1246	3	dogma_
dogmas	10	50	1124	3	dogmas
dolma	8	62	1417	3	dolma_
dolman	9	53	1240	3	dolman
dolmas	9	52	1304	3	dolmas
dorsal	7	46	1394	3	dorsal
dossals	8	37	929	3	dossals
dossel	7	48	1364	3	dossel
dossil	7	51	1090	3	dossil
dotal	6	49	1962	3	d_otal
douma	8	58	1770	3	douma_
doumas	9	53	1481	3	doumas
drama	8	51	1741	3	drama_
dramas	9	58	1465	3	dramas
dual	5	59	2817	3	d__ual
ducal	8	48	1642	3	d_ucal
ductal	9	3	899	3	ductal
duma	7	55	2445	3	d_uma_
dumas	8	54	2043	3	d_umas
dural	6	49	2389	3	d_ural
dustman	10	4	468	3	dustman
edictal	10	4	699	3	edictal
episomal	12	4	555	3	episomal
festal	9	42	1356	3	festal
filial	9	30	1325	3	filial
final	8	39	2203	3	fi_nal
finial	9	28	1418	3	finial
firman	11	22	1134	3	firman
fiscals	12	3	800	3	fiscals
fishmeal	16	4	266	3	fishmeal
formal	11	32	1520	3	formal
gasman	9	29	1174	3	gasman
gimbal	11	22	881	3	gimbal
gimel	8	3	1335	3	gi_mel
gimmals	12	22	582	3	gimmals
gingal	8	10	1015	3	gingal
gismo	8	4	886	3	gism_o
gismos	9	5	718	3	gismos
haemal	11	38	1164	3	haemal
hamal	10	46	2311	3	_hamal
hammal	13	45	1206	3	hammal
hemal	10	44	1980	3	_hemal
hiatal	9	3	1020	3	hiatal
hitman	11	27	1022	3	hitman
ideal	6	57	1639	3	_ideal
ileal	5	61	1808	3	_ileal
ilial	5	53	1784	3	_ilial
imam	8	17	1833	3	_i_mam
instal	6	7	1219	3	instal
isba	6	13	1088	3	_isba_
isbas	7	10	1040	3	_isbas
ism	5	63	2238	3	_ism__
isms	6	62	1347	3	_ism_s
jingal	14	9	859	3	jingal
jism	13	55	1477	3	jism__
jisms	14	45	800	3	jism_s
kinsman	13	3	596	3	kinsman
kismats	13	25	784	3	kismats
kismet	12	34	1462	3	kismet
lienal	6	39	1278	3	lienal
lima	6	57	3413	3	li_ma_
liman	7	59	2160	3	li_man
limas	7	56	2763	3	li_mas
lineal	6	56	1602	3	lineal
listel	6	42	1474	3	listel
mammal	9	51	1275	3	mammal
mescal	10	41	1348	3	mescal
mesial	8	48	1808	3	mesial
miasma	10	9	756	3	miasma_
miasmas	11	6	774	3	miasmas
minimal	11	40	1060	3	minimal
miscall	11	3	964	3	miscall
misdeal	10	3	766	3	misdeal
misdial	10	3	964	3	misdial
miseat	8	29	2570	3	miseat
mishap	13	3	886	3	mishap
miskals	13	36	976	3	miskals
mislay	11	35	1068	3	mislay
mismade	12	12	935	3	mismade
mismake	15	13	937	3	mismake
mismark	15	3	670	3	mismark
mismate	11	14	1535	3	mismate
mismet	10	37	2237	3	mismet
missals	9	39	1442	3	missals
missay	11	41	1214	3	missay
missel	8	52	1652	3	missel
mistral	9	10	1364	3	mistral
mitral	8	13	1432	3	mitral
nasal	5	62	1759	3	nas_al
nasial	6	4	1328	3	nasial
nidal	6	52	1710	3	ni_dal
nival	8	49	1577	3	ni_val
normal	8	32	1353	3	normal
oilman	8	3	948	3	oilman
osmol	7	13	857	3	_osmol
pascal	10	8	1237	3	pascal
pial	6	56	3670	3	pi__al
pibal	9	52	1732	3	pi_bal
pical	9	55	2437	3	pi_cal
pima	8	54	2865	3	pi_ma_
pimas	9	47	2510	3	pi_mas
pineal	8	48	1768	3	pineal
pinnal	8	48	1427	3	pinnal
pipal	9	51	1835	3	pi_pal
pistil	8	39	1507	3	pistil
pistol	8	33	1333	3	pistol
pitman	10	24	1212	3	pitman
postal	8	43	1753	3	postal
primal	10	40	1462	3	primal
ramal	7	46	2224	3	_ramal
rascal	8	5	1112	3	rascal
reseal	6	48	1964	3	reseal
rial	4	59	3809	3	ri__al
rictal	8	31	1318	3	rictal
ritual	6	3	1062	3	ritual
rival	8	52	1650	3	ri_val
riyal	8	44	1343	3	ri_yal
sal	3	64	6288	3	__s_al
seal	4	56	5437	3	__seal
sial	4	59	3883	3	__sial
sigma	8	45	1383	3	sigma_
sigmas	9	41	1136	3	sigmas
signal	7	37	1148	3	signal
sima	6	47	3078	3	si_ma_
simar	7	49	2081	3	si_mar
simas	7	57	2755	3	si_mas
sisals	6	30	1357	3	sis_als
small	7	40	1626	3	__small
smalt	7	47	2933	3	__smalt
stigmal	10	24	592	3	stigmal
stomal	8	52	1331	3	stomal
tamal	7	35	2262	3	_tamal
tibial	8	4	984	3	tibial
tical	7	60	2149	3	ti_cal
tidal	6	45	1644	3	ti_dal
timbal	10	25	1075	3	timbal
tincal	8	39	1336	3	tincal
tineal	6	62	1616	3	tineal
tinman	8	24	1114	3	tinman
tissual	7	4	519	3	tissual
titman	8	27	1100	3	titman
tussal	6	28	832	3	tussal
unseal	6	33	1547	3	unseal
usual	5	3	1018	3	_usual
vasal	8	55	1629	3	vas_al
vassal	9	7	924	3	vassal
vestal	9	46	1557	3	vestal
vial	7	67	3109	3	vi__al
vinal	8	57	2581	3	vi_nal
vineal	9	48	1474	3	vineal
viral	8	64	1959	3	vi_ral
visa	7	63	2387	3	vis_a_
visas	8	43	1765	3	vis_as
vista	8	54	1660	3	vista_
vistas	9	45	1327	3	vistas
visuals	10	3	685	3	visuals
vital	8	48	1967	3	vi_tal
wadmal	12	3	728	3	wadmal
wisha	11	49	1085	3	wisha_
withal	12	3	893	3	withal
yasmak	15	3	459	3	yasmak

Search took 6 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	333	5.500	20493.8
3	Display Results	333	333	0.110	3027.3
	(SQL Overall)	178691	333	5.750	31076.7