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

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

33 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
biogeographers	23	8	291	(None)
biogeographer	22	7	358	1	biogeographer_
biogeographies	23	5	335	2	biogeographies
zoogeographers	30	6	237	2	zoogeographers
bibliographers	24	6	253	3	bibliographers
biogeographic	24	5	395	3	biogeograph_ic
biogeography	24	5	371	3	biogeograph__y
biographers	19	15	511	3	bi___ographers
choreographers	25	9	453	3	choreographers
geographers	18	5	478	3	___geographers
videographers	23	5	340	3	vi_deographers
zoogeographer	29	6	278	3	zoogeographer_
bibliographer	23	6	294	4	bibliographer_
biogeographical	26	8	273	4	biogeographical
biographees	19	12	453	4	bi___ographees
biographer	18	12	651	4	bi___ographer_
choreographer	24	9	574	4	choreographer_
chorographers	24	10	612	4	cho_rographers
cosmographers	23	5	359	4	_cosmographers
discographers	22	5	319	4	di_scographers
geographer	17	4	616	4	___geographer_
glossographers	21	6	176	4	glossographers
hagiographers	23	5	374	4	_hagiographers
holographers	21	6	622	4	_ho_lographers
iconographers	21	5	363	4	_iconographers
lithographers	22	5	390	4	li_thographers
paleographers	21	11	424	4	_paleographers
phonographers	24	6	580	4	pho_nographers
photographers	24	5	717	4	pho_tographers
pornographers	21	6	449	4	_pornographers
topographers	20	5	507	4	_to_pographers
videographer	22	5	432	4	vi_deographer_
zoogeographies	30	186	457	4	zoogeographies

Search took 4 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	65874	0.326	548131.9
2	DLD Change Limit	65874	33	3.390	19431.9
3	Display Results	33	33	0.016	2062.5
	(SQL Overall)	178691	33	3.732	47880.8