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

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

77 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
dramady	14	4	355	(None)
dramedy	14	3	324	1	dramedy
drama	8	51	1741	2	drama__
dramas	9	58	1465	2	drama_s
gramary	13	5	590	2	gramary
ramada	9	3	1018	2	_ramada
aramid	9	33	1560	3	aramid_
aramids	10	28	1050	3	aramids
armada	9	3	878	3	ar_mada
brambly	16	29	625	3	brambly
brandy	12	47	1206	3	bra_ndy
bravado	13	4	360	3	bravado
bready	12	45	1118	3	br_eady
chamade	15	13	843	3	chamade
crampy	15	47	1099	3	cram_py
daddy	11	62	1256	3	d_a_ddy
damage	10	4	1077	3	d_amage
daman	8	48	2116	3	d_ama_n
damans	9	47	1598	3	d_amans
damar	8	41	1773	3	d_ama_r
damars	9	38	1499	3	d_amars
damask	13	3	584	3	d_amask
damply	14	33	789	3	d_amply
dandy	10	44	1670	3	d_a_ndy
datary	10	3	1024	3	d_atary
diamide	11	3	847	3	diamide
dismay	12	22	947	3	disma_y
drably	12	35	1161	3	dra_bly
draffy	16	48	663	3	dra_ffy
drafty	13	63	893	3	dra_fty
draggy	12	34	682	3	dra_ggy
dram	7	58	3200	3	dram___
dramadies	13	4	480	3	dramadies
dramatic	13	6	940	3	dramatic
drammed	13	37	807	3	drammed
drams	8	60	2583	3	dram__s
draped	10	53	1436	3	draped_
drapery	13	38	794	3	drapery
drapey	12	50	1058	3	dra_pey
drawly	13	49	1072	3	dra_wly
dray	8	54	2809	3	dr__a_y
drayage	12	3	442	3	drayage
drayed	11	59	1139	3	drayed_
drayman	13	3	543	3	drayma_n
dread	7	44	1902	3	dr_ead_
dreads	8	41	1502	3	dr_eads
dreamed	11	43	1063	3	dreamed_
dreamily	14	3	514	3	dreamily
dreamy	12	50	999	3	dr_eamy
dreary	10	46	1167	3	dr_eary
drumly	12	3	570	3	drum_ly
dryad	10	47	758	3	dr_yad_
dryads	11	43	662	3	dr_yads
framed	12	51	1652	3	framed_
gamay	11	64	1910	3	_gama_y
grama	8	56	2028	3	grama__
gramarye	14	6	271	3	gramarye
gramas	9	43	1720	3	grama_s
granary	11	5	779	3	granary
hamada	12	3	991	3	_hamada
malady	12	3	786	3	_malady
premade	12	3	1144	3	premade
primacy	16	3	560	3	primacy
primary	14	3	770	3	primary
ramadas	10	3	930	3	_ramadas
ramal	7	46	2224	3	_rama_l
ramate	8	39	2168	3	_ramate
ramify	14	26	875	3	_ramify
rammy	12	43	1249	3	_ram_my
randy	9	50	2208	3	_ra_ndy
ratany	9	34	1187	3	_ratany
ready	9	48	2150	3	_r_eady
remade	9	43	1698	3	_remade
remedy	12	3	786	3	_remedy
tragedy	12	3	479	3	tragedy
trampy	13	49	925	3	tram_py
tramway	15	4	486	3	tramway

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	134027	0.156	1145455.1
2	DLD Change Limit	134027	77	8.126	16493.6
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	8.312	21498.0