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

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

78 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
inspectorates	17	6	168	(None)
inspectorate	16	6	189	1	inspectorate_
expectorates	23	5	299	3	_expectorates
inspectors	14	4	493	3	inspector___s
directorates	15	5	300	4	_directorates
electorates	13	4	744	4	__electorates
expectorate	22	5	330	4	_expectorate_
expectorated	24	5	231	4	_expectorated
impetrates	14	4	545	4	i_mpe_t_rates
insectaries	13	5	488	4	ins_ectar_ies
inspector	13	4	475	4	inspector____
inspectorship	22	7	188	4	inspectorship
inspectorships	23	8	196	4	inspectorships
protectorates	17	5	286	4	protectorates
rectorates	12	4	1036	4	___rectorates
spectates	13	22	881	4	__spect__ates
asperates	11	3	1255	5	_aspe___rates
consecrates	15	4	839	5	cons_ec__rates
decorates	12	3	1474	5	___dec_orates
desecrates	13	4	884	5	des_ec__rates
directorate	14	5	325	5	_directorate_
doctorates	13	4	620	5	___doctorates
electorate	12	4	758	5	__electorate_
expectorants	23	6	133	5	_expectorants
imperforate	18	5	305	5	i_mperforate_
impersonates	16	5	389	5	i_mpersonates
impetrate	13	4	572	5	i_mpe_t_rate_
impetrated	15	4	436	5	i_mpe_t_rated
inactivates	16	4	504	5	in__activates
incarcerates	16	5	328	5	incarc_erates
incorporates	16	5	523	5	in_corporates
infectors	14	21	855	5	in_fector___s
infiltrates	14	6	394	5	in_filt_rates
inflectors	15	4	521	5	inflector___s
injectors	18	21	672	5	in_jector___s
inoperculates	17	6	214	5	inoperculates
insecticides	17	5	259	5	ins_ecticides
insectivores	17	10	172	5	ins_ectivores
insecurities	14	5	395	5	ins_ec_urities
inseminates	13	4	589	5	ins_e_minates
insolates	9	3	1127	5	ins____olates
inspected	14	4	540	5	inspec____ted
inspections	15	4	642	5	inspect__ions
inspective	17	4	640	5	inspect__ive_
inspects	12	5	586	5	inspec____t_s
inspissates	13	5	161	5	insp__issates
instantiates	12	5	361	5	instant_iates
instates	8	16	1583	5	ins___t__ates
instigates	11	4	842	5	ins___tigates
integrates	11	10	1078	5	in_te__grates
intenerates	11	4	808	5	in_te_nerates
interpolates	14	4	857	5	in_terpolates
interrogates	13	8	710	5	in_terrogates
intestates	10	15	943	5	in_test__ates
intonates	9	4	1024	5	in____tonates
inventories	14	5	469	5	in_ventor_ies
invertebrates	18	6	203	5	in_vertebrates
investigates	16	10	421	5	in_vestigates
inveterate	13	4	524	5	in_ve_terate_
invigorates	15	12	424	5	in__vigorates
obsecrates	14	4	458	5	obs_ec__rates
pastorates	12	4	1014	5	___pastorates
pectates	12	22	1395	5	___pect__ates
pectorals	13	12	815	5	___pectora_ls
perborates	14	5	921	5	___perborates
perforates	15	5	886	5	___perforates
perorates	11	4	1702	5	___pe_rorates
perpetrates	15	6	620	5	perpe_t_rates
protectorate	16	5	351	5	protectorate_
rectorate	11	4	1136	5	___rectorate_
redecorates	14	6	568	5	_redec_orates
speciates	13	22	923	5	__spec__iates
spectate	12	24	883	5	__spect__ate_
spectated	14	23	659	5	__spect__ated
spectres	12	26	868	5	__spect_r__es
speculates	14	23	790	5	__spec_ulates
undecorated	15	4	572	5	un_dec_orated
unsaturates	11	5	460	5	uns__aturates

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	124790	0.140	1276364.3
2	DLD Change Limit	124790	78	8.953	13938.3
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	9.139	19552.6