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

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

59 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
altars	6	45	1815	(None)
altar	5	55	2064	1	altar_
alters	6	49	2422	1	alters
attars	6	45	1531	1	attars
actors	8	10	1677	2	actors
afars	8	57	1651	2	a_fars
afters	9	47	1707	2	afters
agars	6	61	2064	2	a_gars
alans	5	56	3617	2	al_ans
alar	4	63	4007	2	al_ar_
alarm	7	66	2142	2	al_arm
alarms	8	59	1305	2	al_arms
alary	8	61	2344	2	al_ary
alas	4	63	5812	2	al_a_s
alates	6	48	3397	2	alates
albas	7	59	2539	2	alba_s
alders	7	42	1842	2	alders
alegars	8	3	893	2	alegars
alfas	8	72	1904	2	alfa_s
algas	6	56	2493	2	alga_s
algors	7	3	1255	2	algors
alias	5	58	3460	2	alia_s
allays	9	43	1374	2	allays
almahs	11	86	1161	2	almahs
almas	7	66	2977	2	alma_s
alter	5	48	2850	2	alter_
altos	5	58	2295	2	alt_os
alts	4	66	3990	2	alt__s
always	12	40	913	2	always
anears	6	37	1718	2	anears
antas	5	54	3203	2	anta_s
antiars	7	3	1462	2	antiars
asters	6	56	3160	2	asters
ataps	7	64	1483	2	a_taps
atlas	5	58	2158	2	atla_s
attar	5	65	1669	2	attar_
avatars	10	3	644	2	avatars
blears	8	51	1645	2	blears
calcars	11	3	1265	2	calcars
clears	8	41	1656	2	clears
falters	10	39	1647	2	falters
halters	10	46	1980	2	halters
kantars	11	3	1003	2	kantars
lahars	9	40	1316	2	lahars
lars	4	69	5657	2	_l_ars
lazars	15	38	1239	2	lazars
lears	5	59	3873	2	_lears
liars	5	47	2316	2	_liars
malars	8	50	2068	2	mal_ars
ottars	6	41	1222	2	ottars
palters	9	40	2168	2	palters
salters	7	36	2225	2	salters
sitars	6	54	1759	2	sitars
stars	5	58	3657	2	_stars
talars	6	60	2168	2	tal_ars
tars	4	67	6395	2	__tars
tartars	7	33	1340	2	tartars
tatars	6	46	1979	2	tatars
ultras	6	3	1019	2	ultras

Search took 4 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	82551	0.373	479064.3
2	DLD Change Limit	82551	59	2.656	31080.9
3	Display Results	59	59	0.016	3687.5
	(SQL Overall)	178691	59	3.045	58683.4