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 “caterers” 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.

349 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
caterers10281440(None) 
caperers122611721caperers
caterer92815941caterer_
cateress102311611cateress
waterers112312781waterers
alterers82512492alterers
banterers112410002banterers
barterers11269632barterers
batterers113110712batterers
caperer113013402caperer_
capturers1344632capturers
careerers1137242careerers
careers95218782care_ers
carers85133962ca__rers
catbriers1344142catbriers
catchers153114062catchers
caterans10313222caterans
catered103117772catere_d
caters85336502cat__ers
catheters1437012catheters
charterers15146052charterers
chatterers15205462chatterers
cheerers13319542cheerers
clatterers12155422clatterers
coherers132310732coherers
coverers132712122coverers
enterers82214152enterers
falterers12238032falterers
gatherers13156882gatherers
latherers12158852latherers
maturers1037372maturers
miterers10219682miterers
palterers11249532palterers
paperers122410452paperers
patterers112410122patterers
scatterers12205042scatterers
taperers10269772taperers
utterers8218652utterers
wagerers12247612wagerers
waterer103314072waterer_
waverers14318612waverers
acceders1334793acceders
actress948533act_ress
adherers1296923adherers
adorers84411733_adorers
aethers103614943_aethers
airers64922313_a_irers
alterer72713993alterer_
ameers84015573_ame_ers
amercers1256133_amercers
ateliers837883_ateliers
atoners75013953_atoners
averters11249513_averters
banterer102811773banterer_
barterer102711633barterer_
batchers153613273batchers
bathers124720363bat_hers
batteners11238163batteners
batterer102713213batterer_
batters94626013bat_ters
battlers104110973battlers
blatherers15175343blatherers
cabarets12268463cabarets
cabernets1345063cabernets
cabers105023923ca__bers
cablers114416713ca_blers
cacklers163710703cacklers
cadavers1435893cadavers
cadgers114712003ca_dgers
cadres94017933ca_dre_s
caesars9410733ca_esars
cagers95624193ca__gers
cahiers123510673ca_hiers
cajolers17267133cajolers
calenders1237403calenders
calibers1238523calibers
calipers1249443calipers
calkers134414693ca_lkers
callers94221963ca_llers
caloyers1337343caloyers
cambers134017443ca_mbers
cameleers1345093cameleers
cameras11313363camer_as
campers134220293ca_mpers
cancelers13247863cancelers
cancers114018583ca_ncers
candlers114214103candlers
caners84629203ca__ners
cankers134418753ca_nkers
canners93822663ca_nners
canoers94318373ca_noers
canteens1038573cante_ens
cantered113415983cantere_d
canters94827733ca_nters
capelets1268603capelets
capered123014043capere_d
capers105428143ca__pers
cappers134419403ca_ppers
capturer1246093capturer_
captures1239443capture_s
carders104820353ca_rders
careeners1138543careeners
careens94514703care_ens
career85822243care_er_
careerer1038583careerer_
careless102813633careless
carer74942333ca__rer_
cares77369183ca__re_s
caress85720263ca__ress
caressers1137443caressers
carets85330773ca__rets
carolers103314173carolers
carpers114521253ca_rpers
carrels95117303ca_rrels
carriers103614203carriers
carrs75730853ca__r_rs
carters95327253ca_rters
carvers124817543ca_rvers
casernes103810753casernes
caserns94711223caser_ns
cashiers13318883cashiers
casters94729903ca_sters
catarrh1245003catar_rh
catarrhs1344333catarrhs
catbrier1236173catbrier_
catcher143115823catcher_
catches144320773catche_s
catechus1544823catechus
category1443823category
catenary1346583catenary
catenas9313113cate_nas
cater74840723cat__er_
cateran9313773cater_an
cateresses1248353cateresses
catering112019903catering
cates75951893cat__e_s
catheter1338153catheter_
cathexes2036273cathexe_s
catnapers1364763catnapers
catteries11815523catteries
cattery123811603cat_tery
cattier93317073cattier_
catties94023053cattie_s
caulkers14375653caulkers
causers94014793ca_users
cauteries11615393cauteries
caverns124510253caver_ns
cavers115026843ca__vers
cavilers1348113cavilers
cavorters1434973cavorters
ceders93817673c__eders
ceres75540013c__ere_s
cereus85215523c__ereus
chafferers21153173chafferers
chamferers20153953chamferers
charterer14197323charterer_
chasteners1554793chasteners
chatterer14196843chatterer_
chatters134213953chat_ters
cheders134512393c_heders
cheepers15329013cheepers
cheerer123511753cheerer_
cheers114518913c_he_ers
chewers154111143c_hewers
cipherers1644893cipherers
citers85022983cit__ers
cithers124315773cit_hers
cithrens13355933cithrens
clamberers16174113clamberers
clamorers1345783clamorers
clatterer11186983clatterer_
clatters103313913clat_ters
clearers10349303clearers
coatdress1243193coatdress
coatees93816553coate_e_s
coaters93525793coat__ers
coercers1237653c_oercers
coherer122912783coherer_
coheres122917693cohere_s
colorers10312183colorers
corers85231073c__orers
coteries10422703coteries
cotters94323443cot_ters
cottiers10399153cottiers
coverer123113523coverer_
coveters132411083coveters
cozeners19297783cozeners
cratered1149683cratere_d
craterlets1243503craterlets
craters95021893crat__ers
creepers12318633creepers
cumberers15176003cumberers
cupelers1266733cupelers
curers84923193c__urers
cuteness1039673cuteness
cutlers94217003cut_lers
cutovers1335123cutovers
cutters94218963cut_ters
darers75921873da__rers
dateless9259963dateless
daters74827373dat__ers
detergers11147183detergers
deterrers10116593deterrers
dewaterers1442933dewaterers
ditherers13196683ditherers
eagerer8248823eagerer_
easterners1044823easterners
eateries8324313eateries
eaters65535953eat__ers
enterer72015633enterer_
fakeers14446673fake_ers
falterer11239853falterer_
farers95924053fa__rers
fasteners12237053fasteners
fathers133916503fat_hers
fatteners12236873fatteners
favorers1465493favorers
fetterers12267043fetterers
filterers12206973filterers
flatterers13175913flatterers
fosterers12238023fosterers
galeres83514333galere_s
gateless9279953gateless
gaters74728643gat__ers
gatherer12147903gatherer_
gathers114315073gat_hers
haeres94017033ha_ere_s
halteres113414593haltere_s
hammerers16216563hammerers
hamperers16287533hamperers
hankerers16226713hankerers
hasteners12267813hasteners
hatchers163113173hatchers
haters94930403hat__ers
hatreds11307813hat_reds
hatters104221523hat_ters
haverels14325753haverels
hoverers14289023hoverers
integers937783integers
jabberers2043553jabberers
jaegers15307103ja_egers
jeerers14328923_jeerers
labelers10249413labelers
laborers10208383laborers
lateeners945563lateeners
lateens74210553late_ens
lateness82614073lateness
laterals8312753laterals
latexes1438313latexe_s
latherer111310443latherer_
lathers104321883lat_hers
laveers10329363lave_ers
letterers9228113letterers
litterers9228193litterers
loiterers936263loiterers
manurers1037593manurers
marrers93414313ma_rrers
matchers153012433matchers
mateless102711293mateless
materiels1147833materiels
maters85032393mat__ers
matres84522233mat_re_s
matters94421753mat_ters
mattress1036533mattress
maturer938973maturer_
matures9314303mature_s
miterer92511333miterer_
mutterers11247373mutterers
natters73718063nat_ters
natures7311963nature_s
oaters65029793oat__ers
offerers1434933offerers
orderers9116563orderers
oysterers1245573oysterers
palterer102411273palterer_
pamperers15236863pamperers
panderers12229153panderers
paperer113111903paperer_
parers85530743pa__rers
parterres1148053parterres
pasturers1136393pasturers
patchers153413303patchers
paters84935833pat__ers
patterer103112173patterer_
patters94825193pat_ters
patzers184210573pat_zers
pesterers112510453pesterers
pewterers14216043pewterers
plasterers1286123plasterers
potterers11218663potterers
putterers11238363putterers
quarterers19124823quarterers
quaverers2143853quaverers
raters63936583rat__ers
ratteners9237263ratteners
ratters74422473rat_ters
rattlers83510293rattlers
ravelers113310863ravelers
raveners11309133raveners
retirers84311533retirers
reverers113113153reverers
sateens73710753sate_ens
satires72617573satire_s
saunterers1044383saunterers
savorers1157223savorers
scamperers1643473scamperers
scarers94618513sca__rers
scatterer11186293scatterer_
scatters103612753scat_ters
shatterers13185723shatterers
slaverers12165993slaverers
smatterers12174873smatterers
sneerers8309803sneerers
starers74522313_starers
steerers82511353steerers
steers63820983_ste_ers
stereos74314973_stereos
steres63929533_stere_s
storers75018683_storers
taborers10268333taborers
tamperers13227313tamperers
taperer92511793taperer_
taters64932203tat__ers
tatters74520483tat_ters
tattlers8369693tattlers
taverners1244273taverners
tearers75218233__tearers
termers95414503__termers
titterers9236993titterers
totterers9186813totterers
utterer71910463utterer_
vaporers1336243vaporers
wagerer11328493wagerer_
wakeners1535843wakeners
wanderers13228483wanderers
watchers163511793watchers
waterbeds1544883waterbeds
waterbus1345863waterbus
watered113014953watere_d
waterhens1574963waterhens
waterier11312083waterier_
waterjets1944463waterjets
waterless1238013waterless
waters95030633wat__ers
waverer13319523waverer_
winterers12209723winterers
witherers15146843witherers
yammerers16214453yammerers
yatters103914623yat_ters

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.453394461.4
2DLD Change Limit1461623496.65621959.4
3Display Results3493490.1402492.9
 (SQL Overall)1786913497.24924650.4
 
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.