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

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

150 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
ditz	14	69	2951	(None)
dit	4	70	7133	1	dit_
dita	5	60	3252	1	dita
dite	5	55	4755	1	dite
dits	5	64	5052	1	dits
ditzy	18	65	1328	1	ditzy
ritz	13	51	2998	1	ritz
adit	5	64	4365	2	adit_
adits	6	65	2371	2	adits
ait	3	80	9390	2	ait_
aits	4	63	5553	2	aits
bit	5	70	7089	2	bit_
bite	6	65	4699	2	bite
bits	6	61	4815	2	bits
bitt	6	55	4580	2	bitt
biz	14	79	3935	2	bi_z
blitz	16	53	1813	2	blitz
cite	6	56	4034	2	cite
city	9	51	2262	2	city
data	5	60	2665	2	data
date	5	64	4332	2	date
dato	5	61	2994	2	dato
deity	9	43	1677	2	deity
dial	5	59	3506	2	dial
diazo	15	3	1003	2	diazo
dib	6	57	4693	2	di_b
dibs	7	62	3367	2	dibs
dice	7	58	4189	2	dice
dick	11	64	3238	2	dick
dicta	8	49	1563	2	dicta
dicty	11	51	1629	2	dicty
did	5	68	5051	2	di_d
dido	6	65	2819	2	dido
didy	9	91	2150	2	didy
die	4	67	5965	2	di_e
died	6	61	3785	2	died
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
diets	6	60	2664	2	diets
dif	7	68	4689	2	di_f
diff	11	62	2883	2	diff
difs	8	60	2732	2	difs
dig	5	75	4447	2	di_g
digs	6	60	3605	2	digs
dike	9	59	3576	2	dike
dill	5	52	3997	2	dill
dim	6	81	4649	2	di_m
dime	7	62	3764	2	dime
dims	7	54	3502	2	dims
din	4	64	5946	2	di_n
dine	5	55	5533	2	dine
ding	6	69	4095	2	ding
dink	9	71	3780	2	dink
dino	5	60	3675	2	dino
dins	5	66	5204	2	dins
dint	5	67	5905	2	dint
dints	6	74	3131	2	dints
diol	5	73	2913	2	diol
dip	6	78	4898	2	di_p
dips	7	55	3691	2	dips
dipt	7	73	3932	2	dipt
dire	5	66	4414	2	dire
dirk	9	63	2683	2	dirk
dirl	5	74	3002	2	dirl
dirt	5	55	5038	2	dirt
dirts	6	68	2446	2	dirts
dirty	9	56	1780	2	dirty
dis	4	64	5989	2	di_s
disc	7	61	2323	2	disc
dish	8	63	2833	2	dish
disk	9	66	2583	2	disk
diss	5	64	3448	2	diss
ditas	6	59	2367	2	ditas
ditch	11	50	1509	2	ditch
dites	6	63	3915	2	dites
ditsy	9	56	1256	2	ditsy
ditto	6	53	1560	2	ditto
ditty	9	50	1929	2	ditty
ditzes	16	32	1242	2	ditzes
diva	8	59	2088	2	diva
dive	8	56	3477	2	dive
dizzy	17	74	1085	2	dizzy
doit	5	63	4785	2	doit_
doits	6	62	2367	2	doits
dot	4	75	7318	2	dot_
dote	5	54	4288	2	dote
doth	8	62	2571	2	doth
dots	5	56	4766	2	dots
doty	8	61	2822	2	doty
duit	5	62	4158	2	duit_
duits	6	50	2188	2	duits
duty	8	53	2145	2	duty
edit	5	49	3486	2	edit_
edits	6	58	1903	2	edits
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
fritz	17	60	2077	2	fritz
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
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	4940	2	mite
mitt	6	61	4548	2	mitt
mity	9	55	2820	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
rite	4	58	4945	2	rite
ritzy	17	56	1116	2	ritzy
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
tit	3	67	7104	2	tit_
titi	4	71	3061	2	titi
tits	4	61	4503	2	tits
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
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	150	1.110	26911.7
3	Display Results	150	150	0.033	4545.5
	(SQL Overall)	178691	150	1.219	146588.2