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

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

111 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
gentrifiers	15	4	300	(None)
gentrifier	14	4	482	1	gentrifier_
gentrifies	14	4	690	1	gentrifie_s
denitrifiers	16	5	191	2	denitrifiers
gentrified	15	4	568	2	gentrifie_d
petrifiers	15	4	467	2	pe_trifiers
certifiers	15	4	515	3	cert_ifiers
denitrifier	15	5	312	3	denitrifier_
denitrifies	15	4	426	3	denitrifie_s
gentrices	12	5	892	3	gentri_ce_s
gentries	9	13	1527	3	gentr__ie_s
glorifiers	14	4	259	3	g_lorifiers
gratifiers	14	4	386	3	grat_ifiers
identifiers	15	5	286	3	ident_ifiers
metrifies	14	3	980	3	me_trifie_s
nitrifiers	13	4	392	3	_nitrifiers
petrifier	14	4	712	3	pe_trifier_
petrifies	14	3	1036	3	pe_trifie_s
rectifiers	15	4	517	3	rect_ifiers
terrifiers	13	14	457	3	te_rrifiers
testifiers	13	12	450	3	test_ifiers
verifiers	15	16	606	3	ve__rifiers
acetifiers	15	4	340	4	acet_ifiers
aerifies	11	13	1339	4	ae__rifie_s
agentries	10	4	824	4	agentr__ie_s
beatifies	14	5	928	4	beat_ifie_s
beautifiers	16	6	221	4	beautifiers
centiliters	13	4	392	4	cent_iliters
centralizers	23	5	433	4	centralizers
centrifuges	17	5	287	4	centrifuges
centrioles	12	4	580	4	centriole_s
certifier	14	4	735	4	cert_ifier_
certifies	14	3	1032	4	cert_ifie_s
clarifiers	15	4	401	4	_clarifiers
contrivers	15	4	725	4	contri_vers
deifiers	12	34	899	4	de___ifiers
denazifies	23	4	329	4	denazifie_s
dendrimers	14	4	274	4	dendri_mers
denitrified	16	5	378	4	denitrifie_d
densifies	13	4	799	4	den_sifie_s
destriers	10	3	814	4	destr__iers
devitrifies	18	5	287	4	devitrifie_s
edifiers	12	33	667	4	_e__difiers
electrifies	16	4	575	4	electrifie_s
enrichers	14	4	413	4	_en_richers
entailers	9	7	641	4	_entai_lers
enticers	10	13	909	4	_ent_i_cers
entities	8	6	1741	4	_ent_itie_s
entrainers	10	8	696	4	_entrainers
entrappers	14	4	418	4	_entrappers
entries	7	15	2316	4	_entr__ie_s
entropies	11	4	1103	4	_entropie_s
esterifies	13	4	715	4	_esterifie_s
fortifiers	16	4	454	4	fort_ifiers
gantries	9	14	1380	4	gantr__ie_s
gasifiers	13	4	452	4	g__asifiers
generalizers	22	19	408	4	generalizers
genericness	14	7	290	4	genericness
gentiles	9	37	1352	4	gent_i_le_s
gentilities	12	4	914	4	gentilitie_s
gentrice	11	4	881	4	gentri_ce__
gentrify	15	4	468	4	gentrif___y
gentrifying	19	4	381	4	gentrifying
glorifier	13	4	423	4	g_lorifier_
glorifies	13	4	636	4	g_lorifie_s
gratifier	13	4	582	4	grat_ifier_
gratifies	13	4	799	4	grat_ifie_s
grifters	12	38	923	4	g___rifters
identifier	14	4	426	4	ident_ifier_
identifies	14	4	580	4	ident_ifie_s
intriguers	11	4	333	4	_intriguers
introfies	12	4	723	4	_introfie_s
justifiers	20	4	308	4	just_ifiers
mentioners	12	4	534	4	ment_ioners
metrified	15	4	786	4	me_trifie_d
mortifiers	15	4	440	4	mort_ifiers
mystifiers	18	4	311	4	myst_ifiers
nitrifier	12	4	596	4	_nitrifier_
nitrifies	12	10	792	4	_nitrifie_s
notifiers	12	4	502	4	__notifiers
petrified	15	4	834	4	pe_trifie_d
prettifiers	16	4	251	4	prettifiers
purifiers	14	3	588	4	__purifiers
putrefiers	15	4	251	4	_putrefiers
quantifiers	23	5	250	4	quant_ifiers
ratifiers	12	3	645	4	_rat_ifiers
rectifier	14	5	773	4	rect_ifier_
rectifies	14	3	1081	4	rect_ifie_s
reifiers	11	30	984	4	re___ifiers
renotifies	13	5	689	4	renotifie_s
rentiers	8	33	1176	4	rent___iers
repurifies	15	4	614	4	repurifie_s
retrievers	13	7	330	4	re_trievers
retrofires	13	4	447	4	re_trofires
reverifies	16	4	597	4	reverifie_s
sanctifiers	16	5	237	4	sanctifiers
scarifiers	15	4	410	4	_scarifiers
scorifiers	15	4	360	4	_scorifiers
sentries	8	13	1806	4	sentr__ie_s
terrifier	12	12	660	4	te_rrifier_
terrifies	12	13	972	4	te_rrifie_s
testifier	12	11	689	4	test_ifier_
testifies	12	13	926	4	test_ifie_s
triflers	11	31	1022	4	___triflers
ungentrified	17	5	239	4	ungentrifie_d
unifiers	11	23	717	4	_un__ifiers
ventricles	15	4	452	4	ventricle_s
verifier	14	15	920	4	ve__rifier_
verifies	14	13	1348	4	ve__rifie_s
versifiers	16	15	414	4	ve_rsifiers
vitrifies	15	4	722	4	_vitrifie_s

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	111	9.283	16031.3
3	Display Results	111	111	0.063	1761.9
	(SQL Overall)	178691	111	9.766	18297.3