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

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

333 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
aubade	9	3	922	(None)
aubades	10	3	874	1	aubades
abase	7	60	2348	2	a_base
abate	7	66	2784	2	a_bate
abide	8	62	2370	2	a_bide
abode	8	55	1881	2	a_bode
abrade	9	3	1305	2	abrade
alcade	9	11	1151	2	alcade
ambage	11	5	1059	2	ambage
arcade	9	10	1364	2	arcade
audad	7	15	1138	2	audad_
audads	8	16	710	2	audads
aurae	5	41	2811	2	aura_e
aurate	6	44	2647	2	aurate
bade	7	51	4088	2	__bade
bubale	10	40	1462	2	bubale
cubage	11	7	827	2	cubage
gambade	13	3	638	2	gambade
rubace	10	3	1017	2	rubace
tubae	7	47	1664	2	tuba_e
tubate	8	28	1317	2	tubate
aba	5	128	5095	3	a_ba__
abaca	9	51	1804	3	a_baca
abaci	9	47	1884	3	a_baci
aback	13	48	1617	3	a_back
abaft	10	3	1806	3	a_baft
abaka	11	43	1382	3	a_baka
abamp	11	3	1060	3	a_bamp
abas	6	86	4208	3	a_ba_s
abased	9	65	1499	3	a_based
abaser	8	64	1434	3	a_baser
abases	8	57	2077	3	a_bases
abash	10	60	1651	3	a_bash
abated	9	59	1845	3	a_bated
abater	8	55	1812	3	a_bater
abates	8	58	2503	3	a_bates
abaya	10	44	1317	3	a_baya
abba	8	105	2264	3	abba__
abbacy	15	3	662	3	abbacy
abbas	9	59	1864	3	abba_s
abbe	8	76	2718	3	a_b_be
abed	7	97	3413	3	a_bed_
abele	7	63	2325	3	a_bele
abided	10	53	1331	3	a_bided
abider	9	53	1446	3	a_bider
abides	9	47	1989	3	a_bides
ablate	8	22	1921	3	ablate
ablaze	17	23	983	3	ablaze
able	6	63	4053	3	a_b_le
abled	8	69	2683	3	a_bled
aboded	10	49	1251	3	a_boded
abodes	9	44	1751	3	a_bodes
above	10	54	1432	3	a_bove
abraded	11	3	864	3	abraded
abrader	10	3	864	3	abrader
abrades	10	3	1207	3	abrades
abubble	10	4	452	3	abubble
abuse	7	71	1956	3	a_buse
abused	9	56	1427	3	abused
abye	9	79	2100	3	a_b_ye
accede	11	3	829	3	accede
acnode	9	3	819	3	acnode
acuate	8	3	1563	3	acuate
adage	7	4	1405	3	a_dage
adnate	7	29	1348	3	adnate
adulate	8	3	1323	3	adulate
aerate	6	48	3055	3	aerate
aflame	11	3	872	3	aflame
agape	8	56	1484	3	a_gape
agate	6	65	2514	3	a_gate
agave	9	53	1403	3	a_gave
agaze	15	61	1366	3	a_gaze
aggada	9	5	520	3	aggada
aggrade	10	3	563	3	aggrade
aglare	7	3	1242	3	aglare
agnate	7	33	1487	3	agnate
agrafe	10	3	809	3	agrafe
ahead	9	68	1705	3	ahead_
aide	5	60	4499	3	a__ide
alae	4	56	4375	3	a_la_e
alane	5	61	3561	3	a_lane
alate	5	53	4032	3	a_late
alba	6	83	2833	3	alba__
albas	7	59	2539	3	alba_s
albata	8	3	933	3	albata
albedo	9	5	612	3	albedo
albite	8	3	1330	3	albite
alcades	10	10	1147	3	alcades
alcaide	10	8	845	3	alcaide
alcalde	10	10	495	3	alcalde
alcayde	13	10	372	3	alcayde
algae	6	53	1962	3	alga_e
alidade	9	3	699	3	alidade
alkane	10	43	1332	3	alkane
allude	7	39	1090	3	allude
almude	9	39	993	3	almude
alulae	6	3	1274	3	alula_e
amaze	16	60	1660	3	a_maze
ambages	12	6	962	3	ambages
ambari	10	30	1215	3	ambari
ambary	13	40	1053	3	ambary
amble	9	59	2463	3	amb_le
ambled	11	51	1635	3	ambled
ambsace	13	5	596	3	ambsace
amebae	10	4	963	3	ameba_e
amide	8	61	2847	3	a_mide
anadem	9	3	918	3	a_nadem
anlace	8	25	1392	3	anlace
anlage	7	25	1422	3	anlage
anode	6	50	2103	3	a_node
ansae	5	57	2097	3	ansa_e
ansate	6	45	1786	3	ansate
antae	5	68	2829	3	anta_e
aoudad	8	3	503	3	aoudad_
aoudads	9	7	375	3	aoudads
apace	9	47	1838	3	a_pace
aquacade	20	4	334	3	aquacade
aquae	14	22	1271	3	aqua_e
arable	8	18	2100	3	arable
arame	7	50	2662	3	a_rame
arbute	8	3	1104	3	arbute
arcaded	11	7	897	3	arcaded
arcades	10	11	1319	3	arcades
arcane	8	12	1674	3	arcane
areae	5	52	2974	3	area_e
armada	9	3	878	3	armada
aside	6	51	2208	3	a_side
auberge	10	4	563	3	auberge
auburn	8	3	621	3	auburn
audile	7	33	1530	3	audile
augite	7	3	1261	3	augite
auld	5	41	2536	3	au_ld_
aulder	7	5	1145	3	au_lder
auntie	6	43	1770	3	auntie
aura	4	58	3625	3	aura__
aural	5	44	2896	3	aura_l
aurar	5	44	2025	3	aura_r
auras	5	59	3255	3	aura_s
aurated	8	38	1779	3	aurated
aureate	7	25	1528	3	aureate
autocade	11	4	668	3	autocade
autoed	7	7	1282	3	autoed
aviate	9	3	1520	3	aviate
awake	12	50	1478	3	a_wake
aware	8	64	2002	3	a_ware
azide	15	56	1716	3	a_zide
babe	8	68	3581	3	__babe
bad	6	77	6315	3	__bad_
badge	9	48	1968	3	__badge
bads	7	70	4886	3	__bads
bake	10	56	3751	3	__bake
bale	6	63	5384	3	__bale
ballade	10	40	1256	3	ballade
bane	6	52	5042	3	__bane
barbate	11	3	1454	3	barbate
barde	8	53	3077	3	__barde
bare	6	54	6052	3	__bare
base	6	48	4702	3	__base
bate	6	65	5242	3	__bate
baubee	10	32	1599	3	baub_ee
bauble	10	38	1321	3	baub_le
bide	7	60	4147	3	__bide
blade	8	59	2333	3	_blade
bode	7	58	3875	3	__bode
bubal	9	42	1821	3	buba_l
bubales	11	35	1334	3	bubales
bubals	10	35	1384	3	bubals
bubble	9	40	1659	3	bubble
buboed	11	30	1000	3	buboed
bugbane	12	5	586	3	bugbane
butane	8	3	1365	3	butane
cabbage	14	4	698	3	cabbage
cade	7	64	4391	3	__cade
carbide	12	61	1249	3	carbide
cascade	12	11	860	3	cascade
caudad	10	15	767	3	caudad_
caudate	10	3	1135	3	caudate
clade	8	58	2101	3	_clade
comade	11	44	1532	3	comade
couvade	13	3	506	3	couvade
crusade	10	3	605	3	crusade
cubages	12	3	792	3	cubages
cube	8	58	3021	3	cub__e
cubed	10	55	1970	3	cubed_
curare	8	49	1695	3	curare
curate	8	52	2624	3	curate
daube	8	50	1530	3	daub__e
daubed	10	46	1178	3	daubed_
debase	9	40	1447	3	debase
debate	9	44	1919	3	debate
decade	10	42	1616	3	decade
duad	6	65	2141	3	du_ad_
duads	7	65	1534	3	du_ads
dubbed	12	41	1321	3	dubbed
dude	6	56	2966	3	du__de
duende	8	3	692	3	duende
evade	9	3	818	3	_evade
facade	12	3	880	3	facade
fade	8	57	3634	3	__fade
faunae	9	52	1037	3	fauna_e
forbade	13	25	910	3	forbade
fubar	10	3	992	3	fuba_r
fubbed	14	47	1124	3	fubbed
furane	9	40	1549	3	furane
gambades	14	3	586	3	gambades
gambado	13	4	497	3	gambado
garbage	11	3	805	3	garbage
glade	7	51	2196	3	_glade
grade	7	51	2609	3	_grade
gude	6	54	2333	3	gu__de
guide	7	50	1988	3	gu_ide
hade	8	54	4019	3	__hade
haulage	11	3	691	3	haulage
hexade	17	43	890	3	hexade
humane	11	28	1217	3	humane
humate	11	32	1444	3	humate
invade	10	15	785	3	invade
irade	6	56	1815	3	_irade
jade	12	53	2544	3	__jade
juba	13	49	1698	3	juba__
jubas	14	46	1422	3	juba_s
jube	13	63	2278	3	jub__e
jubile	15	29	1025	3	jubile
jugate	14	37	946	3	jugate
lade	5	63	4598	3	__lade
lambada	12	4	564	3	lambada
laurae	6	40	1166	3	laura_e
lobate	8	29	1524	3	lobate
lube	6	47	3156	3	lub__e
lubed	8	53	1989	3	lubed_
lude	5	53	3164	3	lu__de
lunate	6	3	1604	3	lunate
luxate	13	3	808	3	luxate
made	7	54	4023	3	__made
manmade	12	3	796	3	manmade
mutase	8	28	1198	3	mutase
mutate	8	30	1748	3	mutate
noyade	10	3	642	3	noyade
nubble	10	38	1371	3	nubble
nubile	8	32	1270	3	nubile
nude	5	66	2627	3	nu__de
nutate	6	30	1737	3	nutate
outadd	8	3	780	3	outadd
outage	7	20	1753	3	outage
outate	6	29	2340	3	outate
outbake	13	3	1077	3	outbake
parade	9	47	2064	3	parade
parbake	15	3	835	3	parbake
parkade	14	3	758	3	parkade
passade	10	3	923	3	passade
pesade	9	3	1110	3	pesade
pomade	11	36	1133	3	pomade
prebade	12	3	1028	3	prebade
pupae	9	65	1564	3	pupa_e
pupate	10	42	1312	3	pupate
quad	14	46	1870	3	qu_ad_
quads	15	45	1584	3	qu_ads
quake	18	41	1464	3	qu_ake
quale	14	36	1785	3	qu_ale
quare	14	39	2054	3	qu_are
quate	14	45	2141	3	qu_ate
qubyte	20	3	424	3	qubyte
rebate	8	44	2410	3	rebate
remade	9	43	1698	3	remade
roulade	8	5	699	3	roulade
rubaces	11	3	930	3	rubaces
rubasse	9	3	490	3	rubasse
rubati	8	29	969	3	rubati
rubato	8	31	967	3	rubato
rubbed	11	45	1508	3	rubbed
rubble	10	43	1567	3	rubble
rube	6	55	3201	3	rub__e
rubied	9	43	1240	3	rubied
ruble	7	45	2125	3	rub_le
rude	5	56	3278	3	ru__de
rugae	6	51	1476	3	ruga_e
rugate	7	58	1381	3	rugate
rumbaed	12	28	749	3	rumbaed
saccade	12	10	703	3	saccade
sade	5	55	4447	3	__sade
sambaed	12	3	830	3	sambaed
saunaed	8	3	670	3	saunaed
sausage	8	4	719	3	sausage
scubaed	12	3	612	3	scubaed
shade	9	51	2558	3	_shade
spade	8	44	2332	3	_spade
stade	6	48	2530	3	_stade
suable	8	39	2055	3	suable
suave	8	35	1987	3	su_ave
suba	6	49	2660	3	suba__
subadar	10	12	557	3	subadar
subah	10	60	1521	3	suba_h
subahs	11	45	1238	3	subahs
subarea	9	3	940	3	subarea
subas	7	47	2407	3	suba_s
subbase	11	3	932	3	subbase
subbed	11	41	1667	3	subbed
subcode	12	3	716	3	subcode
subdeb	11	3	752	3	sub_deb
subdue	9	12	849	3	subdue
subgrade	12	4	605	3	subgrade
subidea	10	3	753	3	subidea
sublate	9	3	1536	3	sublate
subrace	11	3	1300	3	subrace
subsale	9	3	1054	3	subsale
subside	10	4	1045	3	subside
subtle	8	21	1343	3	subtle
suede	6	44	1975	3	su_ede
sundae	7	3	1287	3	sundae
surbase	9	3	979	3	surbase
tirade	7	3	1169	3	tirade
trade	6	50	2604	3	_trade
tribade	10	3	728	3	tribade
tsade	6	43	1112	3	_tsade
tuba	6	54	2236	3	tuba__
tubal	7	55	1720	3	tuba_l
tubas	7	51	1957	3	tuba_s
tubbed	11	47	1222	3	tubbed
tube	6	58	2866	3	tub__e
tubed	8	58	1804	3	tubed_
tubule	8	3	985	3	tubule
tuladi	7	6	572	3	tuladi
ukase	9	42	849	3	_ukase
unbale	8	36	1640	3	unbale
unde	5	58	2548	3	_u_nde
unlade	7	27	1415	3	unlade
unmade	9	29	1106	3	unmade
urare	5	63	2255	3	_urare
urase	5	46	2468	3	_urase
urate	5	54	3216	3	_urate
urbane	8	22	1138	3	urbane
usage	6	4	1021	3	_usage
wade	8	52	3706	3	__wade

Search took 5 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.140	1276364.3
2	DLD Change Limit	112716	333	4.686	24053.8
3	Display Results	333	333	0.110	3027.3
	(SQL Overall)	178691	333	4.936	36201.6