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

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

323 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
probate	11	4	1448	(None)
probated	13	4	1086	1	probated
probates	12	4	1428	1	probates
prolate	9	4	1979	1	prolate
pronate	9	4	1887	1	pronate
prorate	9	4	1873	1	prorate
approbate	15	4	656	2	approbate
bromate	11	3	1355	2	bromate
globate	10	5	782	2	globate
lobate	8	29	1524	2	_lobate
niobate	9	3	770	2	niobate
perorate	10	4	1792	2	perorate
phonate	12	4	1181	2	phonate
phorate	12	4	1336	2	phorate
prate	7	51	3598	2	pr__ate
prebade	12	3	1028	2	prebade
prebake	15	3	909	2	prebake
predate	10	6	1689	2	predate
prelate	9	5	1969	2	prelate
primate	11	15	1628	2	primate
priorate	10	4	1173	2	priorate
private	12	15	1326	2	private
probable	14	3	905	2	probable
proband	12	27	1024	2	proband
probang	12	27	838	2	probang
probative	16	4	917	2	probative
probe	9	43	2081	2	prob__e
probit	10	32	1835	2	probit_
probits	11	27	1257	2	probits
probity	14	29	968	2	probity
proette	9	3	1236	2	proette
profane	12	21	1186	2	profane
promote	11	3	1314	2	promote
pronated	11	4	1405	2	pronated
pronates	10	4	1837	2	pronates
propane	11	27	1615	2	propane
prorated	11	5	1371	2	prorated
prorates	10	4	1807	2	prorates
prostate	10	3	1453	2	prostate
rebate	8	44	2411	2	_rebate
reprobate	13	4	768	2	reprobate
rotate	6	33	2034	2	_rotate
sorbate	9	3	1173	2	sorbate
abate	7	66	2784	3	__abate
abrogate	11	12	960	3	abrogate
acrobat	11	4	1181	3	acrobat_
acrobats	12	5	834	3	acrobats
aerobat	9	5	1447	3	aerobat_
aerobats	10	4	984	3	aerobats
apholate	13	4	1047	3	apholate
approbated	17	4	476	3	approbated
approbates	16	4	585	3	approbates
arbute	8	3	1104	3	ar_bute
arcuate	9	3	1196	3	arcuate
areolate	8	10	1445	3	areolate
arrogate	9	12	1032	3	arrogate
barbate	11	3	1454	3	barbate
bate	6	65	5242	3	___bate
bilobate	12	4	703	3	bilobate
borate	8	50	2615	3	_borate
brocade	12	3	853	3	brocade
brocatel	12	4	671	3	brocatel
brokage	14	3	667	3	brokage
bromated	13	3	917	3	bromated
bromates	12	4	1314	3	bromates
cholate	12	21	1493	3	cholate
chromate	15	3	1278	3	chromate
cohobate	15	4	701	3	cohobate
comate	10	41	2484	3	_comate
cordate	10	3	1522	3	cordate
coronate	10	30	1821	3	coronate
corotate	10	28	1393	3	corotate
crate	7	65	3740	3	cr__ate
create	8	51	2638	3	cr_eate
cremate	11	38	1618	3	cremate
crenate	9	33	1711	3	crenate
croute	8	46	1727	3	cro_ute
debate	9	44	1919	3	_debate
derogate	10	3	1135	3	derogate
donate	7	36	1950	3	_donate
ephorate	13	5	950	3	ephorate
ergate	7	3	1514	3	er_gate
folate	9	33	2039	3	_folate
forbade	13	25	910	3	forbade
forbare	12	23	1051	3	forbare
formate	12	31	1509	3	formate
frigate	11	3	1106	3	frigate
fromage	13	3	675	3	fromage
globated	12	6	575	3	globated
gradate	9	5	1123	3	gradate
grate	6	49	3288	3	gr__ate
groat	6	55	3197	3	gro_at_
groats	7	48	1665	3	gro_ats
iodate	7	3	1350	3	_iodate
irate	5	56	2798	3	ir__ate
isobare	9	4	634	3	isobare
isobath	12	4	461	3	isobath
isolate	7	3	1392	3	isolate
limbate	11	3	921	3	limbate
lobated	10	26	1094	3	_lobated
locate	8	39	1984	3	_locate
neonate	7	3	1133	3	neonate
niobates	10	3	728	3	niobates
niobite	9	3	795	3	niobite
notate	6	32	1786	3	_notate
oblate	8	22	1474	3	__oblate
obovate	12	3	546	3	obovate
odonate	8	4	840	3	odonate
orate	5	51	3330	3	__orate
ornate	6	3	1514	3	or_nate
ovate	8	42	1439	3	__ovate
ozonate	16	4	686	3	ozonate
palate	8	42	2679	3	p_alate
paleate	9	41	2000	3	paleate
palmate	11	32	1523	3	palmate
palpate	11	32	1392	3	palpate
parbake	15	3	835	3	parbake
pate	6	53	5046	3	p___ate
pectate	11	22	1469	3	pectate
pedate	9	31	1776	3	p_edate
peltate	9	20	1377	3	peltate
pennate	9	33	1403	3	pennate
peonage	10	4	872	3	peonage
perborate	13	5	1014	3	perborate
percolate	13	4	1116	3	percolate
perforate	14	5	946	3	perforate
periodate	12	4	834	3	periodate
permeate	12	3	1161	3	permeate
perorated	12	4	1247	3	perorated
perorates	11	4	1702	3	perorates
personate	11	21	1142	3	personate
phenate	12	4	1220	3	phenate
phonated	14	4	789	3	phonated
phonates	13	4	1064	3	phonates
phorates	13	4	1304	3	phorates
picrate	11	20	1414	3	picrate
pileate	9	38	1592	3	pileate
pinnate	9	36	1374	3	pinnate
pirate	8	23	2288	3	p_irate
placate	11	3	1243	3	placate
planate	9	3	1457	3	planate
plate	7	46	3511	3	p__late
plicate	11	3	1451	3	plicate
plumate	11	4	980	3	plumate
podite	9	33	1535	3	p_odite
pointe	8	46	1931	3	p_ointe
polite	8	36	2507	3	p_olite
pomace	12	31	1191	3	p_omace
pomade	11	36	1133	3	p_omade
portage	10	30	1364	3	portage
potage	9	27	1590	3	p_otage
potato	8	5	1343	3	p_otato
prase	7	61	2875	3	pr__ase
prat	6	59	5204	3	pr__at_
prated	9	49	2492	3	pr__ated
prater	8	48	2535	3	pr__ater
prates	8	46	3316	3	pr__ates
prats	7	63	3339	3	pr__ats
prebaked	17	3	717	3	prebaked
prebakes	16	3	901	3	prebakes
prebattle	13	4	301	3	prebattle
predated	12	5	1327	3	predated
predates	11	6	1581	3	predates
predebate	14	4	616	3	predebate
preface	14	5	1092	3	preface
prefade	13	3	901	3	prefade
pregame	12	3	955	3	pregame
prelates	10	4	1857	3	prelates
prelocate	13	10	952	3	prelocate
premade	12	3	1144	3	premade
prename	11	4	1264	3	prename
prepare	11	19	1362	3	prepare
prepaste	12	13	908	3	prepaste
prepave	14	22	887	3	prepave
prerace	11	4	1412	3	prerace
presage	10	3	1229	3	presage
presale	9	4	1635	3	presale
pretape	11	35	1162	3	pretape
pretaste	10	13	952	3	pretaste
primage	12	16	914	3	primage
primates	12	15	1593	3	primates
priorates	11	4	1076	3	priorates
privater	13	15	853	3	privater
privates	13	18	1237	3	privates
proa	6	62	2996	3	pro_a__
proas	7	50	2880	3	pro_a_s
probables	15	4	543	3	probables
probably	17	4	641	3	probably
probands	13	22	839	3	probands
probangs	13	25	621	3	probangs
probating	14	3	1119	3	probating
probation	13	4	1218	3	probation
probatory	16	4	711	3	probatory
probed	11	41	1482	3	prob_ed
prober	10	45	1607	3	prob_er
probers	11	35	1458	3	probers
probes	10	41	1945	3	prob_es
probing	12	33	1444	3	probing
probities	13	3	1265	3	probities
problem	13	3	598	3	problem
procaine	12	3	1227	3	procaine
procarp	13	4	682	3	procarp
procreate	13	4	814	3	procreate
procure	11	3	857	3	procure
produce	12	6	751	3	produce
proettes	10	3	1276	3	proettes
profaned	14	20	797	3	profaned
profaner	13	19	794	3	profaner
profanes	13	23	1157	3	profanes
profile	12	32	1115	3	profile
profit	11	30	1627	3	profit_
profited	14	27	997	3	profited
profiter	13	27	1020	3	profiter
profits	12	29	1124	3	profits
profuse	12	3	715	3	profuse
prograde	12	4	718	3	prograde
projet	15	3	1518	3	projet_
projets	16	3	916	3	projets
prolan	8	4	1469	3	prola_n
prolans	9	3	1427	3	prolans
prolapse	12	13	491	3	prolapse
prolately	14	4	577	3	prolately
prole	7	45	2779	3	pro__le
proline	9	23	2159	3	proline
promine	11	28	1944	3	promine
promise	11	34	1584	3	promise
promoted	13	3	1054	3	promoted
promoter	12	3	1145	3	promoter
promotes	12	3	1412	3	promotes
prompt	12	3	1301	3	prompt_
prompted	15	3	690	3	prompted
prompter	14	3	798	3	prompter
prompts	13	3	747	3	prompts
pronator	10	3	1178	3	pronator
prone	7	53	3262	3	pro__ne
pronota	9	3	976	3	pronota
pronto	8	3	1399	3	pro_nto
propagate	14	4	612	3	propagate
propanes	12	24	1582	3	propanes
propene	11	27	1604	3	propene
prophage	16	4	943	3	prophage
prophase	15	4	1024	3	prophase
prophet	14	3	1603	3	prophet
propine	11	30	2021	3	propine
propjet	18	3	991	3	propjet
propone	11	27	1630	3	propone
propose	11	27	1484	3	propose
prorogate	12	4	769	3	prorogate
prosaic	11	3	1116	3	prosaic
prosateur	11	4	358	3	prosateur
prose	7	58	3512	3	pro__se
prosit	8	51	2459	3	prosit_
prossie	9	18	1296	3	prossie
prost	7	54	3410	3	pro_st_
prostates	11	3	1442	3	prostates
prostie	9	16	1774	3	prostie
prostrate	11	4	1248	3	prostrate
protases	10	21	1503	3	protases
protatic	12	3	1475	3	protatic
protea	8	22	1476	3	pro__tea
protease	10	20	989	3	protease
protege	10	5	915	3	protege
protei	8	26	1531	3	pro__tei
protonate	11	4	1257	3	protonate
protrade	11	4	821	3	protrade
protyle	12	22	945	3	protyle
provable	15	3	909	3	provable
prove	10	48	2319	3	pro__ve
provide	13	3	985	3	provide
provoke	16	7	612	3	provoke
prowar	11	41	1094	3	prowa_r
proximate	20	4	577	3	proximate
psoae	7	44	1162	3	pso_a_e
pulsate	9	5	1023	3	pulsate
pupate	10	42	1312	3	p_upate
pyruvate	16	4	307	3	pyruvate
rabat	7	28	3222	3	_rabat_
rabato	8	34	1326	3	_rabato
rabats	8	31	1622	3	_rabats
ramate	8	39	2169	3	_ramate
rate	4	54	5876	3	_r__ate
rebated	10	36	1970	3	_rebated
rebater	9	35	1791	3	_rebater
rebates	9	51	2318	3	_rebates
rebato	8	37	1468	3	_rebato
redate	7	41	2468	3	_redate
relate	6	40	3363	3	_relate
remate	8	44	2868	3	_remate
reprobated	15	4	639	3	reprobated
reprobates	14	4	736	3	reprobates
robalo	8	3	893	3	_robalo
roband	9	23	1072	3	_roband
robe	6	53	3564	3	_rob__e
roble	7	52	2302	3	_rob_le
robot	7	3	2597	3	_robot_
robots	8	3	1315	3	_robots
roseate	7	6	1345	3	_roseate
rotated	8	27	1529	3	_rotated
rotates	7	28	1977	3	_rotates
rote	4	62	4902	3	_ro__te
rotte	5	46	2593	3	_ro_tte
route	5	51	3207	3	_ro_ute
rubace	10	3	1017	3	_rubace
rubati	8	29	969	3	_rubati
rubato	8	31	968	3	_rubato
rugate	7	58	1381	3	_rugate
solate	6	45	2607	3	_solate
sorbates	10	3	1110	3	sorbates
sororate	8	4	1117	3	sororate
stomate	9	3	1312	3	stomate
togate	7	45	1568	3	_togate
trabeate	10	4	948	3	trabeate
tribade	10	3	729	3	tribade
tribute	9	3	731	3	tribute
trilobate	11	4	543	3	trilobate
tubate	8	28	1317	3	_tubate
uprate	8	39	1654	3	upr__ate
urate	5	54	3216	3	ur__ate
urbane	8	22	1138	3	ur_bane
urinate	7	3	1536	3	urinate
violate	10	3	1155	3	violate
wrote	8	47	1748	3	wro__te
zonate	15	41	1492	3	_zonate

Search took 8 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	323	7.266	18445.8
3	Display Results	323	323	0.123	2626.0
	(SQL Overall)	178691	323	7.795	22923.8