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

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

154 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
ritz	13	51	2998	(None)
ditz	14	69	2951	1	ditz
fritz	17	60	2077	1	fritz
rite	4	58	4945	1	rite
ritzy	17	56	1116	1	ritzy
ait	3	80	9390	2	ait_
aits	4	63	5553	2	aits
bit	5	70	7090	2	bit_
bite	6	65	4700	2	bite
bits	6	61	4816	2	bits
bitt	6	55	4581	2	bitt
biz	14	79	3936	2	bi_z
blitz	16	53	1813	2	blitz
brit	6	63	5015	2	brit_
brith	10	49	2437	2	brith
brits	7	64	3308	2	brits
britt	7	57	3223	2	britt
cite	6	56	4034	2	cite
city	9	51	2262	2	city
crit	6	57	4371	2	crit_
crits	7	55	2757	2	crits
dit	4	70	7133	2	dit_
dita	5	60	3252	2	dita
dite	5	55	4755	2	dite
dits	5	64	5052	2	dits
ditzy	18	65	1328	2	ditzy
fit	6	63	6545	2	fit_
fits	7	60	4346	2	fits
fiz	15	62	3876	2	fi_z
fizz	15	75	1982	2	fizz
frit	7	70	4447	2	frit_
frith	11	59	2203	2	frith
frits	8	61	2910	2	frits
fritt	8	61	2941	2	fritt
friz	16	63	2434	2	fri_z
frizz	16	55	1262	2	frizz
futz	16	78	2380	2	futz
git	4	62	6605	2	git_
gite	5	54	3861	2	gite
gits	5	57	4459	2	gits
glitz	15	49	1637	2	glitz
grit	5	52	4724	2	grit_
grith	9	55	2037	2	grith
grits	6	55	2958	2	grits
hit	6	65	6919	2	hit_
hits	7	55	4513	2	hits
it	2	84	5568	2	_it_
its	3	55	3883	2	_its
kit	7	85	5987	2	kit_
kite	8	53	3823	2	kite
kith	11	58	2635	2	kith
kits	8	64	4176	2	kits
lit	3	93	7731	2	lit_
lite	4	70	5454	2	lite
lits	4	62	5249	2	lits
litu	4	76	3156	2	litu
lutz	13	68	2632	2	lutz
mite	6	62	4941	2	mite
mitt	6	61	4549	2	mitt
mity	9	55	2821	2	mity
nit	3	70	6594	2	nit_
nite	4	59	4358	2	nite
nits	4	57	4164	2	nits
pit	5	64	7192	2	pit_
pita	6	54	3643	2	pita
pith	9	54	3269	2	pith
pits	6	63	4874	2	pits
pity	9	60	3193	2	pity
putz	15	83	2632	2	putz
raita	5	46	2307	2	raita
rat	3	78	9274	2	rat_
rate	4	54	5876	2	rate
rath	7	60	3766	2	rath
rato	4	54	3697	2	rato
rats	4	62	6037	2	rats
razz	12	52	1942	2	razz
ret	3	59	8283	2	ret_
rete	4	49	4413	2	rete
rets	4	53	5256	2	rets
ria	3	67	4550	2	ri_a
rial	4	59	3809	2	rial
rias	4	55	4059	2	rias
riata	5	46	1802	2	riata
rib	5	68	4803	2	ri_b
ribs	6	58	3302	2	ribs
rice	6	49	4291	2	rice
rich	9	70	2554	2	rich
rick	10	73	3465	2	rick
rid	4	67	5462	2	ri_d
ride	5	59	4512	2	ride
rids	5	65	3954	2	rids
riel	4	64	3238	2	riel
rif	6	59	5156	2	ri_f
rife	7	46	3232	2	rife
riff	10	44	3010	2	riff
rifs	7	49	2900	2	rifs
rift	7	56	4233	2	rift
rifts	8	57	1864	2	rifts
rig	4	67	4812	2	ri_g
rigs	5	51	3759	2	rigs
rile	4	56	5053	2	rile
rill	4	51	4090	2	rill
rim	5	60	5227	2	ri_m
rime	6	51	3888	2	rime
rims	6	59	3630	2	rims
rimy	9	66	2128	2	rimy
rin	3	66	6318	2	ri_n
rind	5	65	3560	2	rind
ring	5	65	4115	2	ring
rink	8	77	3699	2	rink
rins	4	61	5319	2	rins
riot	4	59	4721	2	riot
riots	5	49	2201	2	riots
rip	5	68	5130	2	ri_p
ripe	6	60	3892	2	ripe
rips	6	62	3743	2	rips
rise	4	59	4523	2	rise
risk	8	57	2410	2	risk
rites	5	44	4255	2	rites
ritzes	15	48	1294	2	ritzes
rive	7	55	3772	2	rive
rot	3	72	8295	2	rot_
rota	4	58	3434	2	rota
rote	4	62	4902	2	rote
roti	4	63	3292	2	roti
rotl	4	50	2968	2	rotl
roto	4	59	3505	2	roto
rots	4	64	5409	2	rots
rut	3	55	6052	2	rut_
ruth	7	68	2599	2	ruth
ruts	4	45	4149	2	ruts
sit	3	58	7775	2	sit_
site	4	70	5241	2	site
sith	7	54	3515	2	sith
sits	4	50	5020	2	sits
spitz	16	60	1796	2	spitz
spritz	17	47	1441	2	spritz
tit	3	67	7104	2	tit_
titi	4	71	3061	2	titi
tits	4	61	4503	2	tits
trite	5	47	3003	2	trite
vita	7	58	2852	2	vita
wit	6	65	6377	2	wit_
wite	7	54	4327	2	wite
with	10	57	3047	2	with
wits	7	60	4487	2	wits
wiz	15	64	3415	2	wi_z
writ	7	55	3791	2	writ_
write	8	55	2283	2	write
writs	8	66	2438	2	writs
yutz	16	75	1988	2	yutz
zit	12	60	4999	2	zit_
ziti	13	60	2237	2	ziti
zits	13	60	3029	2	zits

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.076	2351197.4
2	DLD Change Limit	29872	154	1.080	27659.3
3	Display Results	154	154	0.030	5133.3
	(SQL Overall)	178691	154	1.186	150666.9