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

Here are the results of your fuzzy-string dictionary search for “aural” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

109 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
aural	5	44	2896	(None)
anural	6	57	1474	1	anural
aura	4	58	3625	1	aura_
aurae	5	41	2811	1	aurae
aurar	5	44	2025	1	aurar
auras	5	59	3256	1	auras
dural	6	49	2389	1	dural
jural	12	51	2048	1	jural
mural	7	52	2511	1	mural
rural	5	58	2117	1	rural
sural	5	59	3126	1	sural
aal	3	90	5867	2	a__al
aboral	8	3	1437	2	aboral
aerial	6	46	2571	2	aerial
algal	6	65	1822	2	algal
amoral	8	3	1463	2	amoral
anal	4	80	3752	2	a_nal
annal	5	65	2076	2	annal
antral	6	57	1941	2	antral
anuran	6	43	1324	2	anuran
aortal	6	52	1751	2	aortal
appal	9	53	1522	2	appal
arak	8	69	2958	2	a_rak
areal	5	59	2874	2	areal
argal	6	50	2340	2	argal
aril	4	58	4302	2	a_ril
arras	5	56	2614	2	arras
array	8	63	1715	2	array
artal	5	55	2548	2	artal
arval	8	60	1702	2	arval
aryl	7	59	2234	2	a_ryl
astral	6	69	1928	2	astral
atrial	6	54	1894	2	atrial
audad	7	15	1139	2	audad
audial	7	3	1299	2	audial
augural	8	5	640	2	augural
aurally	10	3	1054	2	aurally
aurate	6	44	2647	2	aurate
aurei	5	48	2186	2	aurei
aures	5	51	3709	2	aures
auric	7	45	2174	2	auric
auris	5	53	3153	2	auris
auroral	7	3	1047	2	auroral
aurum	7	6	1496	2	aurum
austral	7	34	1151	2	austral
axal	11	65	2049	2	a_xal
axial	12	45	1519	2	axial
boral	7	58	3170	2	boral
bubal	9	42	1821	2	bubal
bura	6	61	3953	2	bura_
buran	7	52	2530	2	buran
buras	7	47	3630	2	buras
burial	8	41	1762	2	burial
burl	6	49	3718	2	bur_l
bursal	8	44	1482	2	bursal
caudal	9	16	1148	2	caudal
causal	8	14	1320	2	causal
coral	7	60	3345	2	coral
crural	8	6	1063	2	crural
curial	8	40	1915	2	curial
curl	6	60	3505	2	cur_l
curtal	8	39	1454	2	curtal
dual	5	59	2817	2	du_al
ducal	8	48	1642	2	ducal
dura	5	52	3211	2	dura_
duras	6	57	2773	2	duras
faucal	11	33	996	2	faucal
faunal	9	47	1159	2	faunal
feral	8	54	2465	2	feral
fugal	9	56	1303	2	fugal
furan	8	43	2001	2	furan
furl	7	70	3088	2	fur_l
goral	6	51	2575	2	goral
gyral	9	44	1278	2	gyral
horal	8	63	2868	2	horal
hurl	7	60	2993	2	hur_l
jugal	13	56	1240	2	jugal
jura	11	60	2489	2	jura_
jurat	12	48	2932	2	jurat
jurel	12	45	1633	2	jurel
laura	5	41	1620	2	laura_
laurae	6	40	1166	2	laurae
lauras	6	34	1433	2	lauras
laurel	6	4	903	2	laurel
loral	5	59	2782	2	loral
moral	7	55	3343	2	moral
mura	6	56	3330	2	mura_
murals	8	40	1676	2	murals
muras	7	53	2958	2	muras
natural	7	3	951	2	natural
neural	6	3	1199	2	neural
nurl	4	53	2724	2	nur_l
oral	4	76	3812	2	_oral
parral	8	55	1754	2	parral
pausal	8	15	1196	2	pausal
plural	8	3	982	2	plural
pupal	9	76	1687	2	pupal
purl	6	56	3142	2	pur_l
rugal	6	59	1609	2	rugal
sacral	8	34	1441	2	sacral
saurel	6	5	1199	2	saurel
seral	5	63	3638	2	seral
sura	4	57	4029	2	sura_
surah	8	68	2325	2	surah
suras	5	53	3633	2	suras
tubal	7	55	1720	2	tubal
ureal	5	67	2268	2	_ureal
urial	5	48	2302	2	_urial
viral	8	64	1959	2	viral

Search took 2 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	53800	0.313	570897.8
2	DLD Change Limit	53800	109	1.483	36277.8
3	Display Results	109	109	0.033	3303.0
	(SQL Overall)	178691	109	1.829	97698.7