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

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

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
preprepared	15	5	172	(None)
precleared	15	4	411	3	precle_ared
precreased	15	4	441	3	precre_ased
prepared	13	22	1087	3	___prepared
pretreated	13	4	762	3	pretre_ated
unprepared	15	4	302	3	_unprepared
deprecated	16	4	667	4	_deprecated
depredated	15	4	481	4	_depredated
peppered	12	3	613	4	p_ep__pered
perspired	14	4	421	4	p_e_rspired
preaverred	16	4	276	4	preave_rred
precleaned	15	4	380	4	precle_aned
precrease	13	4	523	4	precre_ase_
precreases	14	4	565	4	precre_ases
preerected	15	4	557	4	preere_cted
preferred	15	5	500	4	pre_fe_rred
preheated	15	3	981	4	pre_he_ated
premiered	14	23	709	4	premie__red
preordered	14	4	312	4	preor_dered
prepackaged	23	5	186	4	prepackaged
prepare	11	19	1362	4	___prepare_
preparer	12	16	964	4	___preparer
prepares	12	20	1416	4	___prepares
prepaved	16	17	723	4	___prepaved
preplaced	16	7	648	4	prep__laced
prepped	11	32	990	4	prep__p__ed
prepriced	16	7	664	4	prepr__iced
preprimaries	18	7	233	4	preprimaries
preprimary	19	5	185	4	preprimar_y
preprinted	15	4	654	4	prepr_inted
preprogramed	20	6	250	4	preprogramed
prepupae	11	4	464	4	prep_upa_e_
prepurchased	22	17	186	4	prepurchased
prerecord	14	4	417	4	pre_recor_d
prerecorded	17	5	204	4	pre_recorded
prereleased	14	5	255	4	pre_released
prerequired	23	5	136	4	pre_required
prewrapped	17	6	216	4	prewrap_ped
procreated	15	4	644	4	procre_ated
reappeared	15	4	301	4	_reappe_ared
recreated	12	4	1253	4	_recre_ated
redreamed	13	4	502	4	_redre_amed
regeared	10	3	943	4	_re_ge_ared
repapered	14	4	523	4	_rep_apered
repealed	11	32	1187	4	_rep_e_aled
repeated	11	31	1744	4	_rep_e_ated
repleaded	13	3	629	4	_reple_aded
repressed	12	6	1010	4	_repre_ssed
reprobated	15	4	638	4	_reprobated
rerepeated	13	4	619	4	_re_repeated
rereward	12	4	614	4	_re_rewar_d
retreaded	11	3	705	4	_retre_aded
retreated	10	3	1262	4	_retre_ated
underprepared	19	6	152	4	underprepared
upreared	11	3	707	4	__upre_ared

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	148819	0.420	425454.8
2	DLD Change Limit	148819	55	9.236	16112.9
3	Display Results	55	55	0.030	1833.3
	(SQL Overall)	178691	55	9.686	18448.4