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

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

300 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
gaits	6	57	2601	(None)
aits	4	63	5553	1	_aits
baits	7	66	3058	1	baits
gains	6	57	2951	1	gains
gait	5	61	5019	1	gait_
gasts	6	66	2863	1	gasts
gats	5	67	5344	1	ga_ts
gits	5	57	4459	1	g_its
grits	6	55	2958	1	grits
waits	8	83	3352	1	waits
acts	6	69	2986	2	_acts
adits	6	65	2371	2	adits
agios	6	59	1986	2	agios
agist	6	63	2558	2	agist
agists	7	57	1317	2	agists
agita	6	3	1542	2	agita
agitas	7	3	1059	2	agitas
aids	5	78	4636	2	_aids
ails	4	56	5471	2	_ails
aims	6	77	3818	2	_aims
ains	4	61	5888	2	_ains
airs	4	64	4742	2	_airs
airts	5	56	2634	2	_airts
ais	3	90	8357	2	_ai_s
ait	3	80	9390	2	_ait_
alts	4	66	3990	2	_alts
ants	4	72	4347	2	_ants
arts	4	96	5026	2	_arts
awaits	9	64	1195	2	awaits
bahts	10	56	1780	2	bahts
bails	7	59	3352	2	bails
bait	6	65	5600	2	bait_
baith	10	80	2313	2	baith
basts	7	59	3693	2	basts
bats	6	69	6233	2	ba_ts
batts	7	67	2756	2	batts
bits	6	61	4816	2	_bits
brits	7	64	3308	2	brits
caids	8	52	2642	2	caids
cains	7	53	3430	2	cains
cants	7	70	3694	2	cants
carts	7	89	4629	2	carts
casts	7	72	3779	2	casts
cats	6	63	5634	2	ca_ts
chits	10	54	2457	2	chits
crits	7	55	2757	2	crits
dais	5	70	4070	2	dai_s
darts	6	76	3573	2	darts
dauts	6	78	2224	2	dauts
davits	10	40	1236	2	davits
dawts	9	72	1612	2	dawts
dits	5	64	5052	2	_dits
doits	6	62	2367	2	doits
duits	6	50	2188	2	duits
easts	5	75	3032	2	easts
eats	4	70	5487	2	ea_ts
edits	6	58	1903	2	edits
emits	7	54	2147	2	emits
exits	12	55	1591	2	exits
facts	10	70	2189	2	facts
fails	8	56	3148	2	fails
faints	9	48	1878	2	faints
fairs	8	58	2544	2	fairs
faith	11	56	2085	2	faith
faiths	12	46	1027	2	faiths
farts	8	83	3684	2	farts
fasts	8	64	2968	2	fasts
fats	7	62	5250	2	fa_ts
fiats	8	53	2448	2	fiats
fits	7	60	4346	2	_fits
flits	8	56	2522	2	flits
frits	8	61	2910	2	frits
gabies	9	38	2073	2	gabies
gabs	7	67	4042	2	ga_bs
gadids	9	56	1182	2	gadids
gadis	7	48	2529	2	gadis
gads	6	78	4338	2	ga_ds
gaes	5	63	4803	2	ga_es
gaffs	12	49	1465	2	gaffs
gages	7	45	2997	2	gages
gags	6	64	4106	2	ga_gs
gaiety	10	11	937	2	gaiety
gaily	9	50	2097	2	gaily
gain	5	60	4216	2	gai_n
gainst	7	49	1470	2	gainst
gaited	8	44	1692	2	gaited
gaiter	7	38	1950	2	gaiter
gaiters	8	35	1654	2	gaiters
galas	6	57	3164	2	galas
gales	6	54	4248	2	gales
galiots	8	23	1132	2	galiots
galls	6	47	2932	2	galls
gals	5	79	4650	2	ga_ls
gamas	8	54	3136	2	gamas
gambits	12	39	972	2	gambits
gambs	10	57	2112	2	gambs
games	8	62	3855	2	games
gamins	9	44	2005	2	gamins
gamps	10	53	2371	2	gamps
gams	7	66	4888	2	ga_ms
gamuts	9	5	878	2	gamuts
gangs	7	62	2258	2	gangs
gaols	6	67	1757	2	gaols
gapes	8	60	3082	2	gapes
gaps	7	60	4297	2	ga_ps
garbs	8	63	2141	2	garbs
gars	5	57	5074	2	ga_rs
garth	9	47	2022	2	garth
garths	10	41	1150	2	garths
gas	4	88	7025	2	ga__s
gases	6	56	3399	2	gases
gasps	8	54	1548	2	gasps
gast	5	60	5256	2	gast_
gat	4	68	8051	2	ga_t_
gate	5	57	4657	2	ga_te
gates	6	59	3951	2	gates
gauds	7	57	1772	2	gauds
gaults	7	41	1278	2	gaults
gaums	8	62	1707	2	gaums
gaurs	6	63	1799	2	gaurs
gauss	6	56	1345	2	gauss
gavots	10	3	811	2	gavots
gawks	13	68	1163	2	gawks
gawps	11	59	1101	2	gawps
gays	8	73	3802	2	ga_ys
gazes	15	54	2591	2	gazes
gelts	6	59	2461	2	gelts
gents	6	57	2961	2	gents
gests	6	60	2881	2	gests
gets	5	54	4248	2	g_ets
ghats	9	58	1861	2	ghats
ghauts	10	44	778	2	ghauts
ghis	8	50	2016	2	ghi_s
giants	7	47	1350	2	giants
gibs	7	55	2927	2	g_ibs
gids	6	59	3374	2	g_ids
gies	5	56	4142	2	g_ies
gifts	9	62	1496	2	gifts
gigs	6	66	3118	2	g_igs
gilts	6	49	2426	2	gilts
gins	5	55	4395	2	g_ins
gips	7	56	3292	2	g_ips
girts	6	54	2362	2	girts
gist	5	60	4676	2	g_ist
gists	6	60	2619	2	gists
git	4	62	6605	2	g_it_
gite	5	54	3861	2	g_ite
gites	6	56	3018	2	g_ites
glairs	7	52	1133	2	glairs
glias	6	46	1849	2	glias
glims	8	74	1767	2	glims
glints	7	57	1421	2	glints
glitz	15	49	1637	2	glitz
gluts	6	61	2013	2	gluts
gnats	6	52	1771	2	gnats
goats	6	55	2730	2	goats
gouts	6	48	2617	2	gouts
grafts	10	50	1325	2	grafts
grails	7	75	1878	2	grails
grains	7	42	2309	2	grains
grants	7	37	2247	2	grants
gratis	7	48	1924	2	gratis
grids	7	53	2139	2	grids
grifts	10	45	1168	2	grifts
grigs	7	53	1819	2	grigs
grins	6	54	2722	2	grins
griots	7	47	1364	2	griots
grips	8	55	2013	2	grips
grist	6	55	2987	2	grist
grists	7	47	1648	2	grists
grit	5	52	4724	2	grit_
grith	9	55	2037	2	grith
griths	10	52	1165	2	griths
grots	6	50	2585	2	grots
guids	7	55	1615	2	guids
guilts	7	41	1123	2	guilts
gusts	6	57	2279	2	gusts
guts	5	66	3725	2	g_uts
habits	11	30	1465	2	habits
haets	8	65	2512	2	haets
hafts	11	62	1946	2	hafts
haiks	12	51	2093	2	haiks
hails	8	52	3164	2	hails
haints	9	44	1758	2	haints
hairs	8	62	2517	2	hairs
halts	8	52	3010	2	halts
hants	8	63	3540	2	hants
harts	8	84	4159	2	harts
hats	7	68	5825	2	ha_ts
hits	7	55	4513	2	_hits
its	3	55	3883	2	__its
jails	12	54	2294	2	jails
kaifs	12	57	1564	2	kaifs
kails	9	55	2521	2	kails
kains	9	61	2564	2	kains
karts	9	76	3011	2	karts
kats	8	59	4433	2	ka_ts
kits	8	64	4177	2	_kits
knits	9	39	1474	2	knits
kraits	10	49	1220	2	kraits
laics	7	64	1925	2	laics
lairs	5	54	2587	2	lairs
laith	8	57	2210	2	laith
laity	8	53	1890	2	laity
lasts	5	77	3126	2	lasts
lats	4	59	6270	2	la_ts
lits	4	62	5249	2	_lits
maids	8	63	2714	2	maids
mails	7	60	3778	2	mails
maims	9	63	2179	2	maims
mains	7	56	3511	2	mains
mairs	7	62	2830	2	mairs
maist	7	55	3568	2	maist
maists	8	58	1757	2	maists
malts	7	63	3175	2	malts
marts	7	74	4223	2	marts
masts	7	70	3576	2	masts
mats	6	54	6029	2	ma_ts
matts	7	68	2918	2	matts
mauts	7	59	2719	2	mauts
naifs	8	76	1742	2	naifs
nails	5	57	3040	2	nails
nits	4	57	4164	2	_nits
oasts	5	65	2918	2	oasts
oats	4	65	5421	2	oa_ts
obits	7	46	1755	2	obits
omits	7	50	1826	2	omits
pacts	9	51	2580	2	pacts
paiks	11	47	1985	2	paiks
pails	7	58	3306	2	pails
pains	7	51	3828	2	pains
paints	8	59	2183	2	paints
pairs	7	53	2583	2	pairs
pants	7	65	3692	2	pants
parts	7	77	4337	2	parts
pasts	7	59	3650	2	pasts
pats	6	64	6085	2	pa_ts
pits	6	63	4874	2	_pits
plaits	8	38	1647	2	plaits
qaids	15	61	1631	2	qaids
qats	13	53	3134	2	qa_ts
quits	14	41	2235	2	quits
rafts	8	78	2063	2	rafts
raias	5	46	3112	2	raias
raids	6	58	2751	2	raids
rails	5	59	3740	2	rails
rains	5	51	4023	2	rains
rais	4	52	5262	2	rai_s
raita	5	46	2307	2	raita
raitas	6	44	1767	2	raitas
rants	5	59	3534	2	rants
rats	4	62	6037	2	ra_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
shits	8	47	3117	2	shits
sits	4	50	5020	2	_sits
skits	9	47	2186	2	skits
slits	5	61	2885	2	slits
snits	5	41	2483	2	snits
spaits	8	50	1747	2	spaits
spits	7	44	2955	2	spits
suits	5	50	2805	2	suits
tacts	7	65	2412	2	tacts
tails	5	56	3419	2	tails
tains	5	49	3632	2	tains
taints	6	45	2053	2	taints
tarts	5	72	4202	2	tarts
tats	4	68	5813	2	ta_ts
tauts	5	61	2551	2	tauts
tits	4	61	4504	2	_tits
toits	5	53	2747	2	toits
traits	6	51	2198	2	traits
twits	8	60	1579	2	twits
units	5	49	2343	2	units
vails	8	58	2593	2	vails
vairs	8	50	1913	2	vairs
vasts	8	64	2377	2	vasts
vats	7	68	4174	2	va_ts
wafts	11	69	2055	2	wafts
waifs	11	57	1987	2	waifs
wails	8	66	3148	2	wails
wains	8	69	3087	2	wains
wairs	8	64	2406	2	wairs
waist	8	61	3238	2	waist
waists	9	74	1545	2	waists
wait	7	55	5369	2	wait_
wants	8	79	3221	2	wants
warts	8	148	4040	2	warts
wasts	8	74	3367	2	wasts
wats	7	75	5588	2	wa_ts
watts	8	69	2309	2	watts
whits	11	59	2382	2	whits
wits	7	60	4487	2	_wits
writs	8	66	2438	2	writs
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.296	603685.8
2	DLD Change Limit	53800	300	1.750	30742.9
3	Display Results	300	300	0.080	3750.0
	(SQL Overall)	178691	300	2.126	84050.3