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

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

316 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
deftest	11	26	1171	(None)
daftest	11	24	894	1	daftest
deffest	14	30	880	1	deffest
detest	7	41	2284	1	de_test
leftest	10	26	946	1	leftest
adeptest	11	4	545	2	adeptest
deadest	9	30	1488	2	deadest
deafest	11	29	1151	2	deafest
dearest	8	36	1867	2	dearest
deepest	10	3	1044	2	deepest
defeat	10	38	1716	2	def_eat
defect	12	48	1617	2	def_ect
defies	10	46	2405	2	defies_
deflect	13	39	997	2	deflect
deforest	12	3	879	2	deforest
defrost	11	3	955	2	defrost
defter	10	42	1592	2	defte_r
deftness	12	3	630	2	deftness
densest	8	31	1247	2	densest
dentist	8	3	1674	2	dentist
detect	9	42	1740	2	de_tect
detent	7	36	2448	2	de_tent
detests	8	37	1174	2	de_tests
devest	10	44	1870	2	de_vest
dewiest	11	3	1234	2	dewiest
featest	10	27	1511	2	featest
heftiest	14	3	918	2	heftiest
leftist	10	27	935	2	leftist
neatest	7	25	1600	2	neatest
oftest	9	12	1200	2	_oftest
pertest	9	3	1704	2	pertest
retest	6	40	2845	2	re_test
softest	10	3	1060	2	softest
wettest	10	23	936	2	wettest
acutest	9	44	1060	3	acutest
aeriest	7	39	2405	3	aeriest
alertest	8	3	1017	3	alertest
aptest	8	29	1751	3	_aptest
attest	6	26	1861	3	_attest
beefiest	13	26	901	3	beefiest
befret	11	3	1596	3	befre_t
befrets	12	3	761	3	befrets
behest	11	3	1461	3	be_hest
bequest	18	3	782	3	bequest
buffest	15	29	864	3	buffest
certes	8	46	2308	3	certes_
cetes	7	57	3110	3	ce_tes_
contest	9	35	2323	3	contest
curtest	9	7	1396	3	curtest
cutest	8	58	2014	3	_cutest
daffiest	15	3	784	3	daffiest
dafter	10	48	1334	3	dafte_r
daftness	12	3	553	3	daftness
dampest	12	4	1104	3	dampest
dankest	12	26	1167	3	dankest
darkest	12	25	1262	3	darkest
dates	6	56	3915	3	d_ates_
deafness	12	3	621	3	deafness
deaths	10	59	1444	3	deaths_
deaves	10	53	1953	3	deaves_
debates	10	37	1853	3	debates_
debtless	11	3	565	3	debtless
debts	8	64	1837	3	debt_s_
debyes	12	3	810	3	debyes_
deceit	9	30	1821	3	de_ceit
decent	9	40	2370	3	de_cent
decentest	12	4	908	3	decentest
deediest	10	29	1225	3	deediest
dees	5	63	5663	3	de__es_
deet	5	73	5658	3	de__e_t
deets	6	53	3024	3	deet_s_
defaces	13	32	1340	3	defaces_
defames	13	28	1225	3	defames_
defat	9	54	2669	3	def__at
defats	10	51	1455	3	defats_
default	11	4	789	3	default
defeatist	13	5	660	3	defeatist
defeats	11	35	1123	3	def_eats
defects	13	45	1152	3	def_ects
defend	11	39	1049	3	def_end
defense	11	3	750	3	defense
defer	9	46	1975	3	def_e_r
deferent	12	27	1287	3	deferent
defers	10	51	1694	3	def_ers
deffer	13	44	1130	3	deffe_r
defiant	11	3	1192	3	defiant
deficit	13	3	967	3	deficit
defied	11	50	1638	3	defie_d
defier	10	51	1865	3	defie_r
defiers	11	39	1399	3	defiers
defiles	11	40	1684	3	defiles_
defines	11	41	1868	3	defines_
defis	9	67	1750	3	def_is_
deflates	12	30	1394	3	deflates_
deflea	10	3	744	3	defle_a
defleas	11	4	722	3	defleas
deflects	14	33	673	3	deflects
defogs	11	5	668	3	defogs_
deforests	13	4	437	3	deforests
defrosts	12	4	483	3	defrosts
deft	8	55	4022	3	def___t
deftly	13	3	653	3	deft_ly
defuel	10	34	893	3	defue_l
defuels	11	29	698	3	defuels
defunct	13	4	577	3	defunct
defuse	10	57	1272	3	def_use
defused	12	52	1109	3	defused
defuser	11	51	1050	3	defuser
defuses	11	48	1459	3	defuses
defuzes	20	39	830	3	defuzes_
degust	8	3	1025	3	de_gust
deices	9	41	1937	3	deices_
deifies	11	33	1745	3	deifies_
deist	6	46	3359	3	de__ist
deities	8	26	2192	3	deities_
deject	16	45	1284	3	de_ject
dekes	10	52	2445	3	de_kes_
delates	8	35	2628	3	delates_
deles	6	51	3925	3	de_les_
deletes	8	31	1793	3	deletes_
delfts	10	43	967	3	delft_s_
delist	7	46	2505	3	de_list
deltas	7	44	1482	3	deltas_
delts	6	57	3179	3	delt_s_
delves	10	49	1708	3	delves_
demast	9	5	1706	3	de_mast
dement	9	38	2514	3	de_ment
demes	8	60	3269	3	de_mes_
demies	9	48	2580	3	demies_
demotes	10	47	1767	3	demotes_
demotist	11	3	1184	3	demotist
demurest	11	3	745	3	demurest
denes	6	56	3972	3	de_nes_
denies	7	47	2964	3	denies_
denotes	8	38	1700	3	denotes_
dented	8	41	2051	3	dente_d
dentists	9	3	926	3	dentists
dents	6	50	3180	3	dent_s_
depress	10	23	987	3	depress
depths	12	42	857	3	depths_
deputes	10	49	1178	3	deputes_
derates	8	40	2889	3	derates_
descent	10	26	1629	3	descent
desert	7	27	2549	3	de_sert
desist	7	48	1881	3	de_sist
dessert	8	29	1645	3	dessert
detects	10	40	1109	3	de_tects
detente	8	33	1360	3	de_tente
detents	8	36	1515	3	de_tents
deter	6	50	2804	3	de_te_r
deters	7	47	2468	3	de_ters
detested	10	27	962	3	de_tested
detester	9	23	968	3	de_tester
deuces	9	40	1551	3	deuces_
devests	11	44	1047	3	de_vests
devotes	11	37	1375	3	devotes_
devoutest	13	4	364	3	devoutest
dewless	11	3	747	3	dewless
dexes	13	52	2451	3	de_xes_
dexies	14	50	1834	3	dexies_
dexter	14	38	1089	3	dexte_r
diciest	10	33	1652	3	diciest
dictiest	11	32	1278	3	dictiest
digest	8	40	1962	3	d_igest
dimmest	12	4	925	3	dimmest
directest	12	4	630	3	directest
direst	7	50	2424	3	d_irest
dirtiest	9	30	1420	3	dirtiest
distent	8	41	2085	3	distent
dites	6	63	3915	3	d_ites_
divest	10	68	2007	3	d_ivest
doest	6	58	2952	3	d__oest
dopiest	10	33	1599	3	dopiest
dotes	6	58	3669	3	d_otes_
dotiest	8	37	1745	3	dotiest
dottiest	9	26	1139	3	dottiest
dourest	8	3	1294	3	dourest
doziest	17	40	1247	3	doziest
draftiest	13	3	594	3	draftiest
drest	6	55	3034	3	d__rest
driest	7	47	2275	3	d_riest
driftiest	13	3	594	3	driftiest
dryest	10	48	1112	3	d_ryest
duettist	9	4	551	3	duettist
dullest	8	3	1263	3	dullest
dumbest	12	3	874	3	dumbest
dunnest	8	33	1226	3	dunnest
dustiest	9	30	1507	3	dustiest
edgiest	9	23	1035	3	edgiest
eeliest	7	35	1647	3	eeliest
eeriest	7	36	2067	3	eeriest
effect	14	3	744	3	_effect
efts	7	65	1948	3	_eft_s_
egest	6	52	2234	3	_e_gest
eldest	7	29	1268	3	_eldest
extent	13	27	1491	3	_extent
fastest	10	24	1372	3	fastest
fattest	10	29	1306	3	fattest
fellest	10	3	1375	3	fellest
fest	7	49	4944	3	__f_est
fetes	8	56	3014	3	fe_tes_
fewest	12	3	1166	3	fe_west
feyest	12	3	1140	3	fe_yest
fittest	10	25	1080	3	fittest
fleetest	11	3	672	3	fleetest
geest	6	48	2961	3	ge__est
gentes	7	53	2416	3	gentes_
gentlest	9	34	1057	3	gentlest
gestes	7	57	2139	3	gestes_
greatest	9	3	986	3	greatest
hefted	13	49	1142	3	hefte_d
hefter	12	43	1392	3	hefte_r
hefters	13	43	1200	3	hefters
hefts	11	62	1815	3	heft_s_
heppest	14	22	814	3	heppest
hottest	10	4	1138	3	hottest
ideates	8	3	1373	3	ideates_
iffiest	13	3	796	3	iffiest
infest	9	33	1543	3	inf_est
iratest	7	3	1248	3	iratest
jefes	15	56	1367	3	jef_es_
jetes	12	49	2284	3	je_tes_
jettiest	15	35	959	3	jettiest
justest	14	4	989	3	justest
keenest	11	4	1096	3	keenest
kentes	10	51	1864	3	kentes_
latest	6	38	2270	3	_latest
leafiest	11	34	1088	3	leafiest
leanest	7	4	1586	3	leanest
lefter	9	36	1343	3	lefte_r
lefties	10	3	1207	3	lefties_
leftish	13	19	725	3	leftish
leftism	12	22	609	3	leftism
leftists	11	23	551	3	leftists
leftmost	13	4	258	3	leftmost
lefts	8	65	1781	3	left_s_
lewdest	11	3	628	3	lewdest
liefest	10	3	844	3	lief_est
loftiest	11	3	908	3	loftiest
meanest	9	3	1570	3	meanest
meatiest	10	28	1679	3	meatiest
meekest	13	3	689	3	meekest
merest	8	47	2511	3	me_rest
mesteso	9	3	713	3	mesteso
metes	7	47	3621	3	me_tes_
modestest	12	4	500	3	modestest
mostest	9	3	1479	3	mostest
mutest	8	42	1805	3	_mutest
nearest	7	34	1584	3	nearest
nettiest	8	31	1243	3	nettiest
newest	9	3	1421	3	ne_west
niftiest	11	29	1007	3	niftiest
obtest	8	12	1301	3	_obtest
peartest	10	3	1130	3	peartest
peatiest	10	31	1880	3	peatiest
peltast	9	3	1051	3	peltast
pestiest	10	30	1841	3	pestiest
pettiest	10	31	1396	3	pettiest
pretest	9	5	1763	3	pretest
protest	9	3	1753	3	protest
realest	7	33	2243	3	realest
reddest	9	3	1195	3	reddest
reefiest	11	28	1148	3	reefiest
reest	5	49	3809	3	re__est
refect	11	43	1933	3	ref_ect
refelt	9	45	2142	3	ref_elt
reflect	12	39	1371	3	reflect
reflet	9	40	2423	3	refle_t
reflets	10	35	1315	3	reflets
reforest	11	3	996	3	reforest
refresh	13	3	545	3	refresh
refutes	10	45	1572	3	refutes_
remotest	10	33	1072	3	remotest
renest	6	45	2971	3	re_nest
rentes	6	54	3119	3	rentes_
request	16	3	1102	3	request
retests	7	38	1385	3	re_tests
revest	9	46	2360	3	re_vest
rifest	9	31	1458	3	rif_est
safest	9	50	1660	3	saf_est
saltest	7	19	1651	3	saltest
searest	7	33	2202	3	searest
sedatest	9	24	939	3	sedatest
septet	8	9	2113	3	septe_t
septets	9	9	895	3	septets
serest	6	48	3161	3	se_rest
sestet	6	8	2620	3	seste_t
sestets	7	9	1147	3	sestets
sexiest	14	21	1222	3	sexiest
sextet	13	9	1687	3	sexte_t
sextets	14	9	714	3	sextets
subtest	9	5	1396	3	subtest
sveltest	11	3	587	3	sveltest
sweetest	11	3	717	3	sweetest
swiftest	14	3	435	3	swiftest
tartest	7	25	1753	3	tartest
tautest	7	26	1244	3	tautest
tempest	11	3	922	3	tempest
tensest	7	27	1331	3	tensest
tentiest	8	21	1561	3	tentiest
tersest	7	17	1399	3	tersest
test	4	86	5162	3	___test
testes	6	51	2582	3	testes_
testiest	8	27	1522	3	testiest
tritest	7	3	1527	3	tritest
tuftiest	11	3	828	3	tuftiest
vastest	10	29	1151	3	vastest
veriest	10	37	1913	3	veriest
wattest	10	24	1215	3	wattest
weakest	14	3	900	3	weakest
weest	8	50	2677	3	we__est
wefts	11	67	1549	3	weft_s_
whitest	13	37	1011	3	whitest
wiftiest	14	27	917	3	wiftiest
yentes	9	55	1760	3	yentes_
zestiest	17	30	1110	3	zestiest

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	134027	0.156	1145455.1
2	DLD Change Limit	134027	316	6.326	21186.7
3	Display Results	316	316	0.126	2507.9
	(SQL Overall)	178691	316	6.608	27041.6