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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

330 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
instar	6	3	1001	(None)
instal	6	7	1219	1	instal
instars	7	4	1113	1	instars
costar	8	55	1861	2	costar
inseam	8	32	999	2	inseam
insnare	7	4	824	2	insnare
insofar	10	4	354	2	insofar
inspan	8	3	751	2	inspan
install	7	7	936	2	install
instals	7	6	1171	2	instals
instant	7	8	1535	2	instant
instate	7	16	1648	2	instate
instead	8	3	620	2	instead
instep	8	3	819	2	instep
instil	6	11	1138	2	instil
insular	7	13	870	2	insular
inter	5	50	2849	2	in_ter
invar	8	3	951	2	in_var
minster	9	39	1432	2	minster
qintar	15	35	914	2	qin_tar
star	4	80	3776	2	__star
altar	5	55	2064	3	_altar
anear	5	54	2032	3	an_ear
ansa	4	59	2777	3	ans_a_
ansae	5	57	2097	3	ans_ae
ansate	6	45	1786	3	ansate
answer	9	3	689	3	answer
anta	4	68	3958	3	an_ta_
antae	5	68	2829	3	an_tae
antas	5	54	3203	3	an_tas
antiar	6	3	1717	3	antiar
antra	5	65	2192	3	an_tra
aster	5	54	3489	3	_aster
astir	5	55	1709	3	_astir
attar	5	65	1669	3	_attar
avatar	9	3	752	3	avatar
bastard	10	30	1242	3	bastard
baster	8	53	3359	3	baster
bestir	8	3	1116	3	bestir
bister	8	49	2276	3	bister
busbar	10	3	845	3	busbar
bustard	10	38	972	3	bustard
buster	8	47	2649	3	buster
caster	8	52	3257	3	caster
castor	8	44	1853	3	castor
cesta	7	54	1948	3	cesta_
cestas	8	50	1854	3	cestas
costa	7	55	2373	3	costa_
costae	8	53	1968	3	costae
costal	8	54	1951	3	costal
costard	10	41	1335	3	costard
costars	9	42	1801	3	costars
coster	8	43	3129	3	coster
cottar	8	46	1381	3	cottar
custard	10	38	997	3	custard
dastard	9	27	970	3	dastard
daystar	11	4	344	3	daystar
diaster	8	28	1331	3	diaster
diester	8	30	1368	3	diester
dinar	6	63	1989	3	din__ar
disbar	9	3	851	3	disbar
distal	7	36	1577	3	distal
duster	7	49	1972	3	duster
easter	6	50	2798	3	easter
endear	7	41	1001	3	endear
ensnare	7	6	712	3	ensnare
ensnarl	7	8	491	3	ensnarl
enter	5	47	2638	3	en_ter
escar	7	40	1199	3	_escar
eskar	9	45	745	3	_eskar
ester	5	47	2771	3	_ester
faster	9	46	2577	3	faster
festal	9	42	1356	3	festal
fester	9	47	2351	3	fester
fibster	12	14	653	3	fibster
fiesta	9	3	812	3	fiesta_
fiestas	10	3	843	3	fiestas
foster	9	43	2222	3	foster
gaster	7	50	2735	3	gaster
gnar	5	60	2138	3	gn__ar
guitar	7	11	744	3	guitar
hinter	9	40	2130	3	hin_ter
hipster	12	28	878	3	hipster
hosta	8	59	1783	3	hosta_
hostas	9	45	1583	3	hostas
hussar	9	31	728	3	hussar
igniter	8	14	767	3	igniter
ignitor	8	12	526	3	ignitor
inaner	6	22	1354	3	inaner
inarm	7	3	1442	3	in__arm
inboard	10	3	706	3	inboard
incher	11	41	1403	3	incher
inciter	9	31	1377	3	inciter
incur	7	22	1225	3	in_cur
inditer	8	35	1423	3	inditer
indoor	7	3	840	3	indoor
infare	9	3	1308	3	in_fare
infer	8	42	1503	3	in_fer
infester	11	23	943	3	infester
infra	8	3	864	3	infra_
ingate	7	30	1824	3	ingate
ingesta	8	35	786	3	ingesta_
inia	4	50	2470	3	in_ia_
initial	7	3	1188	3	initial
inker	9	44	2109	3	in_ker
inkier	10	40	1378	3	inkier
inkstand	13	4	380	3	inkstand
inlay	8	52	1432	3	in_lay
inlier	6	36	1536	3	inlier
inmate	8	29	1736	3	inmate
innate	6	39	1731	3	innate
inner	5	49	2063	3	in_ner
inpour	8	3	706	3	inpour
inroad	7	3	793	3	inroad
ins	3	59	4560	3	ins___
insane	6	3	1489	3	insane
insaner	7	3	1044	3	insaner
inscape	11	3	802	3	inscape
inseams	9	30	790	3	inseams
insect	8	39	1658	3	insect
insectan	10	4	539	3	insectan
insectary	14	4	421	3	insectary
insert	6	43	2525	3	insert
inserter	8	23	1213	3	inserter
inset	5	44	3086	3	ins_et
insets	6	40	1613	3	insets
insetter	8	21	859	3	insetter
inshore	10	3	872	3	inshore
inside	7	6	1345	3	inside
insider	8	4	973	3	insider
insist	6	3	1451	3	insist
insister	8	8	878	3	insister
insnared	9	5	612	3	insnared
insnarer	8	6	530	3	insnarer
insnares	8	5	808	3	insnares
insole	6	35	1586	3	insole
insoul	6	3	846	3	insoul
inspans	9	3	780	3	inspans
inspire	9	3	825	3	inspire
instable	10	3	1320	3	instable
installer	9	4	501	3	insta~~lle~~r
installs	8	5	892	3	installs
instance	10	4	988	3	instance
instancy	13	4	657	3	instancy
instanter	9	4	624	3	insta~~nte~~r
instants	8	9	1015	3	instants
instarred	10	4	396	3	instarred
instated	9	16	1334	3	instated
instates	8	16	1583	3	instates
insteps	9	3	657	3	insteps
instill	7	8	906	3	instill
instils	7	8	1145	3	instils
insulars	8	13	732	3	insulars
insult	6	28	1367	3	insult
insulter	8	3	688	3	insulter
insure	6	34	1660	3	insure
insurer	7	33	1280	3	insurer
intact	8	3	1466	3	in_tact
intake	10	5	1086	3	in_take
intern	6	40	1654	3	in_tern
inters	6	43	2805	3	in_ters
inti	4	66	2608	3	in_t_i
intis	5	51	2164	3	in_tis
into	4	50	2615	3	in_t_o
intort	6	4	1892	3	in_tort
intro	5	49	1585	3	in_tro
inturn	6	34	1156	3	in_turn
invars	9	3	1000	3	in_vars
investor	11	24	741	3	investor
invital	10	4	695	3	invital
inviter	10	41	1231	3	inviter
inward	10	3	1033	3	in_ward
inwrap	11	11	590	3	inwrap
iota	4	51	2783	3	i_ota_
iotas	5	48	2111	3	i_otas
irater	6	52	1835	3	irater
isba	6	13	1088	3	i_sba_
isbas	7	10	1040	3	i_sbas
isobar	8	3	614	3	isobar
issuer	6	4	662	3	issuer
istle	5	22	1471	3	i_stle
izar	13	66	1601	3	i__zar
jester	13	43	1915	3	jester
juster	13	46	1701	3	juster
kantar	10	3	1115	3	kantar
kiester	11	32	997	3	kiester
kinsman	13	3	596	3	kinsman
knar	8	58	1872	3	kn__ar
lascar	8	6	857	3	lascar
laster	6	48	3063	3	laster
linear	6	51	1334	3	lin_ear
linter	6	46	2534	3	lin_ter
lister	6	45	2725	3	lister
luster	6	40	2367	3	luster
lustra	6	35	889	3	lustra
mainstay	13	4	403	3	mainstay
master	8	48	3134	3	master
minibar	11	10	613	3	minibar
minicar	11	10	932	3	minicar
minister	10	4	1036	3	minister
minsters	10	38	1392	3	minsters
minter	8	44	2510	3	min_ter
minuter	9	35	1041	3	minuter
misstart	10	4	1004	3	misstart
mister	8	47	2856	3	mister
monster	9	32	1460	3	monster
mortar	8	38	1204	3	mortar
munster	9	37	1052	3	munster
mustard	10	35	953	3	mustard
muster	8	47	2452	3	muster
natal	5	39	2149	3	_natal
navar	8	39	1273	3	_navar
near	4	52	3650	3	_n_ear
nectar	8	3	885	3	nectar
nester	6	41	2418	3	nester
nestor	6	37	1342	3	nestor
niter	5	50	2897	3	_niter
nota	4	68	3077	3	_nota_
notal	5	52	2135	3	_notal
notary	9	23	1071	3	_notary
noter	5	50	2564	3	_noter
onstage	8	3	836	3	onstage
osar	4	68	2095	3	_os_ar
ottar	5	43	1399	3	_ottar
ouster	6	42	2373	3	ouster
oyster	9	41	1170	3	oyster
pasta	7	66	2453	3	pasta_
pastas	8	54	2287	3	pastas
paster	8	57	3437	3	paster
pastor	8	48	1748	3	pastor
penster	9	28	1195	3	penster
pester	8	48	2759	3	pester
piaster	9	30	1288	3	piaster
pinaster	10	3	711	3	pinaster
pinata	8	38	1722	3	pinata_
pinatas	9	37	1150	3	pinatas
pineta	8	58	1556	3	pineta_
pinta	7	57	2705	3	pin_ta_
pintas	8	50	2139	3	pin_tas
postal	8	43	1753	3	postal
poster	8	41	2917	3	poster
postwar	12	3	690	3	postwar
punster	9	29	1110	3	punster
qindar	16	31	717	3	qin_dar
qintars	16	26	857	3	qin_tars
quintar	16	47	860	3	quin_tar
raster	6	47	3144	3	raster
restart	7	3	2003	3	restart
rester	6	38	3243	3	rester
ringtaw	11	5	436	3	ringtaw
rinser	6	43	1721	3	rins_er
ristra	6	3	1071	3	ristra
roster	6	43	2908	3	roster
rostra	6	3	1093	3	rostra
sansar	6	36	1339	3	sans_ar
scar	6	64	3420	3	__scar
sear	4	73	5384	3	__sear
siesta	6	3	950	3	siesta_
siestas	7	3	881	3	siestas
simitar	9	3	673	3	simitar
sinister	8	3	858	3	sinister
sinter	6	36	2592	3	sin_ter
sister	6	44	2158	3	sister
sistra	6	3	933	3	sistra
sitar	5	48	2054	3	_sitar
soar	4	68	3867	3	__soar
spar	6	54	3330	3	__spar
spinster	10	3	668	3	spinster
stab	6	73	2993	3	__stab
stag	5	73	3200	3	__stag
stair	5	47	1994	3	__stair
stare	5	44	4026	3	__stare
stark	9	54	2562	3	__stark
stars	5	58	3657	3	__stars
start	5	56	4231	3	__start
stat	4	73	5269	3	__stat
staw	7	86	2769	3	__staw
stay	7	83	3372	3	__stay
stir	4	57	2325	3	__stir
tar	3	75	7069	3	___tar
tartar	6	32	1475	3	tartar
taster	6	49	3057	3	taster
tatar	5	61	2206	3	_tatar
testa	5	48	2204	3	testa_
testae	6	42	1625	3	testae
tester	6	42	2715	3	tester
tinter	6	39	2364	3	tin_ter
tipster	9	29	905	3	tipster
tsar	4	78	1980	3	_ts_ar
tussar	6	36	954	3	tussar
ulster	6	37	1210	3	ulster
unbar	7	19	1361	3	un_bar
unbear	8	8	916	3	unbear
unitard	8	3	800	3	unitard
unitary	10	3	861	3	unitary
uniter	6	46	1914	3	uniter
unsay	8	32	1284	3	uns_ay
unseal	6	33	1547	3	unseal
unseam	8	33	1314	3	unseam
unseat	6	42	2102	3	unseat
unsharp	12	3	554	3	unsharp
unsmart	9	3	960	3	unsmart
unsnag	7	3	639	3	unsnag
unsnap	8	3	620	3	unsnap
unsnarl	7	10	715	3	unsnarl
unstack	13	3	737	3	unstack
unstate	7	19	1621	3	unstate
unstep	8	3	922	3	unstep
unstop	8	3	747	3	unstop
unstrap	9	4	678	3	unstrap
unswear	10	3	500	3	unswear
upsoar	8	10	568	3	upsoar
upstair	9	4	398	3	upstair
upstare	9	15	868	3	upstare
upstart	9	15	975	3	upstart
upstir	8	3	538	3	upstir
vaster	9	45	2102	3	vaster
vesta	8	66	1830	3	vesta_
vestal	9	46	1557	3	vestal
vestas	9	59	1668	3	vestas
vinegar	11	3	461	3	vinegar
vista	8	54	1660	3	vista_
vistas	9	45	1327	3	vistas
waster	9	52	2894	3	waster
wester	9	42	2289	3	wester
winter	9	42	2280	3	win_ter
xyster	16	36	680	3	xyster
yester	9	34	1798	3	yester
zester	15	36	1779	3	zester
zoster	15	37	1585	3	zoster

Search took 6 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	112716	0.373	479064.3
2	DLD Change Limit	112716	330	5.030	22408.7
3	Display Results	330	330	0.110	3000.0
	(SQL Overall)	178691	330	5.513	32412.7