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

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

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.

66 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
deejayed	20	4	244	(None)
decayed	14	30	933	2	d_ecayed
deejay	17	3	452	2	deejay__
deejays	18	4	343	2	deejay_s
defrayed	16	3	540	2	defrayed
delayed	12	33	1076	2	d_elayed
belayed	13	36	1008	3	_belayed
bendayed	15	3	487	3	bendayed
betrayed	14	3	630	3	betrayed
bewrayed	17	3	393	3	bewrayed
deaerated	11	3	1110	3	deaerated
dealated	10	32	1360	3	dealated
deaned	8	46	2045	3	d_e_aned
deaved	11	49	1655	3	d_e_aved
debased	11	33	1058	3	d_ebased
debated	11	39	1608	3	d_ebated
debeaked	16	3	461	3	debeaked
decayer	13	33	935	3	d_ecayer
deceased	12	4	771	3	deceased
declared	12	4	874	3	declared
declawed	15	4	592	3	declawed
decoyed	14	35	833	3	d_ecoyed
deeded	9	46	1554	3	dee__ded
deejaying	21	4	275	3	deejaying
deemed	10	47	1306	3	dee__med
deepened	12	3	565	3	deepened
deerweed	13	4	418	3	deerweed
deeryard	13	5	359	3	deeryard
defaced	14	29	1097	3	d_efaced
defamed	14	30	983	3	d_efamed
defeated	13	28	1216	3	defeated
defecated	16	3	749	3	defecated
deflated	13	34	1230	3	deflated
defoamed	15	35	624	3	defoamed
defrayer	15	3	493	3	defrayer
deglazed	20	3	495	3	deglazed
degraded	12	28	832	3	degraded
dejected	19	30	759	3	dejected
delated	9	37	2287	3	d_elated
delayer	11	30	1053	3	d_elayer
deleaded	11	4	833	3	deleaded
deleaved	13	4	657	3	deleaved
delegated	12	3	837	3	delegated
demeaned	12	3	728	3	demeaned
dentated	10	4	1170	3	dentated
deplaned	12	3	865	3	deplaned
deployed	15	3	590	3	deployed
depraved	15	3	554	3	depraved
derated	9	36	2350	3	d_erated
deviated	13	3	1104	3	deviated
dewaxed	19	31	605	3	d_ewaxed
dismayed	15	3	574	3	dismayed
drayed	11	59	1139	3	d__rayed
dreaded	10	36	1202	3	dre_aded
dreamed	11	43	1063	3	dre_amed
embayed	15	3	544	3	_embayed
enjoyed	18	3	452	3	_enjoyed
essayed	11	3	401	3	_essayed
heehawed	18	4	273	3	heehawed
reenjoyed	20	4	253	3	reenjoyed
relayed	11	32	1275	3	_relayed
replayed	14	24	862	3	replayed
seesawed	12	4	329	3	seesawed
teenaged	10	10	513	3	teenaged
veejay	19	3	370	3	veejay__
veejays	20	4	231	3	veejay_s

Search took 9 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	146162	0.160	1116818.8
2	DLD Change Limit	146162	66	8.123	17993.6
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	8.313	21495.4