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

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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
Check this box to automatically increase the Change Limit after seconds.

77 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
size	13	56	3097	1	size
sizy	16	48	1640	1	sizy
biff	12	50	2690	2	biff
biz	14	79	3937	2	biz_
bize	15	59	2630	2	bize
dif	7	68	4691	2	di_f
diff	11	62	2885	2	diff
fief	10	73	3137	2	fief
fiz	15	62	3877	2	fiz_
fizz	15	75	1983	2	fizz
if	5	72	3996	2	_i_f
iff	9	67	3040	2	_iff
jiff	17	53	2142	2	jiff
kief	11	71	2842	2	kief
kif	10	59	4120	2	ki_f
lief	7	60	3700	2	lief
miff	12	56	2507	2	miff
rif	6	59	5157	2	ri_f
riff	10	44	3011	2	riff
seif	7	56	3873	2	seif
seize	14	38	1950	2	seize
self	7	51	3829	2	self
serf	7	63	4011	2	serf
si	2	91	4958	2	si__
sial	4	59	3884	2	sial
sib	5	68	5032	2	si_b
sibb	8	59	2143	2	sibb
sibs	6	59	3355	2	sibs
sic	5	58	4788	2	si_c
sice	6	55	4560	2	sice
sick	10	64	3558	2	sick
sics	6	52	3410	2	sics
side	5	54	4450	2	side
sidh	8	62	2300	2	sidh
sift	7	107	4067	2	sift
sigh	8	56	2590	2	sigh
sign	5	55	2306	2	sign
sika	8	60	2133	2	sika
sike	8	71	3879	2	sike
sild	5	50	3059	2	sild
silk	8	55	2933	2	silk
sill	4	55	4516	2	sill
silo	4	60	3792	2	silo
silt	4	65	5820	2	silt
sim	5	65	5315	2	si_m
sima	6	47	3079	2	sima
simp	8	52	2878	2	simp
sims	6	57	3718	2	sims
sin	3	62	6590	2	si_n
sine	4	65	6063	2	sine
sing	5	75	4418	2	sing
sinh	7	62	3805	2	sinh
sink	8	66	4015	2	sink
sins	4	67	5528	2	sins
sip	5	76	5602	2	si_p
sipe	6	73	4105	2	sipe
sips	6	57	4011	2	sips
sir	3	57	4668	2	si_r
sire	4	61	5042	2	sire
sirs	4	43	3834	2	sirs
sis	3	73	6055	2	si_s
sit	3	58	7776	2	si_t
site	4	70	5242	2	site
sith	7	54	3516	2	sith
sits	4	50	5021	2	sits
six	10	53	3975	2	si_x
sizar	14	52	1499	2	sizar
sized	15	55	1924	2	sized
sizer	14	55	2181	2	sizer
sizes	14	67	2776	2	sizes
skiff	15	36	1281	2	skiff
sniff	11	39	1586	2	sniff
spiff	13	36	1640	2	spiff
stiff	11	42	1924	2	stiff
surf	7	60	3931	2	surf
tiff	10	47	2773	2	tiff
wiz	15	64	3416	2	wiz_

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	77	1.046	28558.3
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	1.392	128370.0