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

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

51 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
prosopography	23	6	287	(None)
prosopographies	22	6	208	3	prosopographies
cosmography	24	4	559	4	_cos_mography
phonography	25	6	830	4	p__honography
photography	25	4	1007	4	p__hotography
physiography	29	5	449	4	phys_iography
polarography	23	5	390	4	p_olarography
pornography	22	4	621	4	p_o_rnography
sonography	19	4	720	4	___sonography
topography	21	7	709	4	___topography
aortography	20	4	640	5	_ao_rtography
arteriography	22	6	338	5	arteriography
biogeography	24	5	371	5	bio_geography
choreography	26	5	600	5	cho_reography
chorography	25	4	845	5	__chorography
chromatography	30	13	438	5	chromatography
chronography	26	12	574	5	_chronography
coronograph	19	12	493	5	_coronograph_
coronographs	20	12	492	5	_coronographs
cryptography	28	5	456	5	cr_yptography
discography	23	5	409	5	_dis_cography
fluorography	24	5	326	5	_fluorography
holography	22	7	861	5	___holography
iconography	22	4	545	5	__iconography
nomography	21	6	680	5	___nomography
orography	18	4	795	5	____orography
orthography	23	5	517	5	__orthography
paleogeography	26	8	220	5	paleogeography
paleography	22	4	617	5	p__aleography
petrography	22	4	754	5	p__etrography
phlebography	28	5	361	5	p_hlebography
phonograph	21	4	881	5	p__honograph_
phonographs	22	4	890	5	p__honographs
photograph	21	4	1101	5	p__hotograph_
photographs	22	4	1147	5	p__hotographs
phytogeography	32	6	273	5	phytogeography
pictography	24	4	607	5	p__ictography
planography	22	5	516	5	p__lanography
prototrophy	21	25	449	5	pr__ototrophy
radiography	21	6	594	5	_r_adiography
renography	19	4	702	5	_r__enography
reprography	22	4	652	5	_r_eprography
seismography	23	13	388	5	seis_mography
tomography	21	7	779	5	___tomography
topograph	17	8	748	5	___topograph_
topographs	18	8	804	5	___topographs
typography	24	9	589	5	___typography
ultrasonography	24	7	118	5	ultrasonography
uranography	20	5	418	5	ur__anography
zoogeography	31	5	297	5	_zoogeography
zoography	27	4	566	5	___zo_ography

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.156	1145455.1
2	DLD Change Limit	124790	51	9.296	13424.1
3	Display Results	51	51	0.030	1700.0
	(SQL Overall)	178691	51	9.482	18845.3