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

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

264 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
suits	5	50	2805	(None)
duits	6	50	2188	1	duits
quits	14	41	2235	1	quits
shits	8	47	3117	1	shits
sits	4	50	5020	1	s_its
skits	9	47	2186	1	skits
slits	5	61	2885	1	slits
snits	5	41	2483	1	snits
spits	7	44	2955	1	spits
suets	5	51	2610	1	suets
suints	6	46	1778	1	suints
suit	4	56	4987	1	suit_
suite	5	48	2956	1	suite
suites	6	37	2740	1	suites
adits	6	65	2371	2	adits
aits	4	63	5553	2	_aits
audits	7	28	1411	2	audits
aunts	5	52	2763	2	aunts
baits	7	66	3058	2	baits
bits	6	61	4816	2	_bits
brits	7	64	3308	2	brits
bruits	8	57	1445	2	bruits
bunts	7	57	2980	2	bunts
busts	7	52	2769	2	busts
buts	6	72	4769	2	bu_ts
butts	7	58	2425	2	butts
chits	10	54	2457	2	chits
crits	7	55	2757	2	crits
cubits	10	37	1403	2	cubits
cuifs	10	48	1469	2	cuifs
cults	7	50	2255	2	cults
cunts	7	61	2512	2	cunts
cutis	7	77	2376	2	cutis
cuts	6	58	4115	2	cu_ts
dits	5	64	5052	2	_dits
doits	6	62	2367	2	doits
ducts	8	53	1989	2	ducts
duets	6	53	2388	2	duets
duit	5	62	4158	2	duit_
dunts	6	58	2841	2	dunts
dusts	6	59	2356	2	dusts
edits	6	58	1903	2	edits
emits	7	54	2147	2	emits
exits	12	55	1591	2	exits
fits	7	60	4346	2	_fits
flits	8	56	2522	2	flits
frits	8	61	2910	2	frits
fruits	9	45	1249	2	fruits
gaits	6	57	2601	2	gaits
gits	5	57	4459	2	_gits
grits	6	55	2958	2	grits
guids	7	55	1615	2	guids
guilts	7	41	1123	2	guilts
gusts	6	57	2279	2	gusts
guts	5	66	3725	2	gu_ts
hits	7	55	4513	2	_hits
hunts	8	68	2617	2	hunts
hurts	8	69	2282	2	hurts
huts	7	67	3744	2	hu_ts
its	3	55	3883	2	__its
jesuits	14	3	632	2	jesuits
justs	12	49	1826	2	justs
juts	11	59	3016	2	ju_ts
kits	8	64	4177	2	_kits
knits	9	39	1474	2	knits
lits	4	62	5249	2	_lits
lunts	5	58	2690	2	lunts
lusts	5	50	2280	2	lusts
musts	7	55	2744	2	musts
muts	6	48	3998	2	mu_ts
mutts	7	51	2025	2	mutts
nits	4	57	4164	2	_nits
nuts	4	50	3267	2	nu_ts
obits	7	46	1755	2	obits
omits	7	50	1826	2	omits
ousts	5	52	2570	2	ousts
outs	4	57	4696	2	ou_ts
pits	6	63	4874	2	_pits
punts	7	58	2800	2	punts
puts	6	56	4175	2	pu_ts
putts	7	57	1927	2	putts
qubits	17	37	1035	2	qubits
quids	15	49	1746	2	quids
quiets	15	40	1437	2	quiets
quilts	15	41	1254	2	quilts
quins	14	48	1985	2	quins
quints	15	43	1656	2	quints
quips	16	47	1337	2	quips
quirts	15	42	1355	2	quirts
quit	13	61	3651	2	quit_
quite	14	46	2146	2	quite
quoits	15	37	968	2	quoits
ruins	5	58	2203	2	ruins
runts	5	59	2763	2	runts
rusts	5	50	2699	2	rusts
ruts	4	45	4149	2	ru_ts
saids	6	53	2885	2	saids
sails	5	57	3810	2	sails
sains	5	56	3997	2	sains
saints	6	51	2242	2	saints
saith	8	58	2655	2	saith
salts	5	54	3188	2	salts
satis	5	56	3368	2	satis
saults	6	58	1617	2	saults
scats	7	59	3060	2	scats
schuits	12	3	582	2	schuits
scots	7	40	2591	2	scots
scuts	7	45	2252	2	scuts
seats	5	48	4434	2	seats
sects	7	56	2289	2	sects
seifs	8	50	1933	2	seifs
seis	4	55	4239	2	sei_s
septs	7	54	2060	2	septs
sets	4	55	4950	2	s_ets
setts	5	51	2432	2	setts
sexts	12	51	1838	2	sexts
shies	8	61	3655	2	shies
shifts	12	44	1294	2	shifts
shims	10	44	2255	2	shims
shins	8	51	3104	2	shins
ships	10	51	2377	2	ships
shirts	9	49	1834	2	shirts
shist	8	48	2961	2	shist
shists	9	65	1511	2	shists
shit	7	67	4594	2	shit_
shivs	11	50	1880	2	shivs
shots	8	47	3085	2	shots
shunts	9	57	1202	2	shunts
shuts	8	56	2248	2	shuts
sibs	6	59	3354	2	s_ibs
sics	6	52	3409	2	s_ics
sifts	8	49	1892	2	sifts
silts	5	53	3082	2	silts
sims	6	57	3717	2	s_ims
sins	4	67	5527	2	s_ins
sips	6	57	4010	2	s_ips
sirs	4	43	3833	2	s_irs
sis	3	73	6054	2	s_i_s
sit	3	58	7775	2	s_it_
site	4	70	5241	2	s_ite
sites	5	60	4543	2	s_ites
sith	7	54	3515	2	s_ith
situs	5	50	1923	2	s_itus
skats	9	46	2154	2	skats
skids	10	46	1533	2	skids
skies	9	50	2683	2	skies
skims	11	45	1719	2	skims
skins	9	47	2346	2	skins
skips	11	56	1660	2	skips
skirts	10	41	1150	2	skirts
skis	8	48	2529	2	ski_s
skit	8	54	3753	2	skit_
skite	9	51	2005	2	skite
skites	10	44	1804	2	skites
slats	5	54	3690	2	slats
slims	7	54	2365	2	slims
slips	7	60	2372	2	slips
slit	4	62	5010	2	slit_
slots	5	48	3053	2	slots
sluts	5	45	2398	2	sluts
smit	6	51	3841	2	smit_
smite	7	52	2487	2	smite
smites	8	39	2192	2	smites
smith	10	78	1805	2	smith
smiths	11	47	1102	2	smiths
smuts	7	54	1571	2	smuts
snibs	7	56	1376	2	snibs
snips	7	58	1801	2	snips
snit	4	63	4247	2	snit_
snots	5	52	2512	2	snots
softs	8	50	1923	2	softs
soils	5	53	2798	2	soils
soots	5	55	3621	2	soots
sorts	5	45	3666	2	sorts
sots	4	55	5245	2	s_ots
spaits	8	50	1747	2	spaits
spats	7	50	3138	2	spats
spics	9	41	2324	2	spics
spies	7	60	3762	2	spies
spiks	11	41	1747	2	spiks
spins	7	53	2798	2	spins
spirts	8	53	1713	2	spirts
spit	6	55	4508	2	spit_
spite	7	54	3066	2	spite
spites	8	41	2733	2	spites
spitz	16	60	1797	2	spitz
spivs	10	51	1424	2	spivs
splits	8	54	1641	2	splits
spots	7	44	2411	2	spots
sprits	8	51	2253	2	sprits
spurts	8	48	1497	2	spurts
squats	15	37	1296	2	squats
squibs	17	31	745	2	squibs
squids	16	40	980	2	squids
squints	16	33	903	2	squints
squirts	16	34	801	2	squirts
sris	4	54	3415	2	sri_s
stats	5	59	3336	2	stats
stets	5	54	2391	2	stets
sties	5	51	3298	2	sties
stilts	6	79	1531	2	stilts
stints	6	51	1976	2	stints
stirs	5	59	2162	2	stirs
stots	5	48	2855	2	stots
stunts	6	56	1525	2	stunts
sturts	6	39	1514	2	sturts
subas	7	47	2407	2	subas
subito	8	4	1045	2	subito
submits	11	3	975	2	submits
subs	6	60	3712	2	su_bs
sucks	11	45	2307	2	sucks
sudds	7	55	1359	2	sudds
suds	5	61	3529	2	su_ds
suers	5	51	2848	2	suers
sues	4	62	4765	2	su_es
suet	4	67	5482	2	suet_
suety	8	53	1849	2	suety
sughs	9	53	1332	2	sughs
suing	6	50	2636	2	suing
suint	5	56	3818	2	suint
suited	7	40	1942	2	suited
suiter	6	41	2181	2	suiter
suiters	7	36	1888	2	suiters
suitor	6	33	1105	2	suitor
suitors	7	30	1249	2	suitors
suks	8	59	2712	2	su_ks
sulks	9	48	1846	2	sulks
sulus	5	48	2188	2	sulus
summits	11	3	798	2	summits
sumos	7	57	2009	2	sumos
sumps	9	50	2343	2	sumps
sums	6	58	3758	2	su_ms
sunns	5	50	1735	2	sunns
suns	4	58	4190	2	su_ns
supes	7	56	2830	2	supes
sups	6	48	3443	2	su_ps
suqs	13	43	1965	2	su_qs
suras	5	53	3633	2	suras
surds	6	56	2466	2	surds
surfs	8	50	2254	2	surfs
suss	4	52	2930	2	su_ss
sutta	5	40	1533	2	sutta
suttas	6	38	1379	2	suttas
swats	8	57	2686	2	swats
swifts	12	40	817	2	swifts
swigs	9	62	1366	2	swigs
swims	10	55	1414	2	swims
swiss	8	67	1290	2	swiss
swith	11	59	1740	2	swith
swots	8	55	1843	2	swots
tits	4	61	4504	2	_tits
toits	5	53	2747	2	toits
tufts	8	57	1327	2	tufts
tuis	4	48	2964	2	tui_s
tuts	4	58	3845	2	tu_ts
twits	8	60	1579	2	twits
units	5	49	2343	2	units
uts	3	55	3437	2	_u_ts
waits	8	83	3352	2	waits
whits	11	59	2382	2	whits
wits	7	60	4487	2	_wits
writs	8	66	2438	2	writs
yurts	8	72	1653	2	yurts
zits	13	60	3029	2	_zits

Search took 3 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	264	1.890	28465.6
3	Display Results	264	264	0.093	2838.7
	(SQL Overall)	178691	264	2.313	77255.1