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

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

276 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
datura	7	3	803	(None)
daturas	8	3	878	1	daturas
aura	4	58	3625	2	_a_ura
data	5	60	2665	2	dat__a
datary	10	3	1024	2	datary
datcha	12	6	656	2	datcha
dater	6	53	3231	2	dater_
daters	7	48	2737	2	daters
datum	8	3	1063	2	datu_m
datums	9	3	635	2	datums
daturic	10	4	703	2	daturic
doura	6	65	1866	2	d_oura
dura	5	52	3211	2	d__ura
katsura	11	4	375	2	katsura
laura	5	41	1620	2	la_ura
mature	8	3	1347	2	mature
natural	7	3	951	2	natural
nature	6	3	1126	2	nature
parura	8	3	1058	2	parura
satara	6	3	1553	2	satara
adjure	14	3	584	3	adjure
agora	6	9	1433	3	_agora
ajuga	13	3	588	3	_ajuga
alula	5	3	1709	3	_alula
antra	5	65	2192	3	_antra
anural	6	57	1474	3	_anural
anuran	6	43	1324	3	_anuran
anuria	6	3	1312	3	_anuria
aqua	13	28	1396	3	_aqu_a
atma	6	81	2177	3	_at_ma
atria	5	60	2234	3	_atria
attar	5	65	1669	3	_attar
aurae	5	41	2811	3	_a_urae
aural	5	44	2896	3	_a_ural
aurar	5	44	2025	3	_a_urar
auras	5	59	3256	3	_a_uras
azure	14	9	1148	3	_azure
bacula	10	31	1267	3	bacula
bravura	12	5	360	3	bravura
bura	6	61	3953	3	__bura
caesura	9	5	623	3	caesura
camera	10	3	1369	3	camera
canula	8	3	1296	3	canula
capture	11	3	891	3	capture
catena	8	3	1248	3	catena
cater	7	48	4072	3	cater_
cateran	9	3	1377	3	cateran
caters	8	53	3650	3	caters
cesura	8	3	876	3	cesura
crura	7	3	1258	3	_crura
dacha	11	48	1257	3	da_cha
dada	6	64	2244	3	da__da
dafter	10	48	1334	3	dafter_
dagga	8	3	954	3	da_gga
dagoba	10	7	494	3	dagoba
dahlia	10	3	577	3	dahlia
dairy	9	70	1630	3	da_iry
damar	8	41	1774	3	damar_
damars	9	38	1500	3	damars
dammar	11	43	890	3	dammar
darb	7	60	3353	3	da__rb
darbar	9	5	995	3	darbar
dare	5	58	4886	3	da__re
darer	6	52	3079	3	darer_
darers	7	59	2187	3	darers
dark	9	51	3321	3	da__rk
darn	5	64	3462	3	da__rn
dart	5	58	5787	3	da__rt
darter	7	53	2036	3	darter_
darters	8	40	1760	3	darters
dastard	9	27	970	3	dastard
dasyure	11	5	382	3	dasyure
datchas	13	4	742	3	datchas
date	5	64	4332	3	dat__e
dated	7	55	3099	3	dat_ed
dates	6	56	3915	3	dat_es
dating	8	53	2648	3	dating
datival	11	3	558	3	datival
dative	10	3	1181	3	dative
dato	5	61	2994	3	dat__o
datos	6	52	2278	3	dat_os
datto	6	54	1642	3	dat_to
dattos	7	43	1190	3	dattos
daub	7	74	2344	3	da_u_b
daube	8	50	1530	3	da_ube
daubry	12	44	548	3	daubry
daubs	8	50	1456	3	da_ubs
dauby	11	52	1122	3	da_uby
daunt	6	59	2908	3	da_unt
daut	5	64	4356	3	da_u_t
dauted	8	41	1493	3	dauted
dautie	7	29	1470	3	dautie
dauts	6	78	2224	3	da_uts
decury	12	7	796	3	decury
demur	8	3	1116	3	demur_
demure	9	3	1153	3	demure
demurs	9	3	977	3	demurs
denature	9	3	807	3	denature
dentural	9	4	808	3	dentural
denture	8	3	1189	3	denture
deter	6	50	2804	3	deter_
deters	7	47	2468	3	deters
detour	7	7	819	3	detour_
detours	8	5	804	3	detours
dhoora	10	3	565	3	dhoora
dhourra	11	5	202	3	dhourra
dhurna	10	4	356	3	d_hurna
diptera	10	3	721	3	diptera
disturb	10	4	623	3	disturb
dita	5	60	3252	3	dit__a
dobra	8	50	1310	3	d_obra
dotard	8	3	905	3	dotard
doter	6	54	2862	3	doter_
doters	7	44	2391	3	doters
doula	6	57	1777	3	d_oula
douma	8	58	1770	3	d_ouma
dour	5	63	3043	3	d_our_
dourah	10	47	981	3	d_ourah
douras	7	50	1672	3	d_ouras
duma	7	55	2445	3	d__uma
dural	6	49	2389	3	d__ural
duras	6	57	2773	3	d__uras
dure	5	63	4181	3	d__ure
durn	5	61	2763	3	d__urn
duro	5	62	2802	3	d__uro
durr	5	56	2435	3	d__urr
durra	6	53	1579	3	d_urra
dysuria	11	4	492	3	dysuria
eater	5	46	3984	3	eater_
eaters	6	55	3595	3	eaters
eatery	9	53	1635	3	eatery
entera	6	42	1683	3	entera
extra	12	3	900	3	ext_ra
facture	12	10	892	3	facture
facula	11	29	1223	3	facula
fatwa	11	6	806	3	fat_wa
fauna	8	48	1651	3	fa_una
feature	10	3	985	3	feature
futural	10	3	728	3	futural
future	9	3	956	3	future
gater	6	45	3365	3	gater_
gaters	7	47	2864	3	gaters
gator	6	44	1603	3	gator_
gators	7	41	1583	3	gators
gaur	5	67	2335	3	ga_ur_
gaurs	6	63	1799	3	ga_urs
haftara	13	13	609	3	haftara
hater	8	50	3475	3	hater_
haters	9	49	3040	3	haters
inturn	6	34	1156	3	inturn
jagra	13	3	817	3	ja_gra
jaguar	14	3	528	3	jaguar
jura	11	60	2489	3	__jura
kahuna	13	9	410	3	kahuna
kata	8	56	2602	3	kat__a
katsuras	12	4	365	3	katsuras
kauri	9	38	1185	3	ka_uri
kaury	12	42	976	3	ka_ury
labara	8	37	1289	3	labara
labra	7	54	1546	3	la_bra
lacuna	8	11	812	3	lacuna
laguna	7	12	722	3	laguna
later	5	48	4392	3	later_
laterad	8	3	1084	3	laterad
lateral	7	3	1357	3	lateral
latina	6	56	2114	3	latina
latria	6	23	1359	3	latria
latu	4	79	3418	3	latu__
laurae	6	40	1166	3	la_urae
lauras	6	34	1433	3	la_uras
macula	10	30	1367	3	macula
maduro	9	3	698	3	maduro
makuta	12	3	639	3	makuta
mantra	8	41	1609	3	mantra
mantua	8	44	1202	3	mantu_a
manure	8	3	1365	3	manure
mara	6	74	4457	3	ma__ra
mater	7	44	3886	3	mater_
maters	8	50	3239	3	maters
maturate	10	3	1262	3	maturate
matured	10	3	1004	3	matured
maturer	9	3	898	3	maturer
matures	9	3	1431	3	matures
matza	16	3	1181	3	mat_za
mazuma	19	3	560	3	mazuma
mazurka	22	7	287	3	mazurka
mura	6	56	3330	3	__mura
naira	5	3	1474	3	na_ira
naturals	8	4	790	3	naturals
natured	8	3	896	3	natured
natures	7	3	1196	3	natures
oater	5	54	3373	3	oater_
oaters	6	50	2979	3	oaters
pakora	12	4	728	3	pakora
pandura	10	3	714	3	pandura
papula	10	30	1111	3	papula
para	6	52	4217	3	pa__ra
paruras	9	3	1053	3	paruras
parure	8	3	1252	3	parure
pastural	10	3	841	3	pastural
pasture	9	3	1146	3	pasture
pataca	10	3	1119	3	pataca
pater	7	47	4072	3	pater_
paters	8	49	3583	3	paters
patina	8	60	2219	3	patina
pleura	8	3	753	3	pleura
radula	7	4	931	3	radula
ranula	6	3	1181	3	ranula
rapture	9	3	739	3	rapture
rasure	6	3	1142	3	rasure
rater	5	49	4328	3	rater_
raters	6	39	3658	3	raters
rattrap	9	4	526	3	rattrap
return	6	232	2252	3	return
sabra	7	53	1785	3	sa_bra
sacra	7	45	1699	3	sa_cra
samara	8	3	1385	3	samara
samurai	9	4	593	3	samurai
santera	7	3	1130	3	santera
santur	6	3	1127	3	santur_
santurs	7	3	1076	3	santurs
sataras	7	3	1506	3	sataras
satire	6	32	1800	3	satire
satori	6	4	1584	3	satori
satrap	8	62	1255	3	sat_rap
satsuma	9	4	387	3	satsuma
saturant	8	4	1064	3	saturant
saturate	8	3	1281	3	saturate
satyr	8	4	848	3	satyr_
satyrs	9	3	796	3	satyrs
sauna	5	41	1755	3	sa_una
saury	8	43	1722	3	sa_ury
saxtuba	16	4	169	3	saxtuba
spatula	9	3	589	3	spatula
stature	7	44	1068	3	stature
stupa	7	41	1231	3	_stupa
sturt	5	60	2896	3	_sturt
sura	4	57	4029	3	__sura
sutra	5	42	1793	3	sut_ra
sutural	7	3	1022	3	sutural
suture	6	3	1320	3	suture
synura	9	3	598	3	synura
taluka	10	42	677	3	taluka
tambura	11	32	646	3	tambura
tantara	7	24	1082	3	tantara
tantra	6	37	1335	3	tantra
tatar	5	61	2206	3	tatar_
tatars	6	46	1979	3	tatars
tater	5	41	3861	3	tater_
taters	6	49	3220	3	taters
tetra	5	34	1795	3	tet_ra
tora	4	75	4599	3	__tora
tuatara	7	4	551	3	tuatara
tuatera	7	5	637	3	tuatera
tuba	6	54	2236	3	__tuba
tufa	7	50	1661	3	__tufa
tuna	4	51	2784	3	__tuna
turd	5	60	2762	3	__turd
turf	7	53	3405	3	__turf
turk	8	61	2586	3	__turk
turn	4	63	3039	3	__turn
ultra	5	3	936	3	ult_ra
upturn	8	28	624	3	upturn
vacua	10	5	1046	3	vacu_a
valuta	9	3	874	3	valuta
vara	7	55	3088	3	va__ra
vatu	7	65	2433	3	vatu__
vatus	8	61	1464	3	vatu_s
wafture	13	3	485	3	wafture
water	8	47	3331	3	water_
waters	9	50	3063	3	waters
watery	12	39	1449	3	watery
waur	7	68	1990	3	wa_ur_
yakuza	22	6	187	3	yakuza
yantra	9	44	962	3	yantra
yautia	9	3	725	3	yautia

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.410	435831.7
2	DLD Change Limit	112716	276	5.013	22484.7
3	Display Results	276	276	0.093	2967.7
	(SQL Overall)	178691	276	5.516	32395.0