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

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

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.

54 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
gimpier	12	24	794	(None)
wimpier	14	24	805	1	wimpier
bumpier	13	35	920	2	bumpier
campier	13	33	1327	2	campier
crimpier	14	28	732	2	crimpier
dimplier	13	3	667	2	dimplier
dippier	12	31	1139	2	dippier
dumpier	12	40	965	2	dumpier
gambier	12	47	1197	2	gambier
gamier	9	36	1793	2	gam_ier
gammier	12	37	1119	2	gammier
gappier	12	36	984	2	gappier
gemmier	12	33	738	2	gemmier
giddier	10	30	872	2	giddier
gimmie	11	29	818	2	gimmie_
gimmies	12	30	1011	2	gimmies
gimped	12	39	1147	2	gimp_ed
gimpiest	13	3	847	2	gimpiest
gimping	13	37	1076	2	gimping
ginnier	8	29	898	2	ginnier
gipper	11	42	1530	2	gi_pper
girlier	8	28	952	2	girlier
glimpser	13	4	266	2	glimpser
glumpier	13	3	487	2	glumpier
goopier	10	39	1057	2	goopier
grapier	10	37	1260	2	grapier
grimier	10	32	1043	2	grim_ier
gripier	10	32	1032	2	gripier
grippier	13	5	520	2	grippier
grumpier	13	3	480	2	grumpier
gulpier	10	4	695	2	gulpier
gummier	12	34	947	2	gummier
hempier	14	31	900	2	hempier
hippier	14	32	1210	2	hippier
humpier	14	31	1072	2	humpier
jimper	17	38	986	2	jimp_er
jumpier	18	31	794	2	jumpier
limbier	11	34	911	2	limbier
limier	8	35	1872	2	lim_ier
limper	10	41	1785	2	limp_er
limpsier	12	3	443	2	limpsier
lippier	11	27	1057	2	lippier
lumpier	11	34	1014	2	lumpier
nippier	11	31	983	2	nippier
pimplier	14	4	541	2	pimplier
pipier	10	49	1398	2	pi_pier
rimier	8	39	1627	2	rim_ier
simper	10	36	1629	2	simp_er
simpler	11	29	1086	2	simpler
skimpier	16	3	429	2	skimpier
tippier	11	32	1054	2	tippier
vampier	14	30	823	2	vampier
wispier	12	24	940	2	wispier
zippier	20	30	819	2	zippier

Search took 6 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	107671	0.266	671770.7
2	DLD Change Limit	107671	54	5.606	19206.4
3	Display Results	54	54	0.033	1636.4
	(SQL Overall)	178691	54	5.905	30261.0