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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

90 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
argal	6	50	2339	(None)
algal	6	65	1822	1	algal
areal	5	59	2873	1	areal
argala	7	47	1267	1	argala
argali	7	50	1375	1	argali
argals	7	55	1771	1	argals
argil	6	51	1688	1	argil
argol	6	53	1726	1	argol
artal	5	55	2547	1	artal
arval	8	60	1701	1	arval
aal	3	90	5867	2	a__al
aerial	6	46	2571	2	aerial
aga	4	104	4723	2	a_ga_
agar	5	87	2641	2	a_gar
agas	5	59	3884	2	a_gas
alga	5	79	2760	2	alga_
algae	6	53	1962	2	algae
algas	6	56	2493	2	algas
anal	4	80	3752	2	a_nal
anga	5	68	3135	2	anga_
angas	6	58	2798	2	angas
angel	6	50	1956	2	angel
annal	5	65	2076	2	annal
aortal	6	52	1751	2	aortal
appal	9	53	1522	2	appal
arak	8	69	2957	2	ar_ak
area	4	58	4339	2	area_
areae	5	52	2974	2	areae
areas	5	59	3577	2	areas
argalas	8	40	1109	2	argalas
argalis	8	42	1419	2	argalis
argils	7	52	1362	2	argils
argle	6	54	2156	2	argle
argols	7	45	1461	2	argols
argon	6	55	2059	2	argon
argot	6	77	2865	2	argot
argue	6	48	1844	2	argue
argus	6	67	1654	2	argus
argyle	10	6	606	2	argyle
argyll	10	3	364	2	argyll
arhat	8	3	2709	2	arhat
aria	4	62	4542	2	aria_
arias	5	54	3802	2	arias
ariel	5	52	2897	2	ariel
aril	4	58	4302	2	ar_il
arras	5	56	2613	2	arras
array	8	63	1714	2	array
artel	5	61	2274	2	artel
aryl	7	59	2234	2	ar_yl
atrial	6	54	1894	2	atrial
aural	5	44	2896	2	aural
avgas	9	69	1213	2	avgas
axal	11	65	2049	2	a_xal
axial	12	45	1519	2	axial
barbal	10	40	1666	2	barbal
carnal	8	39	1920	2	carnal
carpal	10	37	1625	2	carpal
craal	7	41	1775	2	craal
egal	5	51	1943	2	_egal
farfal	12	34	1018	2	farfal
frugal	10	3	639	2	frugal
fugal	9	56	1303	2	fugal
gal	4	60	5551	2	__gal
graal	6	43	1650	2	graal
hartal	9	4	1547	2	hartal
jugal	13	56	1240	2	jugal
kraal	9	45	1182	2	kraal
larval	9	4	850	2	larval
legal	6	57	1594	2	legal
margay	12	3	1059	2	margay
narial	6	3	1795	2	narial
narwal	9	3	894	2	narwal
oral	4	76	3812	2	or_al
organ	6	9	1539	2	organ
parral	8	55	1753	2	parral
raga	5	59	3081	2	raga_
ragas	6	53	2606	2	ragas
ramal	7	46	2224	2	ramal
ratal	5	50	2511	2	ratal
real	4	57	5029	2	_real
regal	6	50	2379	2	regal
rial	4	59	3809	2	_rial
rugal	6	59	1609	2	rugal
tarnal	6	37	1650	2	tarnal
tarsal	6	33	1527	2	tarsal
tergal	7	29	1283	2	tergal
trial	5	49	2635	2	trial
ureal	5	67	2268	2	ureal
urial	5	48	2302	2	urial
vagal	9	46	1363	2	vagal

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.300	595636.7
2	DLD Change Limit	53800	90	1.483	36277.8
3	Display Results	90	90	0.016	5625.0
	(SQL Overall)	178691	90	1.799	99328.0