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

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

90 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
grimy	11	43	1260	(None)
grim	7	69	2942	1	grim_
grime	8	50	2132	1	grime
grimly	12	45	993	1	grimly
gripy	11	51	1525	1	gripy
rimy	9	66	2128	1	_rimy
army	9	66	2418	2	ar_my
blimy	12	52	1282	2	blimy
brim	8	56	2937	2	brim_
brims	9	47	2162	2	brims
briny	10	47	1966	2	briny
crime	9	48	2269	2	crime
crimp	11	56	1580	2	crimp
crimpy	15	48	939	2	crimpy
drily	9	58	1652	2	drily
gaily	9	50	2097	2	gaily
gammy	13	55	1489	2	gammy
gamy	10	54	2753	2	g_amy
gemmy	13	52	1105	2	gemmy
germy	11	51	1366	2	germy
gimp	9	61	2404	2	g_imp
gimpy	13	52	1223	2	g_impy
girly	9	44	1529	2	girly
glim	7	60	2635	2	glim_
glime	8	56	2019	2	glime
glims	8	74	1767	2	glims
gorily	10	6	1250	2	gorily
grainy	10	39	1421	2	grainy
gram	7	70	3458	2	gram_
grama	8	56	2028	2	grama
gramp	10	62	1832	2	gramp
grams	8	53	2731	2	grams
grapy	11	54	1643	2	grapy
gravy	12	55	1211	2	gravy
gray	8	53	2989	2	gr_ay
gremmy	14	5	447	2	gremmy
grey	8	56	2404	2	gr_ey
grid	6	58	2961	2	gri_d
gride	7	52	2358	2	gride
grids	7	53	2139	2	grids
grief	9	53	1978	2	grief
griff	12	44	1646	2	griff
grift	9	59	2446	2	grift
grig	6	54	2477	2	gri_g
grigs	7	53	1819	2	grigs
grill	6	46	1789	2	grill
grimed	10	47	1409	2	grimed
grimes	9	46	1903	2	grimes
grimily	13	3	652	2	grimily
grin	5	57	3372	2	gri_n
grind	7	59	1756	2	grind
grins	6	54	2722	2	grins
griot	6	53	2841	2	griot
grip	7	61	2702	2	gri_p
gripe	8	46	2296	2	gripe
gripey	12	41	1120	2	gripey
grippy	14	44	776	2	grippy
grips	8	55	2013	2	grips
gript	8	51	2617	2	gript
grisly	10	43	1058	2	grisly
grist	6	55	2987	2	grist
grit	5	52	4724	2	gri_t
grith	9	55	2037	2	grith
grits	6	55	2958	2	grits
gritty	10	33	840	2	gritty
grody	10	34	1206	2	grody
grum	7	56	2508	2	grum_
grume	8	62	1816	2	grume
grump	10	51	1531	2	grump
grumpy	14	49	815	2	grumpy
gummy	13	54	1365	2	gummy
limy	9	57	2771	2	_limy
pricy	12	48	1456	2	pricy
prim	8	51	3220	2	prim_
prima	9	50	1934	2	prima
prime	9	65	2560	2	prime
primi	9	50	1740	2	primi
primly	13	43	962	2	primly
primo	9	50	1791	2	primo
primp	11	56	1592	2	primp
prims	9	54	2593	2	prims
privy	13	43	983	2	privy
rim	5	60	5227	2	_rim_
rime	6	51	3888	2	_rime
rims	6	59	3630	2	_rims
slimy	10	54	1742	2	slimy
stimy	10	51	1474	2	stimy
trim	6	53	2952	2	trim_
trimly	11	44	1089	2	trimly
trims	7	50	2147	2	trims

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	53800	0.810	220606.2
2	DLD Change Limit	53800	90	4.503	11947.6
3	Display Results	90	90	0.046	1956.5
	(SQL Overall)	178691	90	5.359	33344.1