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

Here are the results of your fuzzy-string dictionary search for “supererogation” 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
supererogation	17	6	306	(None)
supererogations	18	6	283	1	supererogations
superelevation	19	6	300	3	superelevation
supererogatory	20	7	113	3	supererogatory
interrogation	14	5	786	4	inter_rogation
prorogation	14	4	739	4	__p_rorogation
subirrigation	16	5	264	4	subir_rigation
subrogation	14	4	600	4	su___brogation
superannuation	16	10	422	4	superannuation
superelevations	20	6	276	4	superelevations
superfetation	18	5	522	4	super_fetation
supernation	13	4	1166	4	sup__er_nation
superovulation	19	6	354	4	superovulation
superposition	17	13	559	4	super_position
superstation	14	16	862	4	sup__erstation
arrogation	11	10	744	5	___ar_rogation
derogation	12	4	1039	5	____derogation
impersonation	17	6	422	5	imper_sonation
interrogations	15	5	681	5	inter_rogations
percolation	15	4	922	5	__per_colation
peregrination	16	12	520	5	__peregrination
perennation	13	4	808	5	__pere_nnation
perforation	16	4	900	5	__per_foration
peroration	12	3	1600	5	__p__eroration
personation	13	4	948	5	__per_sonation
prerogative	17	5	535	5	__p_rerogative
prorogations	15	5	672	5	__p_rorogations
segregation	13	4	638	5	s__e_gregation
serration	9	4	1406	5	s__er_r__ation
suberization	23	5	924	5	su__berization
subgeneration	16	5	260	5	subgener__ation
subirrigations	17	10	240	5	subir_rigations
subrogations	15	4	545	5	su___brogations
superaddition	17	6	346	5	super_addition
superannuations	17	6	380	5	superannuations
superelevating	20	8	230	5	superelevating
superfetations	19	7	506	5	super_fetations
superimposition	21	7	206	5	superimposition
superinduction	19	6	405	5	superinduction
superinfection	21	6	365	5	superinfection
supernations	14	4	1087	5	sup__er_nations
supernutrition	16	7	362	5	supernutrition
superorganic	17	6	265	5	superor_gani_c
superorganism	18	6	286	5	superor_ganism
superovulations	20	6	336	5	superovulations
superpositions	18	14	526	5	super_positions
superromantic	19	8	294	5	super_romanti_c
supersaturation	17	8	350	5	supersaturation
superscription	20	6	363	5	superscription
superstations	15	20	814	5	sup__erstations
superstition	14	16	687	5	sup__erstition
supervention	17	10	599	5	sup__ervention
suppuration	15	4	589	5	sup_pur__ation
surrogating	13	19	432	5	su__r_rogating
susurration	11	4	479	5	susur_r__ation

Search took 8 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	95024	0.360	496363.9
2	DLD Change Limit	95024	55	6.766	14044.3
3	Display Results	55	55	0.033	1666.7
	(SQL Overall)	178691	55	7.159	24960.3