Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

Here are the results of your fuzzy-string dictionary search for “creators” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

272 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
creators10281442(None) 
creator93714451creator_
cremators1369831cremators
aerators8315622aerators
caveators1497262caveators
cheaters133613512cheaters
chelators1448172chelators
citators10310252citators
cocreators1447152cocreators
craters95021892cr_aters
cratons94316032cr_atons
creamers124111312creamers
creasers103612842creasers
creates95225212creat_es
creatins103617512creatins
creations112614542creations
creature1038742creature
creatures1138422creatures
creditors1245882creditors
cremator1269202cremator_
crematory1647222crematory
curators10311722curators
erectors103514262erectors
orators7313822or_ators
praetors1039832praetors
predators12310092predators
pretors9316812pre_tors
reactors103212292_reactors
realtors82811682_realtors
rectors93520522_rectors
relators83316142_relators
treaters83615852treaters
abators94413103_abators
abettors1056143abettors
ablators1069893ablators
accentors13116063accentors
acceptors15114813acceptors
actuators1146443actuators
aerator7314853aerator_
aleatory1148833aleatory
arrestors958043arrestors
aviators11169923aviators
barrators1148403barrators
beaters94925043_beaters
bettors93312473_bettors
bleaters103412323bleaters
breakers143810973breakers
breathers14319113breathers
breathes134212913breathes
breaths124411203breat_hs
cantors94620753c_antors
captors113914983c_aptors
castors94919443c_astors
caters85336503c__aters
caveator1387233caveator_
censors93611843c_ensors
centers94420603c_enters
centos85920463c_ento_s
cerates95428253cerat_es
ceratins102818733ceratins
ceratodus1243223ceratodus
ceratoid1149923ceratoid
cestos84718093c_esto_s
chadors1338753c_hadors
chantors133710263chantors
cheapos14418513cheapo_s
cheater124816963cheater_
cheats114519543cheat__s
chelator1347923chelator_
citator9310123citator_
citatory1347213citatory
clamors11710093c_lamors
cleaners103610543cleaners
clearers10349303clearers
clears84116563clea__rs
cleats84919313cleat__s
cleavers13398873cleavers
coactors1239483coactors
coaters93525793c_oaters
cocreator1346973cocreator_
codebtors1444403codebtors
coeditors1245803coeditors
coenamors1344703coenamors
cofactors1645943cofactors
collators11410343collators
copastors1346993copastors
correctors1447503correctors
correlators1345603correlators
crabeaters1444503crabeaters
crafters13419953crafters
crater85026643cr_ater_
crates85736063cr_at_es
craton84517193cr_ato_n
cravers124416563cr_avers
crayons12439233cr_ayons
creaks124315963crea__ks
creamer113714093creamer_
creamery15385983creamery
creams104715253crea__ms
creaser94415743creaser_
creases94020963crea_ses
create85126383creat__e
created104323463creat_ed
creatin93618133creat_in
creatine103417413creatine
creatines112814433creatines
creating113921953creating
creation102816513creation
creative132812803creative
creatives14279693creatives
creatural1144913creatural
creditor1145913creditor_
credos94612853cre_do_s
creepers12318633creepers
cremates124216013cremat_es
cremations14410713cremations
crematoria1455313crematoria
crematories1546863crematories
crenations12511693crenations
crenature1145763crenature
crenatures1245343crenatures
creosols1045723creosols
crepons1139323cre_pons
cresols939653cre_sols
crests85218703crest__s
cretics112911653cre_tics
cretins93216423cre_tins
critters103511333critters
critturs10374593critturs
croakers14288523croakers
crofters13358913crofters
crotons93714373cr_otons
croutons1036753croutons
cruors838643cr__uors
cryptos14337213crypto_s
cuatros938273c_uatros
curator9312213curator_
debtors1038533_debtors
delators92314833delators
dilators93213203dilators
directors1248143directors
donators9310403donators
dreamers11369003dreamers
drears74614253drea__rs
eaters65535953__eaters
ejectors17328663ejectors
electors103013863electors
elevators1246313elevators
equators1737473equators
erecters102611613erecters
erector93513813erector_
escheators1574193escheators
evertors1138953evertors
fetors91014473_fe_tors
foetors1039763foe_tors
fraters103517213fr_aters
fretters113410303fretters
gators74115843__gators
grantors93810363grantors
graters85419743gr_aters
greasers93410253greasers
greatens9307593greatens
greater84416493greater_
greats76318403great__s
greeters92610123greeters
gyrators1246003gyrators
heaters104225223_heaters
hectors123513263_hectors
heritors11310903heritors
kraters114212343kr_aters
lectors93415773_lectors
legators92811033legators
levators11249293levators
locators102910433locators
macerators14167483macerators
mentors9314993_mentors
narrators947863narrators
negators92411173negators
nestors73614973_nestors
nucleators1244593nucleators
operators11410753operators
orator6314533or_ator_
oratory1039403or_atory
permeators1447403permeators
pleaters103613793pleaters
praetor938973praetor_
praters94921653pr_aters
prealters1147773prealters
preavers13910263preavers
precatory1649123precatory
predator11310063predator_
predatory1547713predatory
prefatory1746693prefatory
pressors103212693pressors
presters103419003presters
prestore104217353prestore
prestores114716083prestores
prestos93716093presto_s
pretor8315753pre_tor_
procreators1575713procreators
proctors12311513proctors
pronators11411303pronators
questors17147013questors
raptors94213353_raptors
raters63936583_r_aters
ratos55528773_r_ato_s
razors154711663_r_azors
reactor93011663_reactor_
readers83823773_readers
readorn8310483_readorn
readorns938283_readorns
realters83614043_realters
realtor73611353_realtor_
reamers94221083_reamers
reapers93520453_reapers
rearers74323563_rearers
rears54739653_rea__rs
reasons72514943_reasons
reatas64021023_reat_as
reavers108320743_reavers
reavows1335273_reavows
rebaters103413943_rebaters
rebatos92913133_rebato_s
rector84019753_rector_
rectory123512733_rectory
rectos85718793_recto_s
redactors1247543_redactors
redtops1037373_redtops
relaters83218153_relaters
relator74016383_relator_
renters74224823_renters
resters74130403_resters
restore75822983_restore
restores85222993_restores
retore67630773_re_tore
retorn610923433_re_torn
retort66831153_re_tort
retorts76016513_re_torts
retros63820193_re_tros
rhetors1038513_rhetors
rotators8310203rotators
rotors64917953_r_otors
screamers13236263screamers
seaters74028943_seaters
secretors1145843secre_tors
sectors93116453_sectors
senators8312953senators
stators73915583_stators
stentors839753stentors
stertors8310933stertors
sweaters113811063sweaters
theaters114211903theaters
toreadors1045153toreadors
tractors10312573tractors
traitors8310793traitors
treaders93311843treaders
treasons848683treasons
treater74219833treater_
treaties8316983treaties
treats64821703treat__s
treetops1045463treetops
tremors93711233tre_mors
trustors8268913trustors
ureters7311823ure_ters
urinators947633urinators
vectors123212593_vectors
viators102712033_viators
wreakers15328423wreakers
wreathers15257493wreathers
wreathes14299893wreathes
wreaths13338383wreat_hs
wresters112711733wresters

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.420425454.8
2DLD Change Limit1461622728.00018270.3
3Display Results2722720.1102472.7
 (SQL Overall)1786912728.53020948.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.