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

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

317 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
creator	9	37	1445	(None)
creators	10	28	1442	1	creators
cremator	12	6	920	1	cremator
aerator	7	3	1485	2	aerator
caveator	13	8	723	2	caveator
cheater	12	48	1696	2	cheater
chelator	13	4	792	2	chelator
citator	9	3	1012	2	citator
cocreator	13	4	697	2	cocreator
crater	8	50	2664	2	cr_ater
craton	8	45	1719	2	cr_aton
creamer	11	37	1409	2	creamer
creaser	9	44	1574	2	creaser
create	8	51	2638	2	creat_e
created	10	43	2346	2	created
creates	9	52	2521	2	creates
creatin	9	36	1813	2	creatin
creation	10	28	1651	2	creation
creature	10	3	874	2	creature
creditor	11	4	591	2	creditor
cremators	13	6	983	2	cremators
crematory	16	4	722	2	crematory
curator	9	3	1221	2	curator
erector	9	35	1381	2	erector
greater	8	44	1649	2	greater
orator	6	3	1453	2	or_ator
praetor	9	3	897	2	praetor
predator	11	3	1006	2	predator
pretor	8	3	1575	2	pre_tor
reactor	9	30	1166	2	_reactor
realtor	7	36	1135	2	_realtor
rector	8	40	1975	2	_rector
relator	7	40	1638	2	_relator
treater	7	42	1983	2	treater
abator	8	45	1273	3	_abator
abettor	9	5	620	3	abettor
ablator	9	3	986	3	ablator
accentor	12	10	614	3	accentor
acceptor	14	11	492	3	acceptor
actuator	10	4	664	3	actuator
aerators	8	3	1562	3	aerators
aleatory	11	4	883	3	aleatory
arrestor	8	4	766	3	arrestor
aviator	10	22	968	3	aviator
barrator	10	4	841	3	barrator
beater	8	47	2939	3	_beater
bettor	8	36	1222	3	_bettor
bleater	9	45	1530	3	bleater
breaker	13	39	1292	3	breaker
breath	11	39	1627	3	breat_h
breathe	12	37	1185	3	breathe
breather	13	36	1060	3	breather
breaths	12	44	1120	3	breaths
breathy	15	32	804	3	breathy
cantor	8	56	2152	3	c_antor
captor	10	49	1460	3	c_aptor
castor	8	44	1853	3	c_astor
cater	7	48	4072	3	c__ater
caveators	14	9	726	3	caveators
censor	8	40	1129	3	c_ensor
center	8	44	2141	3	c_enter
cento	7	66	2517	3	c_ento_
centos	8	59	2046	3	c_entos
cerate	8	48	2946	3	cerat_e
cerated	10	39	2247	3	cerated
cerates	9	54	2825	3	cerates
ceratin	9	30	2016	3	ceratin
ceratoid	11	4	992	3	ceratoid
cestoi	8	45	1195	3	c_estoi
cestos	8	47	1809	3	c_estos
chador	12	3	867	3	c_hador
chantor	12	37	1031	3	chantor
cheaper	14	40	1058	3	cheaper
cheapo	13	48	1008	3	cheapo_
cheapos	14	41	851	3	cheapos
cheat	10	57	3245	3	cheat__
cheated	13	44	1635	3	cheated
cheaters	13	36	1351	3	cheaters
cheats	11	45	1954	3	cheat_s
chelators	14	4	817	3	chelators
citators	10	3	1025	3	citators
citatory	13	4	721	3	citatory
clamor	10	4	945	3	c_lamor
cleaner	9	37	1230	3	cleaner
clear	7	62	1905	3	clea__r
clearer	9	37	1082	3	clearer
cleat	7	63	3506	3	cleat__
cleated	10	34	1785	3	cleated
cleats	8	49	1931	3	cleat_s
cleaver	12	41	1080	3	cleaver
coactor	11	3	913	3	coactor
coater	8	43	2957	3	c_oater
cocreators	14	4	715	3	cocreators
codebtor	13	4	397	3	codebtor
coeditor	11	4	572	3	coeditor
coenamor	12	4	480	3	coenamor
cofactor	15	4	576	3	cofactor
collator	10	3	1037	3	collator
copastor	12	4	634	3	copastor
corrector	13	4	760	3	corrector
correlator	12	4	570	3	correlator
crabeater	13	4	559	3	crabeater
crafter	12	41	1133	3	crafter
cratch	13	41	1079	3	cr_atch
crate	7	65	3740	3	cr_at_e
crated	9	48	2777	3	cr_ated
craters	9	50	2189	3	cr_aters
crates	8	57	3606	3	cr_ates
cratons	9	43	1603	3	cr_atons
craver	11	46	1847	3	cr_aver
crayon	11	41	1000	3	cr_ayon
creak	11	54	1843	3	crea__k
creaked	14	34	1323	3	creaked
creakier	14	32	833	3	creakier
creaks	12	43	1596	3	crea_ks
creaky	15	49	1155	3	crea_ky
cream	9	57	2135	3	crea__m
creamed	12	39	1371	3	creamed
creamers	12	41	1131	3	creamers
creamery	15	38	598	3	creamery
creamier	12	31	906	3	creamier
creams	10	47	1525	3	crea_ms
creamy	13	48	1136	3	crea_my
crease	8	55	1957	3	crea_se
creased	10	43	1559	3	creased
creasers	10	36	1284	3	creasers
creases	9	40	2096	3	creases
creasier	10	32	1020	3	creasier
creasy	11	46	1230	3	crea_sy
creatine	10	34	1741	3	creatine
creating	11	39	2195	3	creating
creatins	10	36	1751	3	creatins
creations	11	26	1454	3	creations
creative	13	28	1280	3	creative
creatural	11	4	491	3	creatural
creatures	11	3	842	3	creatures
creditors	12	4	588	3	creditors
credo	8	48	1557	3	cre_do_
credos	9	46	1285	3	cre_dos
creeper	11	33	998	3	creeper
cremate	11	38	1618	3	cremat_e
cremated	13	34	1296	3	cremated
cremates	12	42	1601	3	cremates
cremation	13	5	1164	3	cremation
crematoria	14	5	531	3	crematoria
crenate	9	33	1711	3	crenat_e
crenated	11	30	1391	3	crenated
crenation	11	4	1292	3	crenation
crenature	11	4	576	3	crenature
creosol	9	4	605	3	creosol
crepier	11	3	975	3	crepier
crepon	10	3	994	3	cre_pon
crept	9	51	2589	3	crept__
cresol	8	3	1021	3	cre_sol
crest	7	46	3269	3	crest__
crestal	9	3	1213	3	crestal
crested	10	34	1655	3	crested
crests	8	52	1870	3	crest_s
cretic	10	28	1628	3	cre_tic
cretin	8	29	1791	3	cre_tin
critter	9	41	1303	3	critter
crittur	9	31	513	3	crittur
croaker	13	30	1068	3	croaker
crofter	12	29	957	3	crofter
croton	8	44	1545	3	cr_oton
crouton	9	4	713	3	crouton
cruor	7	3	1045	3	cr__uor
crypto	13	36	727	3	crypto_
cryptos	14	33	721	3	cryptos
cuatro	8	3	843	3	c_uatro
curators	10	3	1172	3	curators
debtor	9	3	833	3	_debtor
delator	8	30	1503	3	delator
dilator	8	27	1279	3	dilator
director	11	4	778	3	director
donator	8	3	1026	3	donator
dreamer	10	41	1084	3	dreamer
drear	6	50	1690	3	drea__r
eater	5	46	3984	3	__eater
ejector	16	37	860	3	ejector
elector	9	33	1326	3	elector
elevator	11	4	672	3	elevator
equator	16	3	748	3	equator
erecter	9	31	1339	3	erecter
erectors	10	35	1426	3	erectors
escheator	14	6	415	3	escheator
evertor	10	3	872	3	evertor
feater	9	52	2405	3	_feater
fetor	8	12	1453	3	_fe_tor
foetor	9	3	956	3	foe_tor
frater	9	45	2059	3	fr_ater
fretter	10	34	1275	3	fretter
gator	6	44	1604	3	__gator
grantor	8	40	1094	3	grantor
grater	7	46	2544	3	gr_ater
greaser	8	39	1308	3	greaser
great	6	60	3424	3	great__
greaten	8	36	1064	3	greaten
greatly	11	3	761	3	greatly
greats	7	63	1840	3	great_s
greeter	8	28	1267	3	greeter
gyrator	11	3	572	3	gyrator
heater	9	48	2830	3	_heater
hector	11	33	1265	3	_hector
heritor	10	3	1056	3	heritor
irater	6	52	1835	3	ir_ater
krater	10	40	1431	3	kr_ater
lector	8	35	1499	3	_lector
legator	8	30	1113	3	legator
levator	10	29	897	3	levator
locator	9	31	1042	3	locator
macerator	13	21	763	3	macerator
mentor	8	4	1436	3	_mentor
narrator	8	4	756	3	narrator
neater	6	44	2431	3	_neater
negator	8	30	1067	3	negator
nestor	6	37	1342	3	_nestor
nucleator	11	4	487	3	nucleator
ocreate	9	37	1174	3	ocreat_e
operator	10	3	1009	3	operator
orators	7	3	1382	3	or_ators
oratory	10	3	940	3	or_atory
permeator	13	4	740	3	permeator
pleater	9	39	1633	3	pleater
praetors	10	3	983	3	praetors
prater	8	48	2535	3	pr_ater
prealter	10	4	886	3	prealter
preaver	12	10	1161	3	preaver
precatory	16	4	912	3	precatory
predators	12	3	1009	3	predators
predatory	15	4	771	3	predatory
prefatory	17	4	669	3	prefatory
pressor	9	35	1288	3	pressor
prester	9	35	1962	3	prester
presto	8	42	1620	3	presto_
prestore	10	42	1735	3	prestore
prestos	9	37	1609	3	prestos
pretors	9	3	1681	3	pre_tors
procreator	14	6	574	3	~~pro~~creator
proctor	11	3	1043	3	proctor
pronator	10	3	1178	3	pronator
questor	16	14	663	3	questor
raptor	8	39	1282	3	_raptor
rater	5	49	4328	3	_r_ater
rato	4	54	3697	3	_r_ato_
ratos	5	55	2877	3	_r_atos
razor	14	30	1260	3	_r_azor
reactors	10	32	1229	3	_reactors
reader	7	36	2829	3	_reader
readorn	8	3	1048	3	_readorn
realer	6	35	2859	3	_realer
realter	7	37	1631	3	_realter
realtors	8	28	1168	3	_realtors
reamer	8	43	2521	3	_reamer
reaper	8	42	2314	3	_reaper
rear	4	56	4455	3	_rea__r
rearer	6	49	2891	3	_rearer
reason	6	26	1633	3	_reason
reata	5	42	2539	3	_reat_a
reatas	6	40	2102	3	_reatas
reaver	9	45	2473	3	_reaver
reavow	12	3	572	3	_reavow
rebater	9	35	1791	3	_rebater
rebato	8	37	1469	3	_rebato_
rebatos	9	29	1313	3	_rebatos
recto	7	45	2080	3	_recto_
rectors	9	35	2052	3	_rectors
rectory	12	35	1273	3	_rectory
rectos	8	57	1879	3	_rectos
redactor	11	4	703	3	_redactor
redtop	9	3	797	3	_redtop
relater	7	37	2314	3	_relater
relators	8	33	1614	3	_relators
renter	6	45	2741	3	_renter
rester	6	38	3243	3	_rester
restore	7	58	2298	3	_restore
retore	6	76	3077	3	_re_tore
retorn	6	109	2343	3	_re_torn
retort	6	68	3115	3	_re_tort
retro	5	50	2095	3	_re_tro
rhetor	9	3	806	3	_rhetor
rotator	7	3	1083	3	rotator
rotor	5	55	1973	3	_r_otor
screamer	12	26	788	3	screamer
seater	6	45	3416	3	_seater
secretor	10	4	568	3	secre_tor
sector	8	34	1593	3	_sector
senator	7	3	1307	3	senator
stator	6	40	1548	3	_stator
stentor	7	3	938	3	stentor
stertor	7	3	1009	3	stertor
sweater	10	37	1272	3	sweater
theater	10	40	1425	3	theater
toreador	9	4	500	3	toreador
tractor	9	3	1134	3	tractor
traitor	7	3	1012	3	traitor
treader	8	41	1383	3	treader
treason	7	4	876	3	treason
treat	5	62	4035	3	treat__
treated	8	36	1870	3	treated
treaters	8	36	1585	3	treaters
treats	6	48	2170	3	treat_s
treaty	9	44	1435	3	treat_y
treetop	9	4	552	3	treetop
tremor	8	42	1040	3	tre_mor
trustor	7	23	841	3	trustor
ureter	6	3	1320	3	ure_ter
urinator	8	4	784	3	urinator
vector	11	32	1206	3	_vector
viator	9	32	1184	3	_viator
wreaker	14	36	1004	3	wreaker
wreath	12	41	1119	3	wreat_h
wreathe	13	33	905	3	wreathe
wreather	14	26	860	3	wreather
wreaths	13	33	838	3	wreaths
wreathy	16	32	606	3	wreathy
wrester	10	28	1241	3	wrester

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.440	406115.9
2	DLD Change Limit	134027	317	6.936	19323.4
3	Display Results	317	317	0.110	2881.8
	(SQL Overall)	178691	317	7.486	23870.0