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

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

368 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
advert	10	32	1578	(None)
advect	12	30	912	1	advect
advent	10	26	1375	1	advent
adverb	12	26	541	1	adverb
adverts	11	30	851	1	adverts
avert	8	60	2949	1	a_vert
adder	7	54	1959	2	adder_
adders	8	43	1570	2	adders
adept	8	12	1964	2	ad_ept
adhere	10	3	1033	2	adhere
advects	13	27	601	2	advects
advents	11	30	947	2	advents
adverbs	13	25	427	2	adverbs
adverse	11	4	595	2	adverse
adverted	13	3	610	2	adverted
aiver	8	57	2516	2	aiver_
aivers	9	48	2232	2	aivers
alert	5	47	4065	2	a_lert
assert	6	49	2258	2	assert
aver	7	59	3188	2	a_ver_
avers	8	51	2731	2	a_vers
averts	9	57	1524	2	a_verts
covert	11	49	2550	2	covert
divert	10	39	2281	2	divert
evert	8	49	2951	2	_evert
invert	9	41	2008	2	invert
obvert	11	4	1299	2	obvert
overt	8	56	3072	2	_overt
revert	9	35	2911	2	revert
vert	7	72	4937	2	__vert
abet	6	105	4794	3	a_be_t
abject	17	13	770	3	abject
abler	7	56	2431	3	abler_
ablest	8	47	2183	3	ablest
abort	7	61	3358	3	a_bort
absent	8	40	1699	3	absent
abvolt	11	16	983	3	abvolt
accent	10	51	1626	3	accent
accept	12	32	1062	3	accept
acerb	9	3	1276	3	a_cerb
adapt	8	12	1855	3	ad_apt
added	8	49	1843	3	adde_d
addend	9	45	845	3	addend
addict	10	7	1120	3	addict
addrest	9	5	863	3	addrest
adduct	10	8	737	3	adduct
adeem	8	3	1180	3	ad_eem
adeems	9	4	633	3	adeems
adepts	9	11	710	3	ad_epts
adhered	12	3	923	3	adhered
adherent	12	4	778	3	adherent
adherer	11	3	757	3	adherer
adheres	11	3	1016	3	adheres
adieu	6	4	1742	3	adie_u
adieus	7	3	963	3	adieus
adieux	14	4	428	3	adieux
adit	5	64	4365	3	ad__it
adjure	14	3	584	3	adjure
adjust	14	4	718	3	adjust
admen	8	45	1618	3	adme_n
admire	9	4	993	3	admire
admit	8	3	1949	3	ad_mit
admixt	16	3	733	3	admixt
adnexa	14	3	367	3	adnexa
adopt	8	12	1974	3	ad_opt
adore	6	57	2367	3	ad_ore
adored	8	47	1424	3	adored
adorer	7	47	1345	3	adorer
adorers	8	44	1173	3	adorers
adores	7	44	2072	3	adores
adorn	6	49	1709	3	ad_orn
adrift	10	3	1311	3	adrift
adroit	7	5	1879	3	adroit
adsorb	9	4	695	3	adsorb
adult	6	35	2065	3	ad_ult
adust	6	41	1745	3	ad_ust
advected	15	3	453	3	advected
adversity	16	4	381	3	adversity
advertent	13	5	659	3	adver~~ten~~t
adverting	14	3	722	3	advert~~ing~~
advertise	13	4	610	3	advert~~ise~~
advertize	22	4	538	3	advert~~ize~~
advice	12	10	788	3	advice
advise	10	13	922	3	advise
adviser	11	13	578	3	adviser_
advisers	12	13	500	3	advisers
adze	14	128	2057	3	adze__
adzed	16	60	1254	3	adze_d
adzes	15	59	1380	3	adze_s
aero	4	54	3534	3	a__ero
aery	7	72	3168	3	a__ery
affect	14	4	890	3	affect
afreet	9	3	1515	3	afreet
after	8	57	1979	3	after_
afters	9	47	1707	3	afters
agent	6	58	2964	3	a_gent
ager	5	59	3584	3	a_ger_
agers	6	50	2785	3	a_gers
agger	7	64	2089	3	agger_
aggers	8	58	1779	3	aggers
aglet	6	55	3414	3	agle_t
aider	6	54	3113	3	aider_
aiders	7	45	2463	3	aiders
aigret	7	37	2002	3	aigret
aimer	7	59	2682	3	aimer_
aimers	8	46	2191	3	aimers
airer	5	49	2789	3	airer_
airers	6	49	2231	3	airers
airest	6	38	2526	3	airest
airt	4	57	5778	3	a__irt
albeit	8	3	1434	3	albeit
alder	6	54	2191	3	alder_
alders	7	42	1842	3	alders
alerts	6	44	1822	3	a_lerts
alter	5	48	2850	3	alter_
alters	6	49	2422	3	alters
amber	9	45	2321	3	amber_
ambers	10	45	1958	3	ambers
ambery	13	38	1113	3	ambery
ambivert	15	4	561	3	ambivert
ameer	7	56	1898	3	ameer_
ameers	8	40	1557	3	ameers
ament	7	60	3654	3	a_ment
amort	7	58	3220	3	a_mort
ampere	10	5	1441	3	ampere
anent	5	49	3184	3	a_nent
anger	6	62	2587	3	anger_
angers	7	52	2254	3	angers
antevert	11	4	899	3	antevert
apart	7	43	3067	3	a_part
aper	6	63	3623	3	a_per_
apers	7	66	2913	3	a_pers
apery	10	65	1790	3	a_pery
aport	7	54	3217	3	a_port
apter	7	61	2020	3	apter_
aptest	8	29	1751	3	aptest
ardent	7	30	2261	3	ardent
argent	7	40	2366	3	argent
armer	7	69	2444	3	armer_
armers	8	55	2027	3	armers
armet	7	67	3945	3	arme_t
arpent	8	48	2209	3	arpent
arrest	6	37	2263	3	arrest
art	3	86	7914	3	a___rt
artery	9	9	1145	3	artery
ascent	8	45	1965	3	ascent
asker	9	64	1878	3	asker_
askers	10	59	1540	3	askers
aspect	10	6	1282	3	aspect
asper	7	55	2043	3	asper_
aspers	8	62	2031	3	aspers
assent	6	51	1995	3	assent
asserts	7	43	1179	3	asserts
asset	5	59	3226	3	asse_t
assort	6	49	1638	3	assort
aster	5	54	3489	3	aster_
astern	6	48	1581	3	astern
asters	6	56	3160	3	asters
attent	6	28	1832	3	attent
attest	6	26	1861	3	attest
audient	8	3	1230	3	audient
auger	6	49	2247	3	auger_
augers	7	38	1870	3	augers
avant	8	62	2466	3	a_vant
avast	8	55	1936	3	a_vast
ave	6	77	4870	3	a_ve__
avens	8	64	1933	3	a_vens
averse	9	58	1118	3	a_verse
averted	11	22	1161	3	a_verted
averter	10	24	1055	3	a_verter
aves	7	61	4260	3	a_ve_s
badder	10	38	1751	3	badder_
baddest	11	26	1114	3	baddest
badger	10	54	1508	3	badger_
badgers	11	48	1265	3	badgers
cadaver	13	3	579	3	cadaver_
cadavers	14	3	589	3	cadavers
cadent	9	41	2036	3	cad_ent
cadet	8	53	3934	3	cad_e_t
cadger	10	50	1391	3	cadger_
cadgers	11	47	1200	3	cadgers
carver	11	44	2015	3	carver_
carvers	12	48	1754	3	carvers
caveat	11	4	1772	3	caveat
caver	10	56	2906	3	caver_
cavern	11	53	1245	3	cavern
cavers	11	50	2684	3	cavers
cavort	11	3	1617	3	cavort
chert	10	52	3210	3	_chert
civet	10	58	2873	3	cive_t
convert	12	37	2147	3	convert
cover	10	54	3077	3	cover_
covers	11	46	2796	3	covers
coverts	12	48	1381	3	coverts
covet	10	56	3894	3	cove_t
culvert	12	30	1177	3	culvert
darer	6	52	3079	3	darer_
darers	7	59	2187	3	darers
dart	5	58	5787	3	_d_art
dater	6	53	3231	3	dater_
daters	7	48	2737	3	daters
daven	9	49	1647	3	dave_n
davens	10	46	1291	3	davens
davit	9	34	2459	3	dav_it
debt	7	71	3902	3	_d_ebt
deer	5	67	3902	3	_deer_
deers	6	49	3052	3	_deers
deet	5	73	5658	3	_d_eet
deft	8	55	4022	3	_d_eft
delt	5	78	5527	3	_d_elt
dent	5	71	5841	3	_d_ent
derat	6	50	4408	3	_d_erat
dere	5	68	4590	3	_d_ere
derm	7	60	3189	3	_d_erm
desert	7	27	2549	3	desert
devest	10	44	1870	3	devest
diet	5	73	5753	3	_die_t
dirt	5	55	5038	3	_d_irt
diver	9	48	2780	3	diver_
divers	10	50	2496	3	divers
diverts	11	44	1203	3	diverts
divest	10	68	2007	3	divest
doer	5	77	3470	3	_doer_
doers	6	52	2571	3	_doers
doest	6	58	2952	3	_doest
drest	6	55	3034	3	_drest
duet	5	64	4626	3	_due_t
duvet	9	3	2187	3	duve_t
dwelt	9	43	1652	3	_dwelt
dyer	8	55	2211	3	_dyer_
dyers	9	66	1713	3	_dyers
edger	7	52	1595	3	edger_
edgers	8	44	1392	3	edgers
elver	8	52	1624	3	elver_
elvers	9	38	1498	3	elvers
event	8	59	2444	3	_event
ever	7	70	2769	3	_ever_
everts	9	45	1489	3	_everts
every	11	52	1545	3	_every
exert	12	46	2414	3	_exert
expert	15	5	1535	3	expert
exsert	13	4	1436	3	exsert
fader	9	44	2151	3	fad_er_
faders	10	51	1746	3	fad_ers
fever	11	56	1795	3	fever_
fevers	12	54	1489	3	fevers
fiver	11	60	2494	3	fiver_
fivers	12	44	2092	3	fivers
gadder	9	37	1471	3	gadder_
gadders	10	36	1150	3	gadders
gadget	9	36	1618	3	gadge_t
giver	9	49	2120	3	giver_
givers	10	48	1771	3	givers
govern	10	3	682	3	govern
haddest	12	27	1199	3	haddest
halbert	12	3	1450	3	halbert
halvers	13	33	1142	3	halvers
harvest	13	21	1275	3	harvest
haver	11	51	2446	3	haver_
havers	12	47	2148	3	havers
hover	11	55	2413	3	hover_
hovers	12	43	2025	3	hovers
idler	6	50	1566	3	idler_
idlers	7	40	1281	3	idlers
idlest	7	40	1486	3	idlest
inert	5	32	3437	3	_inert
insert	6	43	2525	3	insert
invent	9	33	1636	3	invent
inverts	10	32	1195	3	inverts
invest	9	30	1484	3	invest
jiver	15	51	1905	3	jiver_
jivers	16	45	1564	3	jivers
ladder	8	46	1762	3	ladder_
ladders	9	41	1517	3	ladders
lader	6	56	3372	3	lad_er_
laders	7	49	2776	3	lad_ers
ladler	7	43	1493	3	ladler_
ladlers	8	46	1357	3	ladlers
lambert	11	36	1711	3	lambert
laver	8	50	3179	3	laver_
lavers	9	45	2636	3	lavers
lever	8	51	2516	3	lever_
leveret	10	30	1400	3	leveret
levers	9	46	2132	3	levers
liver	8	51	3296	3	liver_
livers	9	49	2782	3	livers
livery	12	49	1090	3	livery
livest	9	53	1573	3	livest
lover	8	55	2645	3	lover_
lovers	9	42	2343	3	lovers
madder	10	35	1559	3	madder_
madders	11	35	1321	3	madders
maddest	11	23	1121	3	maddest
madwort	13	6	1136	3	madwort
mover	10	42	2086	3	mover_
movers	11	51	1719	3	movers
naiver	9	43	1135	3	naiver_
naivest	10	30	947	3	naivest
never	8	62	1864	3	never_
obverts	12	3	540	3	obverts
odder	7	45	1539	3	odder_
oddest	8	17	1086	3	oddest
over	7	72	2734	3	_over_
overs	8	52	2479	3	_overs
padder	10	34	1549	3	padder_
padders	11	33	1287	3	padders
paver	10	42	2583	3	paver_
pavers	11	50	2182	3	pavers
pert	6	67	5932	3	__pert
pervert	12	3	1558	3	pervert
poverty	15	3	643	3	poverty
raver	8	56	3149	3	raver_
ravers	9	46	2818	3	ravers
reverb	11	39	1257	3	reverb
revere	9	46	2125	3	revere
revers	9	45	2963	3	revers
reverts	10	47	1504	3	reverts
revery	12	40	1421	3	revery
revest	9	46	2360	3	revest
revet	8	49	3884	3	reve_t
river	8	57	3169	3	river_
rivers	9	46	2654	3	rivers
rivet	8	56	3636	3	rive_t
rover	8	55	2737	3	rover_
rovers	9	54	2352	3	rovers
sadder	8	29	1697	3	sadder_
saddest	9	24	1238	3	saddest
salver	9	46	1775	3	salver_
salvers	10	39	1600	3	salvers
saver	8	48	3125	3	saver_
savers	9	38	2592	3	savers
sever	8	54	2605	3	sever_
severe	9	40	1608	3	severe
severs	9	41	2112	3	severs
sievert	10	6	1329	3	sievert
siver	8	57	2861	3	siver_
sivers	9	53	2415	3	sivers
subvert	12	3	1289	3	subvert
tavern	9	42	893	3	tavern
udder	7	63	1428	3	udder_
udders	8	39	1129	3	udders
unvext	16	5	817	3	unvext
vent	7	60	4905	3	__vent
vera	7	68	2884	3	__vera
verb	9	62	2487	3	__verb
verst	8	44	2937	3	__verst
verts	8	57	2473	3	__verts
vertu	8	50	1761	3	__vertu
very	10	80	2564	3	__very
vest	7	57	4360	3	__vest
vet	6	59	5852	3	__ve_t
vext	14	69	2776	3	__vext
vivers	12	47	1736	3	vivers
wadder	11	42	1548	3	wadder_
wadders	12	38	1244	3	wadders
wader	9	53	2536	3	wad_er_
waders	10	91	2064	3	wad_ers
wadset	10	3	1430	3	wadse_t
waiver	12	42	1271	3	waiver_
waivers	13	34	1005	3	waivers
waver	11	50	2570	3	waver_
wavers	12	50	2247	3	wavers
wavery	15	46	1005	3	wavery
wert	7	97	4982	3	__wert
wiver	11	59	2451	3	wiver_
wivern	12	40	928	3	wivern
wivers	12	53	2080	3	wivers
wyvern	15	36	392	3	wyvern

Search took 10 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.720	248181.9
2	DLD Change Limit	112716	368	8.343	13510.2
3	Display Results	368	368	0.123	2991.9
	(SQL Overall)	178691	368	9.186	19452.5