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

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

71 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
diagram	11	4	736	(None)
diagrams	12	4	613	1	diagrams
anagram	10	5	819	2	anagram
decagram	14	4	465	2	decagram
dekagram	16	4	328	2	dekagram
diagramed	14	5	445	2	diagramed
diagraph	15	4	481	2	diagraph
diram	8	44	1947	2	di__ram
skiagram	15	4	276	2	skiagram
anagrams	11	4	659	3	anagrams
audiogram	13	5	404	3	audiogram
dagga	8	3	954	3	d_agga_
daggas	9	3	797	3	d_aggas
decagrams	15	4	374	3	decagrams
decigram	14	4	535	3	decigram
dekagrams	17	4	282	3	dekagrams
dharma	12	7	610	3	dha_rma
diadem	10	3	758	3	dia_dem
diagonal	10	9	565	3	diagonal
diagraming	15	4	438	3	diagram~~ing~~
diagrammed	17	5	262	3	diagrammed
diagraphs	16	4	454	3	diagraphs
diaphragm	18	5	204	3	diaphragm
diary	9	50	1697	3	dia_r_y
diastem	10	31	804	3	diastem
diastral	9	4	699	3	diastral
diatom	9	3	945	3	dia_tom
diatron	8	3	928	3	diatron
diazepam	22	6	233	3	diazepam
digamma	13	4	310	3	digamma
digamy	13	3	589	3	di_g_amy
digraph	14	14	664	3	di_graph
dingbat	11	4	698	3	dingbat
diorama	10	4	653	3	di_orama
dirams	9	44	1370	3	di__rams
dirham	12	37	827	3	di_rham
disagree	10	4	835	3	disagree
disarm	9	3	1047	3	disar_m
disarray	12	4	483	3	disarray
disgrace	12	4	828	3	disgrace
dishrag	12	4	627	3	dishrag
dram	7	58	3200	3	d___ram
engram	9	3	1065	3	_engram
epigram	12	4	747	3	epigram
gingham	14	8	446	3	gingham
gram	7	70	3458	3	___gram
grogram	11	4	707	3	grogram
hexagram	21	4	368	3	hexagram
ideogram	12	4	574	3	ideogram
ihram	10	3	1018	3	_i_hram
isogram	10	4	725	3	isogram
jagra	13	3	817	3	_jagra_
jagras	14	3	846	3	_jagras
kilogram	15	4	579	3	kilogram
lingam	9	51	1235	3	ling_am
mailgram	13	4	441	3	mailgram
marram	10	3	1388	3	_marram
pangram	12	3	902	3	pangram
picogram	15	4	652	3	picogram
pilgrim	12	4	464	3	pilgrim
program	12	3	1169	3	program
radiogram	13	4	495	3	radiogram
skiagrams	16	4	206	3	skiagrams
tagrag	8	3	704	3	_tagrag
tangram	10	3	808	3	tangram
tiara	5	3	1591	3	tia_ra_
tiaras	6	3	1455	3	tia_ras
trigram	10	7	776	3	trigram
vagrom	12	3	594	3	_vagrom
wigwam	15	4	472	3	wi_gwam
ziram	16	39	1289	3	zi__ram

Search took 7 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.393	454684.5
2	DLD Change Limit	134027	71	6.030	22226.7
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	6.453	27691.2