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

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

255 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
prebake	15	3	909	(None)
prebade	12	3	1028	1	prebade
prebaked	17	3	717	1	prebaked
prebakes	16	3	901	1	prebakes
parbake	15	3	835	2	parbake
predate	10	6	1689	2	predate
preface	14	5	1092	2	preface
prefade	13	3	901	2	prefade
pregame	12	3	955	2	pregame
prelate	9	5	1969	2	prelate
premade	12	3	1144	2	premade
prename	11	4	1264	2	prename
prepare	11	19	1362	2	prepare
prepave	14	22	887	2	prepave
prerace	11	4	1412	2	prerace
presage	10	3	1229	2	presage
presale	9	4	1635	2	presale
pretape	11	35	1162	2	pretape
probate	11	4	1448	2	probate
rebate	8	44	2411	2	_rebate
rebuke	12	40	1012	2	_rebuke
remake	12	40	1611	2	_remake
retake	10	47	1853	2	_retake
rewake	13	52	1846	2	_rewake
amebae	10	4	963	3	ameba_e
areae	5	52	2974	3	are_a_e
bake	10	56	3751	3	___bake
berake	12	42	1608	3	_berake
betake	12	45	1270	3	_betake
brake	11	60	2534	3	br__ake
break	11	53	1940	3	bre_ak_
breaker	13	39	1292	3	bre_aker
breaks	12	48	1642	3	bre_aks
brewage	13	4	718	3	brewage
caretake	14	4	677	3	caretake
crake	11	48	2352	3	cr__ake
creak	11	54	1843	3	cre_ak_
creaked	14	34	1323	3	cre_aked
creaks	12	43	1596	3	cre_aks
creaky	15	49	1155	3	cre_aky
crease	8	55	1957	3	cre_ase
create	8	51	2638	3	cre_ate
cremate	11	38	1618	3	cremate
crenate	9	33	1711	3	crenate
debase	9	40	1447	3	_debase
debate	9	44	1919	3	_debate
drake	10	49	1830	3	dr__ake
firebase	13	4	649	3	firebase
freak	12	51	1524	3	fre_ak_
freaked	15	39	970	3	fre_aked
freaks	13	47	1306	3	fre_aks
freaky	16	43	923	3	fre_aky
freebase	13	4	486	3	freebase
glebae	9	40	761	3	gleba_e
grease	7	54	1623	3	gre_ase
greave	10	46	1149	3	gre_ave
grebe	8	51	1494	3	greb__e
grenade	9	3	841	3	grenade
herbage	13	3	701	3	herbage
hoecake	16	4	520	3	hoecake
outbake	13	3	1077	3	outbake
overbake	17	12	980	3	overbake
pancake	15	3	667	3	pancake
parbaked	17	3	550	3	parbaked
parbakes	16	3	834	3	parbakes
partake	13	3	964	3	partake
peace	9	50	2608	3	p_e_ace
peage	8	47	2357	3	p_e_age
peak	10	65	3520	3	p_e_ak_
peaked	13	61	1740	3	p_e_aked
peaks	11	48	2562	3	p_e_aks
peaky	14	57	1815	3	p_e_aky
pease	7	52	3111	3	p_e_ase
pebble	12	3	800	3	p_ebble
pedate	9	31	1776	3	p_edate
peerage	10	8	980	3	peerage
peke	10	59	2620	3	p_e__ke
pelage	9	5	1536	3	p_elage
percale	11	3	1409	3	percale
peruke	12	32	1039	3	p_eruke
pervade	13	3	702	3	pervade
pesade	9	3	1110	3	p_esade
phenate	12	4	1220	3	phenate
phreak	15	3	615	3	phre_ak_
phreaked	18	3	449	3	phre_aked
phreaker	17	3	505	3	phre_aker
phreaks	16	3	454	3	phre_aks
piebald	12	4	550	3	piebald
pikake	11	11	580	3	p_ikake
please	8	43	1573	3	ple_ase
plebe	9	50	1487	3	pleb__e
prase	7	61	2875	3	pr__ase
prate	7	51	3598	3	pr__ate
preach	13	36	1392	3	pre_ach
preact	10	32	2039	3	pre_act
preaged	11	6	1233	3	pre_aged
preamp	12	3	899	3	pre_amp
prearm	10	45	1235	3	pre_arm
preaver	12	10	1161	3	pre_aver
prebaking	18	3	806	3	prebaking
prebasal	12	4	472	3	prebasal
prebattle	13	4	301	3	prebattle
prebend	12	31	944	3	prebend
prebid	11	35	1284	3	preb_id
prebids	12	39	988	3	prebids
prebill	11	3	880	3	prebill
prebind	12	38	1064	3	prebind
preboard	13	3	826	3	preboard
preboil	11	4	895	3	preboil
prebook	15	5	752	3	prebook
prebooked	18	6	391	3	prebooked
prebooks	16	5	630	3	prebooks
preboom	13	4	825	3	preboom
prebuy	13	5	742	3	preb_uy
prebuys	14	4	439	3	prebuys
precast	11	3	1485	3	precast
precava	14	4	509	3	precava
precavae	15	4	481	3	precavae
precede	12	3	965	3	precede
precipe	13	30	1212	3	precipe
precise	11	35	1817	3	precise
precode	12	3	1185	3	precode
precure	11	3	1255	3	precure
predated	12	5	1327	3	predated
predates	11	6	1581	3	predates
predawn	13	3	535	3	predawn
predebate	14	4	616	3	predebate
predive	13	5	1108	3	predive
pree	6	70	4473	3	pre___e
preemie	11	3	1056	3	preemie
prefab	13	3	624	3	prefa_b
prefabs	14	3	516	3	prefabs
prefaced	16	3	842	3	prefaced
prefacer	15	3	798	3	prefacer
prefaces	15	3	1106	3	prefaces
prefaded	15	3	782	3	prefaded
prefades	14	3	953	3	prefades
prefile	12	34	1318	3	prefile
prefire	12	40	1281	3	prefire
preflame	15	4	591	3	preflame
pregames	13	3	900	3	pregames
prelacy	14	3	758	3	prelacy
prelates	10	4	1857	3	prelates
prelaw	11	3	910	3	prela_w
prelife	12	7	994	3	prelife
prelude	10	3	801	3	prelude
preman	10	41	1745	3	prema_n
premarket	17	12	785	3	premarket
premie	10	36	1799	3	pre_mie
premise	11	38	1855	3	premise
premune	11	3	893	3	premune
prenames	12	3	1164	3	prenames
prepack	17	5	764	3	prepack
prepacked	20	15	565	3	prepacked
prepacks	18	3	658	3	prepacks
prepaid	12	3	1013	3	prepaid
prepared	13	22	1087	3	prepared
preparer	12	16	964	3	preparer
prepares	12	20	1416	3	prepares
prepaste	12	13	908	3	prepaste
prepaved	16	17	723	3	prepaved
prepaves	15	18	919	3	prepaves
prepay	13	3	1031	3	prepa_y
prepays	14	3	748	3	prepays
preplace	14	8	898	3	preplace
preppie	10	5	809	3	preppie
prepuce	13	3	783	3	prepuce
presa	7	43	1904	3	presa__
presaged	12	3	880	3	presaged
presager	11	3	844	3	presager
presages	11	3	1220	3	presages
presales	10	3	1526	3	presales
prese	7	52	2838	3	pre__se
preshape	15	3	753	3	preshape
preside	10	7	1561	3	preside
presoak	13	4	845	3	presoak_
presoaked	16	3	565	3	presoaked
presoaks	14	3	660	3	presoaks
presume	11	3	1030	3	presume
pretaped	13	33	913	3	pretaped
pretapes	12	28	1153	3	pretapes
pretaste	10	13	952	3	pretaste
pretax	15	23	1019	3	preta_x
pretype	14	38	748	3	pretype
prevail	12	3	824	3	prevail
prevalue	13	4	507	3	prevalue
previse	12	37	1379	3	previse
prevue	11	7	916	3	pre_vue
prewar	11	47	1258	3	prewa_r
prewarm	14	47	961	3	prewarm
prewarn	12	44	1015	3	prewarn
prewash	15	3	521	3	prewash
prewire	12	43	1114	3	prewire
primage	12	16	914	3	primage
primate	11	15	1628	3	primate
private	12	15	1326	3	private
probable	14	3	905	3	probable
proband	12	27	1024	3	proband
probang	12	27	838	3	probang
probated	13	4	1086	3	probated
probates	12	4	1428	3	probates
probe	9	43	2081	3	prob__e
profane	12	21	1186	3	profane
prolate	9	4	1979	3	prolate
pronate	9	4	1887	3	pronate
propane	11	27	1615	3	propane
prorate	9	4	1873	3	prorate
provoke	16	7	612	3	provoke
rake	8	48	4157	3	_r__ake
reave	8	45	2802	3	_re_ave
reawake	14	45	789	3	_reawake
rebait	8	3	2040	3	_rebait
rebar	7	54	2019	3	_reba_r
rebars	8	40	1983	3	_rebars
rebated	10	36	1970	3	_rebated
rebater	9	35	1791	3	_rebater
rebates	9	51	2318	3	_rebates
rebato	8	37	1468	3	_rebato
rebbe	9	3	1316	3	_reb_be
rebore	8	66	2565	3	_rebore
rebuked	14	43	834	3	_rebuked
rebuker	13	40	784	3	_rebuker
rebukes	13	42	1055	3	_rebukes
recane	8	30	2287	3	_recane
redate	7	41	2468	3	_redate
reface	11	36	1635	3	_reface
regale	7	48	2145	3	_regale
regave	10	47	1338	3	_regave
relace	8	31	2215	3	_relace
relate	6	40	3363	3	_relate
remade	9	43	1698	3	_remade
remaker	13	38	1317	3	_remaker
remakes	13	41	1617	3	_remakes
remate	8	44	2868	3	_remate
rename	8	27	1881	3	_rename
repave	11	48	1387	3	_repave
resale	6	40	2554	3	_resale
retaken	11	39	1180	3	_retaken
retaker	11	37	1431	3	_retaker
retakes	11	37	1886	3	_retakes
retape	8	39	1768	3	_retape
revoke	13	52	1624	3	_revoke
rewaked	15	38	1190	3	_rewaked
rewaken	14	44	1027	3	_rewaken
rewakes	14	46	1498	3	_rewakes
rewoke	13	395	2122	3	_rewoke
rubace	10	3	1017	3	_rubace
treble	8	3	1166	3	treb_le
tribade	10	3	729	3	tribade
urbane	8	22	1138	3	ur_bane
urease	6	45	1699	3	ure_ase
wreak	12	55	1327	3	wre_ak_
wreaked	15	36	902	3	wre_aked
wreaker	14	36	1004	3	wre_aker
wreaks	13	47	1111	3	wre_aks

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.406	440125.6
2	DLD Change Limit	134027	255	6.050	22153.2
3	Display Results	255	255	0.090	2833.3
	(SQL Overall)	178691	255	6.546	27297.7