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
creators10281440(None) 
creator93714431creator_
cremators1369801cremators
aerators8315612aerators
caveators1497262caveators
cheaters133613512cheaters
chelators1448162chelators
citators10310252citators
cocreators1447132cocreators
craters95021892cr_aters
cratons94316032cr_atons
creamers124111302creamers
creasers103612822creasers
creates95225192creat_es
creatins103617512creatins
creations112614542creations
creature1038722creature
creatures1138412creatures
creditors1245862creditors
cremator1269172cremator_
crematory1647192crematory
curators10311722curators
erectors103514252erectors
orators7313822or_ators
praetors1039832praetors
predators12310082predators
pretors9316802pre_tors
reactors103212282_reactors
realtors82811682_realtors
rectors93520512_rectors
relators83316122_relators
treaters83615842treaters
abators94413083_abators
abettors1056133abettors
ablators1069873ablators
accentors13116043accentors
acceptors15114783acceptors
actuators1146443actuators
aerator7314843aerator_
aleatory1148813aleatory
arrestors958023arrestors
aviators11169903aviators
barrators1148393barrators
beaters94925043_beaters
bettors93312473_bettors
bleaters103412323bleaters
breakers143810973breakers
breathers14319103breathers
breathes134212903breathes
breaths124411183breat_hs
cantors94620753c_antors
captors113914983c_aptors
castors94919443c_astors
caters85336503c__aters
caveator1387233caveator_
censors93611833c_ensors
centers94420603c_enters
centos85920463c_ento_s
cerates95428253cerat_es
ceratins102818733ceratins
ceratodus1243223ceratodus
ceratoid1149923ceratoid
cestos84718093c_esto_s
chadors1338753c_hadors
chantors133710263chantors
cheapos14418513cheapo_s
cheater124816963cheater_
cheats114519543cheat__s
chelator1347913chelator_
citator9310123citator_
citatory1347213citatory
clamors11710093c_lamors
cleaners103610543cleaners
clearers10349303clearers
clears84116563clea__rs
cleats84919313cleat__s
cleavers13398873cleavers
coactors1239473coactors
coaters93525793c_oaters
cocreator1346953cocreator_
codebtors1444403codebtors
coeditors1245803coeditors
coenamors1344703coenamors
cofactors1645933cofactors
collators11410343collators
copastors1346993copastors
correctors1447493correctors
correlators1345593correlators
crabeaters1444503crabeaters
crafters13419953crafters
crater85026643cr_ater_
crates85736063cr_at_es
craton84517193cr_ato_n
cravers124416553cr_avers
crayons12439233cr_ayons
creaks124315963crea__ks
creamer113714083creamer_
creamery15385973creamery
creams104715253crea__ms
creaser94415723creaser_
creases94020963crea_ses
create85126373creat__e
created104323443creat_ed
creatin93618133creat_in
creatine103417413creatine
creatines112814433creatines
creating113921953creating
creation102816513creation
creative132812803creative
creatives14279693creatives
creatural1144903creatural
creditor1145893creditor_
credos94612843cre_do_s
creepers12318623creepers
cremates124216003cremat_es
cremations14410713cremations
crematoria1455293crematoria
crematories1546853crematories
crenations12511693crenations
crenature1145753crenature
crenatures1245333crenatures
creosols1045713creosols
crepons1139313cre_pons
cresols939643cre_sols
crests85218703crest__s
cretics112911653cre_tics
cretins93216423cre_tins
critters103511323critters
critturs10374593critturs
croakers14288523croakers
crofters13358903crofters
crotons93714373cr_otons
croutons1036753croutons
cruors838633cr__uors
cryptos14337213crypto_s
cuatros938273c_uatros
curator9312213curator_
debtors1038533_debtors
delators92314823delators
dilators93213193dilators
directors1248133directors
donators9310403donators
dreamers11369003dreamers
drears74614253drea__rs
eaters65535953__eaters
ejectors17328663ejectors
electors103013843electors
elevators1246303elevators
equators1737473equators
erecters102611613erecters
erector93513803erector_
escheators1574183escheators
evertors1138953evertors
fetors91014473_fe_tors
foetors1039763foe_tors
fraters103517213fr_aters
fretters113410303fretters
gators74115833__gators
grantors93810353grantors
graters85419743gr_aters
greasers93410253greasers
greatens9307593greatens
greater84416493greater_
greats76318393great__s
greeters92610113greeters
gyrators1245993gyrators
heaters104225223_heaters
hectors123513263_hectors
heritors11310903heritors
kraters114212343kr_aters
lectors93415763_lectors
legators92811033legators
levators11249283levators
locators102910433locators
macerators14167483macerators
mentors9314993_mentors
narrators947863narrators
negators92411173negators
nestors73614973_nestors
nucleators1244593nucleators
operators11410753operators
orator6314533or_ator_
oratory1039403or_atory
permeators1447403permeators
pleaters103613793pleaters
praetor938973praetor_
praters94921653pr_aters
prealters1147773prealters
preavers13910263preavers
precatory1649113precatory
predator11310053predator_
predatory1547703predatory
prefatory1746683prefatory
pressors103212683pressors
presters103419003presters
prestore104217343prestore
prestores114716083prestores
prestos93716083presto_s
pretor8315743pre_tor_
procreators1575713procreators
proctors12311513proctors
pronators11411303pronators
questors17147013questors
raptors94213353_raptors
raters63936583_r_aters
ratos55528763_r_ato_s
razors154711663_r_azors
reactor93011653_reactor_
readers83823773_readers
readorn8310473_readorn
readorns938283_readorns
realters83614043_realters
realtor73611353_realtor_
reamers94221083_reamers
reapers93520453_reapers
rearers74323563_rearers
rears54739653_rea__rs
reasons72514943_reasons
reatas64021013_reat_as
reavers108320743_reavers
reavows1335273_reavows
rebaters103413943_rebaters
rebatos92913113_rebato_s
rector84019743_rector_
rectory123512723_rectory
rectos85718783_recto_s
redactors1247533_redactors
redtops1037373_redtops
relaters83218153_relaters
relator74016363_relator_
renters74224813_renters
resters74130403_resters
restore75822973_restore
restores85222993_restores
retore67630763_re_tore
retorn610923423_re_torn
retort66831143_re_tort
retorts76016513_re_torts
retros63820193_re_tros
rhetors1038513_rhetors
rotators8310203rotators
rotors64917953_r_otors
screamers13236253screamers
seaters74028943_seaters
secretors1145833secre_tors
sectors93116443_sectors
senators8312953senators
stators73915583_stators
stentors839733stentors
stertors8310923stertors
sweaters113811063sweaters
theaters114211903theaters
toreadors1045143toreadors
tractors10312563tractors
traitors8310793traitors
treaders93311843treaders
treasons848683treasons
treater74219833treater_
treaties8316983treaties
treats64821693treat__s
treetops1045463treetops
tremors93711223tre_mors
trustors8268913trustors
ureters7311823ure_ters
urinators947633urinators
vectors123212593_vectors
viators102712023_viators
wreakers15328423wreakers
wreathers15257493wreathers
wreathes14299893wreathes
wreaths13338373wreat_hs
wresters112711733wresters

Search took 8 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.1561145455.1
2DLD Change Limit1461622726.93621073.0
3Display Results2722720.0932924.7
 (SQL Overall)1786912727.18524870.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.