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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

157 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
degenerates	13	4	645	(None)
degenerate	12	4	683	1	degenerate_
degenerated	14	4	574	1	degenerated
regenerates	12	4	747	1	regenerates
decelerates	14	4	679	2	decelerates
degeneracies	16	5	355	2	degeneracies
degenerately	17	5	256	2	degenerately
generates	10	3	1271	2	__generates
regenerate	11	4	796	2	regenerate_
regenerated	13	4	690	2	regenerated
deaerates	10	3	1364	3	d__eaerates
decelerate	13	4	751	3	decelerate_
decelerated	15	4	592	3	decelerated
decerebrates	17	5	359	3	decerebrates
defenestrates	17	6	246	3	defenestrates
degeneracy	17	5	234	3	degenera_cy
degenerateness	16	6	267	3	degenerateness
degenerating	15	4	566	3	degenerating
degeneration	14	4	728	3	degeneration
degenerations	15	4	635	3	degenerations
degenerative	17	5	496	3	degenerative
deliberates	14	4	679	3	deliberates
delineates	11	4	712	3	deline_ates
denervates	14	4	593	3	d__enervates
desecrates	13	4	884	3	dese_crates
desiderates	13	4	581	3	desiderates
deuterates	11	4	908	3	de_uterates
emeerates	11	4	937	3	_eme_erates
exenterates	18	8	537	3	_exenterates
exonerates	17	10	734	3	_exonerates
generate	9	3	1290	3	__generate_
generated	11	3	1020	3	__generated
intenerates	11	4	808	3	intenerates
regeneracies	15	5	374	3	regeneracies
regenerately	16	5	297	3	regenerately
regenerator	12	5	456	3	regenerator
regenerators	13	5	383	3	regenerators
remunerates	13	7	594	3	remunerates
venerates	12	3	1226	3	__venerates
accelerates	15	5	444	4	accelerates
ameerates	11	4	906	4	_ame_erates
asseverates	14	5	264	4	asseverates
celebrates	14	4	767	4	cele_brates
cerebrates	14	4	791	4	cere_brates
coelenterates	15	5	285	4	coelenterates
cogenerator	14	5	417	4	cogenerator
cogenerators	15	5	398	4	cogenerators
crenelates	12	6	619	4	_crenelates
deaerate	9	3	1417	4	d__eaerate_
deaerated	11	3	1111	4	d__eaerated
deaneries	10	3	1083	4	de_aner_ies
decelerator	14	5	399	4	decelerator
decelerators	15	5	349	4	decelerators
decemvirates	20	5	208	4	decemvirates
decenaries	13	4	812	4	decenar_ies
decennaries	14	5	426	4	decennaries
decentres	12	23	852	4	decentr__es
decerebrate	16	6	401	4	decerebrate_
decerebrated	18	5	331	4	decerebrated
deconsecrates	18	9	404	4	deconsecrates
decorates	12	3	1474	4	d__ecorates
defecates	15	3	859	4	d__efecates
defenestrate	16	6	264	4	defenestrate_
defenestrated	18	6	214	4	defenestrated
deflagrates	16	13	324	4	deflagrates
degendered	14	4	350	4	degender__ed
degenders	12	3	608	4	degender___s
degrades	11	26	992	4	deg___rades
degreases	11	4	615	4	deg_re_ases
dehydrates	18	4	424	4	de_hydrates
delectates	13	4	819	4	dele_ctates
delegates	11	3	984	4	d__elegates
deliberate	13	4	712	4	deliberate_
deliberated	15	4	563	4	deliberated
delineate	10	4	779	4	deline_ate_
delineated	12	4	624	4	deline_ated
demonstrates	15	15	560	4	demonstrates
dendrites	11	4	793	4	d__endrites
denervate	13	4	617	4	d__enervate_
denervated	15	4	511	4	d__enervated
denigrates	12	9	811	4	de_nigrates
denitrates	11	6	951	4	de_nitrates
denudates	11	4	558	4	d__enudates
deprecates	15	4	728	4	de_precates
depredates	14	4	550	4	de_predates
depurates	12	3	982	4	d__epurates
derates	8	40	2889	4	d____erates
deregulates	13	13	513	4	deregulates
desecrate	12	4	908	4	dese_crate_
desecrated	14	4	795	4	dese_crated
desecrater	13	4	698	4	dese_crater
desecraters	14	4	481	4	dese_craters
desegregates	15	5	293	4	desegregates
desiderate	12	4	627	4	desiderate_
desiderated	14	4	494	4	desiderated
desperate	12	4	1084	4	de_sperate_
detentes	9	27	1287	4	deten___tes
deteriorates	13	5	444	4	deteriorates
detonates	10	3	1043	4	deton__ates
deuterate	10	4	951	4	de_uterate_
deuterated	12	4	753	4	de_uterated
digeneses	11	4	739	4	digene__ses
edentates	10	4	695	4	_eden_tates
emeerate	10	4	1010	4	_eme_erate_
emendates	12	4	608	4	_emen_dates
enervates	12	4	872	4	___enervates
enumerates	12	12	674	4	_enumerates
eventuates	13	9	418	4	_eventuates
execrates	18	3	956	4	_exe_crates
exenterate	17	9	568	4	_exenterate_
exenterated	19	6	479	4	_exenterated
exonerate	16	10	773	4	_exonerate_
exonerated	18	10	600	4	_exonerated
exuberates	19	4	528	4	_exuberates
federates	13	3	1015	4	__federates
generals	9	10	933	4	__genera_ls
generator	10	6	759	4	__generator
generators	11	4	753	4	__generators
genettes	9	3	830	4	__gene_ttes
incinerates	13	4	603	4	incinerates
intenerate	10	4	874	4	intenerate_
intenerated	12	4	701	4	intenerated
itinerates	10	12	613	4	_itinerates
legendaries	13	5	309	4	legendaries
legendries	12	4	382	4	legendr_ies
nondegenerate	15	6	152	4	~~non~~degenerate_
penetrates	12	4	872	4	pene_trates
perennates	12	5	676	4	peren_nates
perseverates	17	5	315	4	perseverates
recuperates	15	4	560	4	recuperates
redecorates	14	6	568	4	redecorates
reelevates	13	4	563	4	re_elevates
reengraves	14	4	402	4	re_engraves
regelates	10	3	1111	4	reg__elates
regenerable	14	5	388	4	regenerable
regeneracy	16	5	252	4	regenera_cy
regenerateness	15	6	260	4	regenerateness
regenerating	14	4	633	4	regenerating
regeneration	13	4	819	4	regeneration
regenerations	14	4	714	4	regenerations
regenerative	16	5	530	4	regenerative
regrates	9	26	1840	4	reg___rates
reinnervates	15	5	309	4	reinnervates
reiterates	10	4	1200	4	re_iterates
remunerate	12	6	625	4	remunerate_
remunerated	14	7	535	4	remunerated
reoperates	12	4	966	4	re_operates
revegetates	15	5	393	4	revegetates
reverberates	17	5	351	4	reverberates
segregates	12	4	533	4	seg_regates
selenates	9	16	1136	4	selen__ates
unregenerate	13	6	217	4	unregenerate_
vegetates	13	4	640	4	veg__etates
venenates	12	4	758	4	__venenates
venerate	11	3	1290	4	__venerate_
venerated	13	3	995	4	__venerated
wernerites	13	4	494	4	we_rnerites

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.423	422437.4
2	DLD Change Limit	148819	157	9.313	15979.7
3	Display Results	157	157	0.093	1688.2
	(SQL Overall)	178691	157	9.829	18180.0