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

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

126 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
dissertates	12	4	534	(None)
dissertate	11	4	598	1	dissertate_
dissertated	13	4	444	1	dissertated
dissertator	12	5	307	2	dissertator
dissertators	13	5	273	2	dissertators
diskettes	14	4	657	3	diske_t_tes
disrates	9	11	1815	3	di_s_r_ates
disseated	11	7	1108	3	disse__ated
disseats	9	32	1150	3	disse__at_s
disseminates	15	8	508	3	disseminates
dissertating	14	7	479	3	dissertating
dissertation	13	6	609	3	dissertation
dissertations	14	6	589	3	dissertations
disserted	11	10	981	3	disser__ted
disserts	9	24	1181	3	disser__t_s
disserves	13	8	806	3	disser__ves
disservices	17	12	299	3	disservices
dissipates	13	4	655	3	diss_ipates
dissociates	14	5	578	3	dissociates
misstates	11	7	1063	3	miss__tates
aspartates	12	4	467	4	_aspartates
asperates	11	3	1255	4	_asper_ates
biseriate	11	4	767	4	bi_seriate_
biserrate	11	4	578	4	bi_serrate_
cassettes	11	4	670	4	casse_t_tes
deaerates	10	3	1364	4	d_eaer_ates
delectates	13	4	819	4	d_electates
denervates	14	4	593	4	d_enervates
derates	8	40	2889	4	d___er_ates
desecrates	13	4	884	4	d_esecrates
desiderates	13	4	581	4	desider_ates
desperate	12	4	1084	4	desper_ate_
desserts	9	24	792	4	desser__t_s
deuterates	11	4	908	4	deuter_ates
diastases	10	4	707	4	dias__tases
dictates	11	3	1138	4	di___ctates
dilettantes	12	5	220	4	di_lettantes
dinettes	9	3	1019	4	di_ne_t_tes
dinnertimes	14	5	265	4	dinnertimes
dinnerwares	15	5	217	4	dinnerwares
discarnate	13	4	604	4	discarnate_
diseases	9	24	1581	4	di_se__ases
disengages	13	4	435	4	di_sengages
disentails	11	4	701	4	di_sentails
disentitles	12	5	526	4	di_sentitles
disgraces	13	4	845	4	di_sgr_aces
disherited	15	4	670	4	disher_ited
disherits	13	4	823	4	disher_it_s
diskette	13	4	675	4	diske_t_te_
dislocates	13	10	832	4	di_slocates
disorientates	14	6	285	4	disorientates
disparages	14	4	604	4	dispar_ages
disparate	12	4	905	4	dispar_ate_
dispersals	13	4	511	4	dispersa_ls
dispersants	14	5	436	4	dispersants
disperses	12	12	1177	4	disper__ses
disrate	8	14	1852	4	di_s_r_ate_
disrated	10	9	1557	4	di_s_r_ated
disrelated	12	4	734	4	disre_lated
disreputes	13	14	452	4	disre_putes
dissaves	12	3	941	4	diss___aves
disseat	8	38	1692	4	disse__at__
dissected	13	10	866	4	disse__cted
dissections	14	19	826	4	dissections
dissectors	13	4	536	4	dissect_ors
dissects	11	27	924	4	disse__ct_s
disseisees	11	4	491	4	disse_isees
disseises	10	3	933	4	disse__ises
disseizees	20	4	354	4	disse_izees
disseizes	19	4	682	4	disse__izes
dissembles	15	4	508	4	disse_mbles
disseminate	14	8	554	4	disseminate_
disseminated	16	8	448	4	disseminated
dissensuses	11	5	241	4	dissensuses
dissented	11	9	972	4	disse__nted
dissenter	10	5	913	4	disse__nter
dissenters	11	9	772	4	dissent_ers
dissentions	12	16	804	4	dissentions
dissentious	12	18	447	4	dissentious
dissents	9	34	1186	4	disse__nt_s
dissert	8	37	2069	4	disser__t__
disserting	12	13	1085	4	dissert_ing
disserve	12	8	744	4	disser__ve_
disserved	14	10	700	4	disser__ved
disservice	16	12	347	4	disservice_
dissimilates	15	12	519	4	dissimilates
dissimulates	15	12	472	4	dissimulates
dissipate	12	4	703	4	diss_ipate_
dissipated	14	4	605	4	diss_ipated
dissipater	13	4	487	4	diss_ipater
dissipaters	14	5	347	4	diss_ipaters
dissociate	13	4	651	4	dissociate_
dissociated	15	5	560	4	dissociated
dissuades	11	6	624	4	diss__uades
distastes	10	3	963	4	di_s__tastes
distaves	12	3	1140	4	di_s__taves
distillates	12	4	615	4	distillates
disulfates	14	14	536	4	di_sulfates
dosserets	10	14	569	4	dosser_et_s
eviscerates	16	5	285	4	eviscer_ates
fossettes	12	4	508	4	fosse_t_tes
hibernates	15	4	462	4	hi_bernates
impetrates	14	4	545	4	_impetrates
innervates	13	4	639	4	_innervates
instates	8	16	1583	4	_ins__tates
interstates	11	7	1020	4	_interstates
intestates	10	15	943	4	_intestates
invertases	13	4	578	4	_invertases
iterates	8	13	1782	4	_i_ter_ates
kieserites	14	4	364	4	kieser_ites
liberates	11	10	1294	4	li_ber_ates
literates	9	14	1565	4	li_ter_ates
littermates	13	5	286	4	littermates
miscreates	14	4	810	4	mi_screates
misrates	10	13	1824	4	mi_s_r_ates
misrelates	12	4	762	4	misre_lates
misseated	12	6	1011	4	misse__ated
misseats	10	40	1168	4	misse__at_s
misstate	10	7	1134	4	miss__tate_
misstated	12	7	897	4	miss__tated
seriates	8	26	2067	4	___seriates
serrates	8	26	1702	4	___serrates
spectates	13	22	881	4	__spectates
tesselates	10	4	393	4	tesse_lates
tessellates	11	6	247	4	tessellates
vizierates	22	4	324	4	vizier_ates

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	126	9.296	16008.9
3	Display Results	126	126	0.063	2000.0
	(SQL Overall)	178691	126	9.779	18272.9