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

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

119 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
lutz	13	68	2632	(None)
futz	16	78	2380	1	futz
klutz	18	6	885	1	klutz
lute	4	63	4101	1	lute
putz	15	83	2632	1	putz
yutz	16	75	1988	1	yutz
auto	4	74	3208	2	auto
blitz	16	53	1813	2	blitz
but	5	59	6302	2	but_
bute	6	67	3967	2	bute
buts	6	72	4769	2	buts
butt	6	51	4374	2	butt
buzz	14	66	1780	2	buzz
cut	5	79	5766	2	cut_
cute	6	64	4045	2	cute
cuts	6	58	4115	2	cuts
ditz	14	69	2952	2	ditz
duty	8	53	2145	2	duty
elute	5	48	2257	2	elute
flute	8	68	2375	2	flute
fluty	11	44	1564	2	fluty
fuzz	15	84	2057	2	fuzz
glitz	15	49	1637	2	glitz
glut	5	63	3129	2	glut_
glute	6	60	2090	2	glute
gluts	6	61	2013	2	gluts
gut	4	67	5385	2	gut_
guts	5	66	3725	2	guts
halutz	18	6	885	2	halutz
hut	6	64	5729	2	hut_
huts	7	67	3744	2	huts
jut	10	59	4401	2	jut_
jute	11	53	2789	2	jute
juts	11	59	3016	2	juts
klutzy	22	4	300	2	klutzy
lat	3	75	9340	2	lat_
late	4	75	6048	2	late
lath	7	66	4038	2	lath
lati	4	64	3827	2	lati
lats	4	59	6270	2	lats
latu	4	79	3418	2	latu
let	3	64	8147	2	let_
lets	4	71	4794	2	lets
lez	12	55	4131	2	l_ez
lit	3	93	7732	2	lit_
lite	4	70	5455	2	lite
lits	4	62	5250	2	lits
litu	4	76	3157	2	litu
lot	3	81	7926	2	lot_
lota	4	72	3350	2	lota
loth	7	61	3213	2	loth
loti	4	64	3184	2	loti
lots	4	76	5209	2	lots
lout	4	59	5214	2	lout_
louts	5	63	3027	2	louts
luau	4	48	2416	2	luau
lube	6	47	3156	2	lube
luce	6	51	3257	2	luce
luck	10	53	2982	2	luck
lude	5	53	3165	2	lude
lues	4	59	4355	2	lues
luff	10	44	2670	2	luff
lug	4	61	3806	2	lu_g
luge	5	55	3164	2	luge
lugs	5	52	3352	2	lugs
lull	4	42	2576	2	lull
lulu	4	41	2288	2	lulu
lum	5	55	4293	2	lu_m
luma	6	55	2752	2	luma
lump	8	65	3170	2	lump
lums	6	57	3424	2	lums
luna	4	62	2985	2	luna
lune	4	71	4049	2	lune
lung	5	57	3249	2	lung
lunk	8	60	3072	2	lunk
lunt	4	61	4884	2	lunt
lunts	5	58	2690	2	lunts
luny	7	73	2413	2	luny
lure	4	51	4246	2	lure
lurk	8	66	2416	2	lurk
lush	7	53	2769	2	lush
lust	4	74	4260	2	lust
lusts	5	50	2280	2	lusts
lusty	8	54	1757	2	lusty
lutea	5	48	1907	2	lutea
luted	6	48	2614	2	luted
lutes	5	58	3666	2	lutes
lutzes	15	37	1192	2	lutzes
luv	6	71	2577	2	lu_v
luvs	7	58	1850	2	luvs
lux	10	65	2877	2	lu_x
luxe	11	52	2269	2	luxe
mut	5	83	5718	2	mut_
mute	6	51	3687	2	mute
muts	6	48	3998	2	muts
mutt	6	57	3940	2	mutt
nut	3	66	5196	2	nut_
nuts	4	50	3267	2	nuts
out	3	80	7215	2	out_
outs	4	57	4696	2	outs
plotz	16	46	1700	2	plotz
put	5	57	5907	2	put_
puts	6	56	4175	2	puts
putt	6	69	3784	2	putt
quiz	22	49	2000	2	quiz
ritz	13	51	2999	2	ritz
rut	3	55	6052	2	rut_
ruth	7	68	2599	2	ruth
ruts	4	45	4149	2	ruts
slut	4	50	4059	2	slut_
sluts	5	45	2398	2	sluts
tut	3	67	5809	2	tut_
tuts	4	58	3845	2	tuts
tutu	4	84	2317	2	tutu
ut	2	86	4703	2	_ut_
uta	3	74	2558	2	_uta
ute	3	53	3588	2	_ute
uts	3	55	3437	2	_uts
zuz	11	106	2203	2	zu_z

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.313	570897.8
2	DLD Change Limit	29872	119	0.796	37527.6
3	Display Results	119	119	0.030	3966.7
	(SQL Overall)	178691	119	1.139	156884.1