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

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

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.

42 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
decathletes	17	5	235	(None)
decathlete	16	5	221	1	decathlete_
athletes	11	5	788	3	___athletes
biathletes	15	5	269	3	_biathletes
deathless	13	3	522	3	de_athle_ss
decathlons	16	4	260	3	decathl_ons
decolletes	13	12	398	3	dec_olletes
nonathletes	14	5	319	3	nonathletes
pentathletes	17	6	175	3	pentathletes
triathletes	14	7	228	3	triathletes
aesthetes	12	4	623	4	ae_sth_etes
athlete	10	6	808	4	___athlete_
biathlete	14	4	279	4	_biathlete_
catalexes	18	4	591	4	__catalexes
catheter	13	3	815	4	__cath_eter
catheters	14	3	701	4	__cath_eters
cathexes	20	3	627	4	__cath_exes
deactivates	17	4	439	4	deactivates
dealates	9	27	1668	4	de_a__lates
deathbeds	16	4	218	4	de_athbe_ds
deathlike	17	5	382	4	de_athlike_
decaliter	12	4	798	4	deca__liter
decaliters	13	4	521	4	deca__liters
decameter	14	13	736	4	deca__meter
decameters	15	15	659	4	deca__meters
decapitates	16	5	564	4	decapitates
decathlon	15	4	257	4	decathl__on
decayless	15	4	286	4	deca_yle_ss
decollates	13	13	715	4	dec_ollates
decollete	12	12	478	4	dec_ollete_
deletes	8	31	1793	4	de____letes
depletes	11	28	1064	4	de___pletes
depthless	15	4	275	4	de_pthle_ss
diatheses	13	4	589	4	d_iath_eses
esthetes	11	4	774	4	_e_sth_etes
heathless	15	3	559	4	he_athle_ss
megatheres	16	4	485	4	megath_eres
metatheses	15	4	447	4	metath_eses
nonathlete	13	5	330	4	nonathlete_
pentathlete	16	5	199	4	pentathlete_
superathletes	18	6	344	4	superathletes
triathlete	13	5	264	4	triathlete_

Search took 10 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	148819	0.453	394461.4
2	DLD Change Limit	148819	42	8.656	17192.6
3	Display Results	42	42	0.030	1400.0
	(SQL Overall)	178691	42	9.139	19552.6