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

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

240 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
daturas	8	3	877	(None)
datura	7	3	802	1	datura_
auras	5	59	3256	2	_a_uras
datchas	13	4	742	2	datchas
daters	7	48	2737	2	dater_s
datums	9	3	635	2	datu_ms
daturic	10	4	702	2	daturic
douras	7	50	1672	2	d_ouras
duras	6	57	2773	2	d__uras
katsuras	12	4	365	2	katsuras
lauras	6	34	1433	2	la_uras
matures	9	3	1430	2	matures
natural	7	3	951	2	natural
naturals	8	4	790	2	naturals
natures	7	3	1196	2	natures
paruras	9	3	1053	2	paruras
sataras	7	3	1506	2	sataras
adjures	15	3	623	3	adjures
agoras	7	6	1334	3	_agoras
ajugas	14	3	526	3	_ajugas
anural	6	57	1474	3	_anural
anuran	6	43	1324	3	_anuran
anurans	7	38	1055	3	_anurans
anurias	7	3	1225	3	_anurias
aquas	14	24	1261	3	_aqu_as
arras	5	56	2613	3	_a_rras
atlas	5	58	2158	3	_at_las
atmas	7	57	2101	3	_at_mas
attars	6	45	1531	3	_attars
aura	4	58	3625	3	_a_ura_
aurae	5	41	2811	3	_a_urae
aural	5	44	2896	3	_a_ural
aurar	5	44	2025	3	_a_urar
aures	5	51	3709	3	_a_ures
auris	5	53	3153	3	_a_uris
azures	15	5	1018	3	_azures
bravuras	13	4	344	3	bravuras
buras	7	47	3630	3	__buras
caesuras	10	5	573	3	caesuras
cameras	11	3	1336	3	cameras
canulas	9	3	1285	3	canulas
captures	12	3	944	3	captures
catenas	9	3	1311	3	catenas
cateran	9	3	1377	3	cateran
caterans	10	3	1322	3	caterans
caters	8	53	3650	3	cater_s
cesuras	9	5	869	3	cesuras
dachas	12	41	1325	3	da_chas
dadas	7	58	1986	3	da__das
daggas	9	3	797	3	da_ggas
dagobas	11	4	514	3	dagobas
dahlias	11	3	572	3	dahlias
damars	9	38	1499	3	damar_s
dammars	12	30	819	3	dammars
darbars	10	5	1009	3	darbars
darbs	8	53	2326	3	da__rbs
darers	7	59	2187	3	darer_s
dares	6	61	4670	3	da__res
darks	10	67	2787	3	da__rks
darns	6	69	2789	3	da__rns
darters	8	40	1760	3	darter_s
darts	6	76	3573	3	da__rts
dastards	10	27	808	3	dastards
dasyures	12	5	415	3	dasyures
data	5	60	2665	3	dat__a_
database	11	4	353	3	database
dataries	9	3	1403	3	dataries
datary	10	3	1024	3	datar_y
datcha	12	6	656	3	datcha_
dater	6	53	3231	3	dater__
dates	6	56	3915	3	dat__es
datival	11	3	558	3	datival
datives	11	3	1007	3	datives
datos	6	52	2278	3	dat__os
dattos	7	43	1190	3	dat_tos
datum	8	3	1063	3	datu__m
daubes	9	49	1370	3	da_ubes
daubs	8	50	1456	3	da_u_bs
daunts	7	50	1408	3	da_unts
dauties	8	33	1576	3	dauties
dauts	6	78	2224	3	da_u_ts
demurs	9	3	977	3	demur_s
denatures	10	3	812	3	denatures
dentural	9	4	808	3	dentural
dentures	9	3	1245	3	dentures
deters	7	47	2468	3	deter_s
detours	8	5	804	3	detour_s
dhooras	11	3	594	3	dhooras
dhourras	12	5	223	3	dhourras
dhurnas	11	5	344	3	d_hurnas
disturbs	11	4	540	3	disturbs
ditas	6	59	2367	3	dit__as
dobras	9	48	1191	3	d_obras
dotards	9	3	725	3	dotards
doters	7	44	2391	3	doter_s
doulas	7	51	1499	3	d_oulas
doumas	9	53	1481	3	d_oumas
doura	6	65	1866	3	d_oura_
dourah	10	47	981	3	d_ourah
dourahs	11	48	725	3	d_ourahs
dumas	8	54	2043	3	d__umas
dura	5	52	3211	3	d__ura_
dural	6	49	2389	3	d__ural
dures	6	56	3592	3	d__ures
durns	6	48	1987	3	d__urns
duros	6	54	2269	3	d__uros
durras	7	47	1337	3	d_urras
durrs	6	55	1999	3	d__urrs
dysurias	12	4	446	3	dysurias
eaters	6	55	3595	3	eater_s
extras	13	3	1022	3	ext_ras
factures	13	12	902	3	factures
fatuous	10	3	778	3	fatuous
fatwas	12	4	905	3	fat_was
faunas	9	40	1363	3	fa_unas
features	11	3	1033	3	features
futural	10	3	728	3	futural
futures	10	3	1026	3	futures
gaters	7	47	2864	3	gater_s
gators	7	41	1583	3	gator_s
gaurs	6	63	1799	3	ga_ur_s
haftaras	14	13	607	3	haftaras
haters	9	49	3040	3	hater_s
inturns	7	32	1013	3	inturns
jagras	14	3	846	3	ja_gras
jaguars	15	3	523	3	jaguars
kahunas	14	7	395	3	kahunas
katas	9	59	2209	3	kat__as
katsura	11	4	375	3	katsura_
kauris	10	36	1153	3	ka_uris
lacunas	9	13	817	3	lacunas
lagunas	8	15	682	3	lagunas
laterad	8	3	1084	3	laterad
lateral	7	3	1357	3	lateral
laterals	8	3	1275	3	laterals
latinas	7	44	1646	3	latinas
latrias	7	19	1321	3	latrias
laura	5	41	1620	3	la_ura_
laurae	6	40	1166	3	la_urae
maculas	11	31	1402	3	maculas
madras	9	43	1643	3	ma_dras
maduros	10	3	630	3	maduros
mantras	9	38	1586	3	mantras
mantuas	9	34	1099	3	mantu_as
manures	9	3	1335	3	manures
maras	7	54	4329	3	ma__ras
maters	8	50	3239	3	mater_s
matrass	9	3	940	3	mat_rass
matres	8	45	2223	3	mat_res
mattrass	10	4	586	3	mattrass
maturate	10	3	1261	3	maturate
maturates	11	3	1176	3	maturates
mature	8	3	1346	3	matur_e
matured	10	3	1003	3	matured
maturer	9	3	897	3	maturer
maturers	10	3	737	3	maturers
maturest	10	3	969	3	maturest
matzas	17	4	970	3	mat_zas
mazumas	20	3	462	3	mazumas
mazurkas	23	7	238	3	mazurkas
muras	7	53	2958	3	__muras
nairas	6	3	1278	3	na_iras
nature	6	3	1126	3	natur_e
natured	8	3	896	3	natured
naturism	10	4	789	3	naturism
naturist	8	4	1081	3	naturist
oaters	6	50	2979	3	oater_s
pakoras	13	3	747	3	pakoras
panduras	11	3	695	3	panduras
paras	7	61	4304	3	pa__ras
parura	8	3	1058	3	parura_
parures	9	5	1269	3	parures
pastural	10	3	841	3	pastural
pastures	10	3	1196	3	pastures
patacas	11	3	1100	3	patacas
paters	8	49	3583	3	pater_s
patinas	9	63	1852	3	patinas
pleuras	9	3	741	3	pleuras
radulas	8	3	958	3	radulas
ranulas	7	3	1177	3	ranulas
raptures	10	3	757	3	raptures
rasures	7	3	1201	3	rasures
raters	6	39	3658	3	rater_s
rattrap	9	4	526	3	rattrap
rattraps	10	4	482	3	rattraps
returns	7	97	1259	3	returns
sabras	8	51	1636	3	sa_bras
samaras	9	3	1291	3	samaras
samurai	9	4	592	3	samurai
samurais	10	4	614	3	samurais
santeras	8	3	1106	3	santeras
santurs	7	3	1076	3	santur_s
satara	6	3	1553	3	satara_
satires	7	26	1757	3	satires
satoris	7	3	1725	3	satoris
satrap	8	62	1255	3	sat_rap
satraps	9	50	1164	3	sat_raps
satsumas	10	4	357	3	satsumas
saturant	8	4	1064	3	saturant
saturants	9	4	638	3	saturants
saturate	8	3	1281	3	saturate
saturates	9	8	1160	3	saturates
satyrs	9	3	796	3	satyr_s
saunas	6	39	1543	3	sa_unas
saxtubas	17	4	191	3	saxtubas
spatulas	10	4	547	3	spatulas
statures	8	37	1111	3	statures
stupas	8	39	1088	3	_stupas
sturts	6	39	1514	3	_sturts
suras	5	53	3633	3	__suras
sutras	6	48	1859	3	sut_ras
sutural	7	3	1022	3	sutural
sutures	7	3	1422	3	sutures
talukas	11	31	621	3	talukas
tamburas	12	31	605	3	tamburas
tantaras	8	26	954	3	tantaras
tantras	7	31	1209	3	tantras
tatars	6	46	1979	3	tatar_s
taters	6	49	3220	3	tater_s
tetras	6	30	1762	3	tet_ras
toras	5	55	4037	3	__toras
tuataras	8	4	486	3	tuataras
tuateras	8	3	619	3	tuateras
tubas	7	51	1958	3	__tubas
tufas	8	53	1438	3	__tufas
tunas	5	42	2412	3	__tunas
turds	6	50	2169	3	__turds
turfs	8	46	2044	3	__turfs
turks	9	53	2082	3	__turks
turns	5	56	2324	3	__turns
turps	7	49	1873	3	__turps
ultras	6	3	1019	3	ult_ras
upturns	9	26	497	3	upturns
valutas	10	3	653	3	valutas
varas	8	60	2819	3	va__ras
vatus	8	61	1464	3	vatu__s
waftures	14	3	485	3	waftures
waters	9	50	3063	3	water_s
yantras	10	25	900	3	yantras
yautias	10	4	633	3	yautias

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	240	7.233	18529.9
3	Display Results	240	240	0.076	3157.9
	(SQL Overall)	178691	240	7.715	23161.5