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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

121 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
jimp	15	56	1847	(None)
gimp	9	61	2405	1	gimp
imp	7	66	2698	1	_imp
jimpy	19	52	1082	1	jimpy
jump	15	66	2172	1	jump
limp	8	84	3250	1	limp
pimp	10	60	2491	1	pimp
simp	8	52	2878	1	simp
wimp	11	55	2153	1	wimp
aim	5	78	5822	2	aim_
aims	6	77	3819	2	aims
amp	7	75	4102	2	_amp
bima	8	67	2384	2	bima
blimp	11	56	1294	2	blimp
bump	10	62	2824	2	bump
camp	10	63	3645	2	camp
chimp	14	52	1647	2	chimp
comp	10	67	3125	2	comp
crimp	11	56	1580	2	crimp
damp	9	62	2884	2	damp
dim	6	81	4650	2	dim_
dime	7	62	3765	2	dime
dims	7	54	3503	2	dims
dip	6	78	4899	2	di_p
dump	9	59	2709	2	dump
gamp	9	88	3321	2	gamp
gimps	10	59	1520	2	gimps
gimpy	13	52	1223	2	gimpy
gip	6	76	4537	2	gi_p
hemp	11	57	2562	2	hemp
him	8	62	4767	2	him_
hims	9	52	3098	2	hims
hip	8	67	5044	2	hi_p
hump	11	62	2872	2	hump
impi	8	54	1579	2	_impi
imps	8	62	2112	2	_imps
jam	12	69	4252	2	jam_
jamb	15	55	2385	2	jamb
jams	13	52	3107	2	jams
jaup	13	53	1642	2	jaup
jeep	13	56	2484	2	jeep
jiao	11	50	1785	2	jiao
jib	12	58	3598	2	ji_b
jibb	15	58	1675	2	jibb
jibe	13	63	2340	2	jibe
jibs	13	67	2409	2	jibs
jiff	17	53	2142	2	jiff
jig	11	56	3352	2	ji_g
jigs	12	65	2477	2	jigs
jill	11	64	3027	2	jill
jilt	11	58	3943	2	jilt
jimmy	19	53	850	2	jimmy
jimper	17	38	986	2	jimper
jimply	20	39	748	2	jimply
jin	10	64	4394	2	ji_n
jink	15	62	2721	2	jink
jinn	11	54	2025	2	jinn
jins	11	56	3502	2	jins
jinx	18	55	1658	2	jinx
jism	13	55	1478	2	jism
jisms	14	45	800	2	jisms
jive	14	61	2360	2	jive
jivy	17	62	1312	2	jivy
jumps	16	51	1649	2	jumps
jumpy	19	57	1281	2	jumpy
kemp	12	64	1877	2	kemp
kip	9	70	4215	2	ki_p
lamp	8	62	3382	2	lamp
lima	6	57	3414	2	lima
limb	8	54	2939	2	limb
lime	6	62	4494	2	lime
limn	6	65	2770	2	limn
limo	6	55	2974	2	limo
limpa	9	70	1446	2	limpa
limps	9	55	2267	2	limps
limy	9	57	2772	2	limy
lip	5	147	5581	2	li_p
lisp	6	89	2689	2	lisp
lump	8	65	3170	2	lump
mim	7	60	4843	2	mim_
mime	8	57	3641	2	mime
mump	10	54	2572	2	mump
nim	5	71	4296	2	nim_
nims	6	62	2689	2	nims
nip	5	69	4599	2	ni_p
pima	8	54	2866	2	pima
pimps	11	46	1698	2	pimps
pip	7	80	5105	2	pi_p
pomp	10	62	2546	2	pomp
primp	11	56	1592	2	primp
pump	10	57	2685	2	pump
ramp	8	59	3400	2	ramp
rim	5	60	5228	2	rim_
rime	6	51	3889	2	rime
rims	6	59	3631	2	rims
rimy	9	66	2129	2	rimy
rip	5	68	5131	2	ri_p
romp	8	59	2657	2	romp
rump	8	67	2908	2	rump
samp	8	57	3359	2	samp
sim	5	65	5315	2	sim_
sima	6	47	3079	2	sima
simps	9	47	1976	2	simps
sims	6	57	3718	2	sims
sip	5	76	5602	2	si_p
skimp	13	54	1133	2	skimp
sump	8	63	3153	2	sump
tamp	8	61	3301	2	tamp
temp	8	53	2333	2	temp
time	6	62	3502	2	time
tip	5	65	5123	2	ti_p
tump	8	59	2703	2	tump
ump	7	61	3044	2	_ump
vamp	11	55	2154	2	vamp
vim	8	74	3703	2	vim_
vims	9	54	2332	2	vims
wimps	12	52	1380	2	wimps
wimpy	15	59	1192	2	wimpy
wisp	9	71	2408	2	wisp
yip	8	72	4119	2	yi_p
zip	14	66	3623	2	zi_p

Search took 2 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	29872	0.266	671770.7
2	DLD Change Limit	29872	121	0.890	33564.0
3	Display Results	121	121	0.016	7562.5
	(SQL Overall)	178691	121	1.172	152466.7