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

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

289 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
assort	6	49	1637	(None)
assert	6	49	2257	1	assert
assorts	7	33	1015	1	assorts
abort	7	61	3358	2	a_bort
absorb	10	3	800	2	absorb
adsorb	9	4	694	2	adsorb
amort	7	58	3220	2	a_mort
aport	7	54	3217	2	a_port
ascot	7	65	2251	2	asco_t
ashore	9	4	1461	2	ashore
assent	6	51	1995	2	assent
asserts	7	43	1179	2	asserts
asset	5	59	3226	2	ass_et
assist	6	3	1460	2	assist
assoil	6	8	854	2	assoil
assorted	9	5	659	2	assorted
assorter	8	6	666	2	assorter
assure	6	6	1077	2	assure
escort	8	46	1648	2	escort
missort	9	3	1465	2	missort
passport	12	4	759	2	passport
reassort	8	4	1068	2	reassort
resort	6	57	2861	2	resort
short	8	50	4052	2	_short
skort	9	49	2563	2	_skort
snort	5	48	3375	2	_snort
sort	4	62	6481	2	__sort
sport	7	59	3598	2	_sport
abbot	9	3	1845	3	abbo_t
abhor	10	4	1106	3	abhor_
abhors	11	4	1062	3	abhors
aborts	8	49	1618	3	a_borts
about	7	52	2908	3	a_bout
absent	8	40	1699	3	absent
absorbs	11	3	560	3	absorbs
absurd	9	3	590	3	absurd
abvolt	11	16	983	3	abvolt
accord	11	7	884	3	accord
accost	10	11	1226	3	accost
acorn	7	56	1662	3	a_corn
actor	7	11	1607	3	actor_
actors	8	10	1675	3	actors
adopt	8	12	1974	3	a_dopt
adore	6	57	2366	3	a_dore
adorn	6	49	1709	3	a_dorn
adroit	7	5	1878	3	adroit
adsorbs	10	4	470	3	adsorbs
advert	10	32	1577	3	advert
afford	13	4	649	3	afford
afloat	9	3	1515	3	afloat
afoot	8	4	2011	3	a_foot
afore	8	58	1860	3	a_fore
agora	6	9	1433	3	a_gora
agorot	7	4	1499	3	a_gorot
airport	9	5	1138	3	airport
airt	4	57	5778	3	a__irt
alert	5	47	4065	3	a_lert
algor	6	5	1305	3	algor_
algors	7	3	1255	3	algors
allot	5	49	3387	3	allo_t
allsorts	8	4	491	3	allsorts
almost	8	10	1443	3	almost
aloft	8	4	2343	3	a_loft
also	4	64	2344	3	also__
angora	7	11	1157	3	angora
aorta	5	59	2257	3	a__orta
apart	7	43	3067	3	a_part
arbor	7	48	1811	3	arbor_
arbors	8	47	1787	3	arbors
ardor	6	46	1786	3	ardor_
ardors	7	44	1686	3	ardors
argot	6	77	2864	3	argo_t
armor	7	51	1805	3	armor_
armors	8	50	1781	3	armors
armory	11	42	1147	3	armory
arson	5	51	1883	3	arso_n
arsons	6	39	1721	3	arsons
art	3	86	7914	3	a___rt
ascent	8	45	1965	3	ascent
ascots	8	53	1251	3	ascots
askant	10	4	1271	3	askant
asker	9	64	1878	3	asker_
askers	10	59	1540	3	askers
askoi	9	50	779	3	asko_i
askos	9	50	1177	3	asko_s
aslant	6	3	1775	3	aslant
aslope	8	3	901	3	aslope
aslosh	9	6	623	3	aslosh
aspect	10	6	1282	3	aspect
asper	7	55	2043	3	asper_
aspers	8	62	2031	3	aspers
aspire	8	6	1212	3	aspire
ass	3	78	4406	3	ass___
assai	5	7	1154	3	ass_ai
assail	6	6	1015	3	assail
assais	6	7	1196	3	assais
assault	7	4	741	3	assault
assay	8	7	1028	3	ass_ay
assays	9	7	790	3	assays
assents	7	45	1222	3	assents
asserted	9	5	790	3	asserted
asserter	8	7	756	3	asserter
assertor	8	6	571	3	assertor
asses	5	56	2928	3	ass_es
assess	6	57	1046	3	assess
assets	6	56	1766	3	assets
asshole	10	4	679	3	asshole
assign	7	3	678	3	assign
assists	7	3	847	3	assists
assize	15	3	863	3	assize
assoils	7	7	666	3	assoils
assonant	8	4	680	3	assonant
assorters	9	6	572	3	assort~~ers~~
assorting	10	3	729	3	assort~~ing~~
assume	8	9	756	3	assume
assured	8	5	837	3	assured
assurer	7	6	778	3	assurer
assures	7	6	1140	3	assures
assuror	7	5	420	3	assuror
assurors	8	9	404	3	assurors
aster	5	54	3489	3	aster_
astern	6	48	1581	3	astern
asters	6	56	3160	3	asters
astir	5	55	1709	3	astir_
astony	9	5	1052	3	astony
aswarm	11	10	791	3	aswarm
aswirl	9	3	509	3	aswirl
aswoon	9	4	701	3	aswoon
attorn	6	3	1079	3	attorn
aurora	6	4	1176	3	aurora
ausform	12	4	523	3	ausform
avert	8	60	2949	3	a_vert
avoset	9	3	1567	3	avoset
awlwort	13	5	635	3	awlwort
basset	8	52	2538	3	bass_et
bassett	9	42	1386	3	bassett
bassist	9	3	1274	3	bassist
basso	7	60	1728	3	basso__
bassoon	9	3	761	3	bassoon
bassos	8	53	1370	3	basso_s
besot	7	64	2971	3	beso_t
bistort	9	12	1652	3	bistort
bort	6	59	6096	3	__bort
brassart	10	4	750	3	brassart
carport	11	3	1603	3	carport
cassock	15	4	595	3	cassock
castor	8	44	1853	3	castor_
castors	9	49	1943	3	castors
cavort	11	3	1617	3	cavort
cohort	11	107	2026	3	cohort
consort	9	13	1990	3	consort
dehort	10	46	1810	3	dehort
deport	9	49	2239	3	deport
desert	7	27	2549	3	desert
desorb	9	52	1020	3	desorb
dessert	8	29	1645	3	dessert
disport	10	10	1595	3	disport
dissert	8	37	2069	3	dissert
distort	8	11	2033	3	distort
effort	12	3	862	3	effort
escorts	9	41	840	3	escorts
escot	7	53	2008	3	esco_t
essoin	6	3	819	3	essoin
exhort	16	4	1080	3	exhort
export	15	4	1218	3	export
exsert	13	4	1436	3	exsert
extort	13	5	1397	3	extort
fanwort	13	3	1073	3	fanwort
fort	7	64	5644	3	__fort
gasser	7	50	1777	3	gasser_
gassers	8	47	1463	3	gassers
glasswort	13	4	460	3	glasswort
gosport	10	10	1028	3	gosport
hassock	16	4	544	3	hassock
import	10	27	1376	3	import
insert	6	43	2525	3	insert
intort	6	4	1892	3	intort
lasso	5	50	1568	3	lasso__
lassoed	8	40	874	3	lassoed
lassoer	7	37	938	3	lassoer
lassoers	8	33	851	3	lassoers
lassoes	7	46	1385	3	lassoes
lassos	6	49	1381	3	lasso_s
lessor	6	40	1060	3	lessor_
lessors	7	36	1052	3	lessors
madwort	13	6	1136	3	madwort
mascot	10	40	1607	3	masco_t
missorts	10	3	832	3	missorts
missout	9	4	1266	3	missout
mort	6	67	5883	3	__mort
mysost	11	3	826	3	mysost
ort	3	94	6523	3	___ort
passant	9	8	1394	3	passant
passer	8	47	2103	3	passer_
passers	9	47	1775	3	passers
passports	13	4	424	3	passports
password	14	4	484	3	password
pastor	8	48	1748	3	pastor_
pastors	9	41	1899	3	pastors
port	6	60	5963	3	__port
presort	9	52	1953	3	presort
psst	6	61	1840	3	pss__t
ragwort	11	5	1073	3	ragwort
rapport	11	3	1122	3	rapport
rasbora	9	4	594	3	rasbora
reassert	8	3	1367	3	reassert
reassorts	9	4	562	3	reassorts
report	8	53	2601	3	report
resorb	8	49	1434	3	resorb
resorts	7	48	1719	3	resorts
retort	6	68	3114	3	retort
sabot	7	9	3177	3	sabo_t
sapor	7	51	1925	3	sapor_
sapors	8	41	1881	3	sapors
satori	6	4	1583	3	satori
savor	8	54	1794	3	savor_
savors	9	56	1610	3	savors
savory	12	43	1056	3	savory
scart	7	61	3977	3	_scart
scoot	7	57	2914	3	_scoot
score	7	55	2673	3	_score
scorn	7	58	1744	3	_scorn
scot	6	62	4260	3	_sco_t
scout	7	50	3145	3	_scout
shirt	8	45	3389	3	_shirt
shoat	8	56	3394	3	_shoat
shoot	8	42	3589	3	_shoot
shore	8	54	3264	3	_shore
shorl	8	47	2024	3	_shorl
shorn	8	57	2217	3	_shorn
shorts	9	53	2173	3	_shorts
shorty	12	43	1319	3	_shorty
shot	7	61	5024	3	_sho_t
shott	8	53	3217	3	_shott
shout	8	54	3316	3	_shout
skirt	9	56	2466	3	_skirt
skorts	10	42	1129	3	_skorts
slot	4	60	4982	3	_slo_t
smart	7	58	3409	3	_smart
smolt	7	48	2416	3	_smolt
snoot	5	50	3013	3	_snoot
snore	5	54	2495	3	_snore
snorts	6	41	1649	3	_snorts
snot	4	47	4544	3	_sno_t
snout	5	45	3063	3	_snout
soft	7	69	4282	3	__soft
soot	4	57	6105	3	__soot
sora	4	57	4691	3	__sora
sorb	6	83	3304	3	__sorb
sord	5	62	3720	3	__sord
sore	4	70	5953	3	__sore
sori	4	60	3983	3	__sori
sorn	4	66	4106	3	__sorn
sorta	5	71	2541	3	__sorta
sorts	5	45	3666	3	__sorts
sot	3	103	8429	3	__so_t
spirt	7	50	3295	3	_spirt
spore	7	54	2859	3	_spore
sports	8	46	1918	3	_sports
sporty	11	51	1249	3	_sporty
spot	6	55	4068	3	_spo_t
spout	7	50	2963	3	_spout
spurt	7	72	2798	3	_spurt
start	5	56	4231	3	_start
stoat	5	71	3595	3	_stoat
stopt	7	65	2835	3	_stopt
store	5	63	3381	3	_store
stork	9	68	1969	3	_stork
storm	7	65	2037	3	_storm
story	8	67	2303	3	_story
stot	4	63	4732	3	_sto_t
stott	5	69	2978	3	_stott
stout	5	74	3405	3	_stout
sturt	5	60	2896	3	_sturt
swart	8	62	3464	3	_swart
sword	9	52	1411	3	_sword
swore	8	49	2081	3	_swore
sworn	8	61	1530	3	_sworn
swot	7	51	3465	3	_swo_t
tasset	6	59	2531	3	tass_et
tort	4	69	6746	3	__tort
tussor	6	37	823	3	tussor_
tussore	7	31	728	3	tussore
tussors	7	38	876	3	tussors
visor	8	25	1283	3	visor_
visors	9	29	1222	3	visors
washout	13	4	1013	3	washout
whort	11	46	2369	3	_whort
wort	7	66	5475	3	__wort

Search took 7 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.233	766914.2
2	DLD Change Limit	112716	289	6.563	17174.5
3	Display Results	289	289	0.093	3107.5
	(SQL Overall)	178691	289	6.889	25938.6