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

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

53 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
retroflexions	23	6	204	(None)
retroflexion	22	6	206	1	retroflexion_
retroflections	19	5	387	2	retroflections
reflexions	20	4	330	3	re___flexions
retroflection	18	5	404	3	retroflection_
retroflexes	21	5	194	3	retroflex__es
deflexions	21	4	256	4	de___flexions
reflexion	19	4	361	4	re___flexion_
retroactions	14	4	707	4	retro_actions
retrocessions	15	11	435	4	retrocessions
retrodictions	16	5	553	4	retrodictions
retroflex	19	4	292	4	retroflex____
retrogressions	15	11	316	4	retrogressions
retrospections	18	9	417	4	retrospections
retroversions	16	7	345	4	retroversions
deflexion	20	4	282	5	de___flexion_
effluxions	23	5	173	5	_e__ffluxions
etiolations	11	4	739	5	_etio_lations
flexions	18	4	441	5	_____flexions
inflexions	20	4	289	5	___inflexions
metroplexes	22	5	268	5	metroplex__es
petrifactions	20	8	356	5	petrifactions
recollections	17	5	472	5	re_collections
reflations	13	3	1123	5	re___flations
reflections	16	17	855	5	re___flections
reflexing	20	3	593	5	re___flexi_ng
reflexives	23	4	236	5	re___flexives
reinflations	15	4	664	5	re_inflations
repletions	12	4	747	5	re___pletions
reprobations	16	4	777	5	repro_bations
reproductions	18	6	527	5	reproductions
reprovisions	17	5	377	5	repro_visions
resolutions	11	11	779	5	re_so_lutions
reticulations	15	5	661	5	reticulations
retorsions	10	4	571	5	ret_o__rsions
retortions	10	4	914	5	ret_o__rtions
retractions	13	9	1035	5	retr__actions
retranslations	14	5	421	5	retranslations
retributions	14	13	494	5	retr_ibutions
retroaction	13	4	736	5	retro_action_
retroceding	15	4	413	5	retro_cedi_ng
retrocession	14	9	445	5	retrocession_
retrodiction	15	5	565	5	retrodiction_
retrofires	13	4	447	5	retrof___ires
retrofiring	15	4	418	5	retrof_iri_ng
retrofits	12	4	535	5	retrof___i_ts
retrofitting	16	5	318	5	retrofitti_ng
retrogression	14	10	342	5	retrogression_
retroreflection	20	11	167	5	retroreflection_
retroreflectors	20	7	102	5	retroreflectors
retrospection	17	8	431	5	retrospection_
retroversion	15	7	367	5	retroversion_
revolutions	14	9	763	5	re_vo_lutions

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.390	458182.1
2	DLD Change Limit	124790	53	8.703	14338.7
3	Display Results	53	53	0.030	1766.7
	(SQL Overall)	178691	53	9.123	19586.9