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

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

122 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
legislation	12	4	428	(None)
legislations	13	4	375	1	legislations
legislating	13	4	340	2	legislating
legislative	15	5	267	2	legislative
legislator	11	6	285	2	legislat_or
degustation	13	4	563	3	degustation
depilation	13	3	1203	3	depi_lation
epilation	11	3	1296	3	_epi_lation
etiolation	10	4	853	3	_etiolation
legation	9	24	1293	3	leg___ation
legislate	10	8	467	3	legislat__e
legislated	12	6	358	3	legislat_ed
legislates	11	6	441	3	legislat_es
legislatives	16	5	172	3	legislatives
legislators	12	7	305	3	legislators
legislature	12	5	144	3	legislature
legitimation	15	5	516	3	legitimation
levigation	14	4	702	3	levi_gation
levitation	13	4	944	3	levi_tation
registration	13	4	753	3	registration
regulation	11	3	1205	3	reg_ulation
agitation	10	3	1122	4	_agi_tation
angulation	11	4	955	4	ang_ulation
cessation	11	7	685	4	ce__ssation
chrismation	18	5	351	4	chrismation
cogitation	13	4	1008	4	cogi_tation
dealation	10	3	1300	4	de__alation
decimation	15	4	1162	4	deci_mation
decollation	14	4	819	4	decollation
decussation	14	4	430	4	decussation
dedication	14	3	1196	4	dedi_cation
deflation	13	3	1065	4	de__flation
degradation	14	4	538	4	degradation
degustations	14	4	483	4	degustations
delation	9	23	1808	4	de___lation
delineation	12	4	776	4	delineation
denigration	13	4	846	4	denigration
depilations	14	3	1090	4	depi_lations
derivation	14	7	1278	4	deri_vation
desiccation	16	4	638	4	desiccation
designation	13	4	748	4	designation
desolation	11	3	1140	4	de_solation
detestation	12	4	836	4	detestation
devastation	15	4	673	4	devastation
deviation	13	3	1239	4	devi__ation
dilation	9	22	1546	4	__di_lation
egestion	9	4	686	4	_eges__tion
elation	7	36	2045	4	_e___lation
emigration	13	22	821	4	_emigration
emulation	11	3	1239	4	_e_mulation
epilations	12	3	1171	4	_epi_lations
escalation	12	4	887	4	_escalation
etiolations	11	4	739	4	_etiolations
exhalation	20	4	665	4	_exhalation
fellation	12	3	884	4	fe__llation
flagellation	16	5	289	4	flagellation
gelation	9	30	1443	4	__g_elation
gemination	13	14	1065	4	gemi_nation
gestation	10	3	1066	4	__gestation
gleization	20	11	578	4	gle_i_zation
gustation	10	4	796	4	__gustation
hesitation	13	4	963	4	hesi_tation
illation	8	3	1194	4	___illation
isolation	9	3	1164	4	___isolation
jubilation	19	4	605	4	jubi_lation
laciniation	13	4	663	4	laciniation
lallation	9	3	949	4	l__allation
lamination	12	3	1122	4	lami_nation
legalization	22	4	1161	4	legalization
legations	10	27	1192	4	leg___ations
legislatively	20	6	203	4	legislatively
legislatorial	14	6	127	4	legislatorial
legislatures	13	6	143	4	legislatures
legitimations	16	5	479	4	legitimations
lenition	8	3	1008	4	leni___tion
levigations	15	4	621	4	levi_gations
levitations	14	4	829	4	levi_tations
libation	10	24	1136	4	l__i_bation
libration	11	15	1016	4	l__ibration
ligation	9	23	1309	4	l__i_gation
limitation	12	4	915	4	limi_tation
lineation	9	3	1076	4	l__ineation
liquation	18	4	655	4	l__iquation
litigation	11	4	817	4	liti_gation
lixiviation	21	8	295	4	lixiviation
lobulation	12	4	723	4	l_obulation
mediation	12	3	1229	4	medi__ation
medication	15	4	1117	4	medi_cation
meditation	13	4	1074	4	medi_tation
melioration	13	6	818	4	melioration
methylation	19	5	441	4	methylation
mutilation	12	4	975	4	muti_lation
negation	9	29	1302	4	neg___ation
negotiation	12	4	577	4	negotiation
neurulation	11	4	534	4	neurulation
oscillation	13	4	549	4	oscillation
pagination	13	4	899	4	pagi_nation
peculation	14	3	1199	4	pe_culation
percolation	15	4	922	4	percolation
pixilation	19	4	591	4	pixi_lation
recitation	12	3	1594	4	reci_tation
reflation	12	4	1233	4	re__flation
registrations	14	4	689	4	registrations
regulations	12	3	1071	4	reg_ulations
reinflation	14	4	720	4	reinflation
relation	8	26	1977	4	re___lation
remigration	14	22	891	4	remigration
resignation	12	4	747	4	resignation
restation	9	3	1691	4	re__station
reticulation	14	4	805	4	reticulation
revelation	13	4	1092	4	re_velation
segregation	13	4	638	4	segregation
sensation	9	5	1058	4	se_ns_ation
seriation	9	3	1806	4	seri__ation
sibilation	12	12	877	4	sibi_lation
titillation	11	4	504	4	titillation
translation	11	4	948	4	translation
vacillation	16	4	531	4	vacillation
vegetation	14	4	821	4	veg_etation
ventilation	14	4	816	4	ventilation
vesiculation	17	4	611	4	vesiculation
violation	12	3	844	4	__violation

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.173	1032896.0
2	DLD Change Limit	148819	122	9.110	16335.8
3	Display Results	122	122	0.063	1936.5
	(SQL Overall)	178691	122	9.346	19119.5