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

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

105 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
telae	5	43	2329	(None)
stelae	6	37	1648	1	stelae
tela	4	55	3297	1	tela_
tele	4	50	4087	1	tel_e
alae	4	56	4375	2	_alae
belay	10	50	2152	2	belay
belie	7	56	3038	2	belie
belle	7	58	2783	2	belle
blae	6	61	3464	2	_blae
cellae	8	49	1593	2	cellae
chelae	11	36	1460	2	chelae
delate	7	38	2775	2	delate
delay	9	48	2063	2	delay
dele	5	68	4308	2	del_e
delve	9	60	1826	2	delve
elan	4	67	3424	2	_elan
elate	5	53	3588	2	_elate
else	4	59	2308	2	_else
gelate	7	34	2125	2	gelate
gelee	6	36	2698	2	gelee
helve	11	50	1809	2	helve
melee	7	37	2910	2	melee
pelage	9	5	1536	2	pelage
pele	6	55	3955	2	pel_e
relace	8	31	2215	2	relace
relate	6	40	3363	2	relate
relax	12	48	1780	2	relax
relay	8	44	2467	2	relay
selah	8	3	1961	2	selah
selle	5	44	2831	2	selle
setae	5	60	2622	2	setae
stela	5	40	1904	2	stela_
stelai	6	39	1256	2	stelai
stelar	6	40	1386	2	stelar
stele	5	50	2684	2	stel_e
tae	3	82	6705	2	t__ae
tala	4	59	3805	2	tala_
talar	5	62	2538	2	talar
talas	5	59	3589	2	talas
tale	4	61	5416	2	tal_e
tea	3	73	5332	2	te_a_
teak	8	59	3084	2	te_ak
teal	4	55	4650	2	te_al
teals	5	62	3413	2	teals
team	6	62	3865	2	te_am
tear	4	52	4288	2	te_ar
teas	4	58	5149	2	te_as
tease	5	54	2871	2	tease
teat	4	59	6363	2	te_at
tee	3	83	6687	2	te__e
tel	3	56	4790	2	tel__
telco	7	5	1187	2	telco
teles	5	45	3600	2	teles
telex	12	52	1482	2	telex
telfer	9	37	989	2	telfer
telia	5	58	2114	2	telia
telial	6	58	1536	2	telial
telic	7	60	1982	2	telic
tell	4	49	3470	2	tel_l
teller	6	35	1981	2	teller
tells	5	58	2894	2	tells
telly	8	49	2082	2	telly
telnet	6	5	1883	2	telnet
teloi	5	42	1738	2	teloi
telome	8	3	1192	2	telome
telos	5	54	2452	2	telos
tels	4	68	4169	2	tel_s
tenace	8	27	1569	2	tenace
tenge	6	57	2043	2	tenge
teniae	6	45	1735	2	teniae
tense	5	52	2584	2	tense
tepa	6	60	2168	2	tepa_
tepal	7	63	1958	2	tepal
tepas	7	65	2168	2	tepas
tepee	7	47	2421	2	tepee
terai	5	35	2548	2	terai
terce	7	57	2184	2	terce
terne	5	64	2615	2	terne
terrae	6	29	1520	2	terrae
terse	5	50	2682	2	terse
tesla	5	56	1260	2	tesla_
teslas	6	42	1217	2	teslas
testae	6	42	1625	2	testae
texas	12	65	1493	2	texas
thae	7	68	2556	2	t_hae
thecae	11	29	965	2	thecae
tilak	9	10	1155	2	tilak
tilde	6	50	1734	2	tilde
tile	4	54	5144	2	til_e
togae	6	70	2011	2	togae
tola	4	52	3633	2	tola_
tolan	5	51	2401	2	tolan
tolane	6	43	1658	2	tolane
tolar	5	55	2411	2	tolar
tolas	5	45	3277	2	tolas
tole	4	60	5290	2	tol_e
tubae	7	47	1664	2	tubae
tule	4	57	3587	2	tul_e
tulle	5	40	1993	2	tulle
twae	7	47	1957	2	t_wae
twelve	12	3	416	2	twelve
vela	7	57	2554	2	vela_
velar	8	58	1763	2	velar
velate	9	37	2014	2	velate
venae	8	59	2098	2	venae

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.093	1921408.6
2	DLD Change Limit	53800	105	1.780	30224.7
3	Display Results	105	105	0.030	3500.0
	(SQL Overall)	178691	105	1.903	93899.6