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

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

111 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
refit	8	42	3006	(None)
befit	10	52	2266	1	befit
recit	7	52	3510	1	recit
refits	9	40	1765	1	refits
refix	15	52	1248	1	refix
reft	7	51	4127	1	ref_t
relit	5	53	4068	1	relit
remit	7	57	3722	1	remit
resit	5	42	4104	1	resit
barefit	12	4	972	2	barefit
befits	11	47	1150	2	befits
credit	9	3	1519	2	credit
debit	8	57	2785	2	debit
defat	9	54	2669	2	defat
defi	8	63	2149	2	defi_
defis	9	67	1750	2	defis
deft	8	55	4022	2	def_t
demit	8	48	3230	2	demit
edit	5	49	3487	2	_edit
eft	6	60	3882	2	_ef_t
emit	6	54	3842	2	_emit
exit	11	44	2867	2	_exit
fit	6	63	6546	2	__fit
heft	10	67	3629	2	hef_t
kefir	12	45	791	2	kefir
left	7	63	4048	2	lef_t
legit	6	13	2350	2	legit
merit	7	3	3918	2	merit
petit	7	43	3265	2	petit
pewit	10	46	2279	2	pewit
prefix	18	35	685	2	prefix
profit	11	30	1627	2	profit
raft	7	62	4591	2	raf_t
react	7	46	3433	2	react
rebait	8	3	2040	2	rebait
rebid	8	51	2136	2	rebid
rebut	7	59	2738	2	rebut
recite	8	36	2511	2	recite
recits	8	36	2135	2	recits
recti	7	36	1962	2	recti
recut	7	47	2924	2	recut
redfin	10	3	1022	2	redfin
redia	6	55	2448	2	redia
redid	7	49	2239	2	redid
redip	8	78	1696	2	redip
redipt	9	41	1674	2	redipt
reedit	7	6	1722	2	reedit
reemit	8	7	1722	2	reemit
reest	5	49	3809	2	reest
ref	6	60	5329	2	ref__
refect	11	43	1933	2	refect
refed	9	39	2192	2	refed
refel	8	49	2081	2	refel
refelt	9	45	2142	2	refelt
refer	8	48	2214	2	refer
refight	14	8	887	2	refight
refile	9	51	2237	2	refile
refill	9	45	1405	2	refill
refilm	11	43	1140	2	refilm
refind	10	47	1707	2	refind
refine	9	52	2569	2	refine
refire	9	54	1947	2	refire
reflet	9	40	2423	2	reflet
refly	11	39	1456	2	refly
refry	11	44	1246	2	refry
refs	7	57	3224	2	ref_s
refute	9	55	1570	2	refute
regilt	7	12	1749	2	regilt
rei	3	56	4725	2	re_i_
reif	7	69	3765	2	re_if
reifs	8	48	1909	2	reifs
reify	11	48	1497	2	reify
rein	4	60	4089	2	re_in
reis	4	53	4323	2	re_is
rejig	13	38	1012	2	rejig
reknit	10	3	1253	2	reknit
relet	5	47	4982	2	relet
relic	7	46	2336	2	relic
relict	8	36	2390	2	relict
relist	6	46	2841	2	relist
remet	7	48	4372	2	remet
remint	8	53	2998	2	remint
remits	8	56	2294	2	remits
remix	14	59	1655	2	remix
remixt	15	50	1485	2	remixt
renig	6	45	1891	2	renig
renin	5	48	3003	2	renin
rent	4	66	6124	2	re_nt
reoil	5	53	2118	2	reoil
repin	7	53	2470	2	repin
repot	7	51	3262	2	repot
rerig	6	40	1848	2	rerig
resat	5	51	3968	2	resat
reset	5	50	5186	2	reset
resid	6	41	2409	2	resid
resift	9	40	1772	2	resift
resin	5	41	3105	2	resin
resist	6	45	2453	2	resist
resite	6	41	2845	2	resite
resits	6	47	2556	2	resits
rest	4	64	5984	2	re_st
ret	3	59	8283	2	re__t
retia	5	53	2611	2	retia
retie	5	57	3530	2	retie
retint	6	56	3344	2	retint
revet	8	49	3884	2	revet
rewet	8	51	3515	2	rewet
rewin	8	56	2396	2	rewin
rift	7	56	4234	2	rif_t
unfit	8	45	1856	2	unfit
weft	10	54	3501	2	wef_t

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	53800	0.330	541487.9
2	DLD Change Limit	53800	111	1.436	37465.2
3	Display Results	111	111	0.030	3700.0
	(SQL Overall)	178691	111	1.796	99493.9