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

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

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.

55 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
metallography	24	6	294	(None)
metallographer	22	6	233	2	metallographer
metallographic	24	6	241	2	metallographic
metallographers	23	7	184	3	metallographers
metallographies	23	6	240	3	metallographies
allograph	15	4	753	4	___allograph_
allographs	16	4	806	4	___allographs
calligraphy	22	6	256	4	__calligraphy
crystallography	29	12	122	4	crystallography
ethnography	23	5	514	4	_et_hnography
mammography	23	5	381	4	m__ammography
mythography	28	5	440	4	myt__hography
oscillography	24	8	215	4	oscillography
paleography	22	4	617	4	__paleography
petrography	22	4	754	4	pet__rography
stylography	23	5	453	4	_st_ylography
allographic	19	4	743	5	___allographic
arteriography	22	6	338	5	arteriography
autobiography	24	6	307	5	autobiography
autography	19	4	762	5	___autography
bibliography	25	5	303	5	_bibliography
cacography	23	4	583	5	__ca_cography
cartography	22	4	678	5	__cartography
demography	22	4	697	5	de___mography
filmography	25	5	417	5	__filmography
geography	19	4	645	5	ge____ography
hagiography	24	4	550	5	__hagiography
heliograph	19	4	690	5	he__liograph_
heliographs	20	4	712	5	he__liographs
holography	22	7	861	5	___holography
lexicography	30	5	255	5	le_xicography
lithography	23	6	537	5	lit__hography
metallically	19	5	410	5	metall_ically
metalloidal	14	5	278	5	metalloida__l
metallurgy	16	5	179	5	metall_ur__gy
oceanography	23	5	341	5	ocea_nography
orthography	23	5	517	5	ort__hography
oscillograph	20	6	210	5	oscillograph_
oscillographs	21	6	209	5	oscillographs
planography	22	5	516	5	_pla_nography
polarography	23	5	390	5	pola_rography
radiography	21	6	594	5	__radiography
renography	19	4	702	5	re___nography
reprography	22	4	652	5	re__prography
seismography	23	13	388	5	se_ismography
stenography	20	4	560	5	_st_enography
stereography	21	5	497	5	_stereography
telegraphy	19	5	437	5	__t_elegraphy
tomography	21	7	779	5	__t_omography
topography	21	7	709	5	__t_opography
typography	24	9	589	5	__t_ypography
uranography	20	5	418	5	_ura_nography
venography	22	4	576	5	ve___nography
xerography	26	4	717	5	xe___rography
xylography	29	4	500	5	___xylography

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	124790	0.406	440125.6
2	DLD Change Limit	124790	55	9.203	13559.7
3	Display Results	55	55	0.046	1195.7
	(SQL Overall)	178691	55	9.655	18507.6