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

497 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
caterer9281594(None) 
caperer113013401caperer
catered103117771catered
caterers102814401caterers
waterer103314071waterer
alterer72713992alterer
banterer102811772banterer
barterer102711632barterer
batterer102713212batterer
cantered113415982cantered
capered123014042capered
caperers122611722caperers
capturer1246092capturer
career85822242care_er
careerer1038582careerer
carer74942332ca__rer
catbrier1236172catbrier
catcher143115822catcher
cater74840722cat__er
cateran9313772cateran
cateress102311612cateress
caters85336502cater_s
catheter1338152catheter
cattier93317072cattier
charterer14197322charterer
chatterer14196842chatterer
cheerer123511752cheerer
clatterer11186982clatterer
coherer122912782coherer
coverer123113522coverer
cratered1149682cratered
eagerer8248822eagerer
enterer72015632enterer
falterer11239852falterer
gatherer12147902gatherer
latherer111310442latherer
maturer938972maturer
miterer92511332miterer
palterer102411272palterer
paperer113111902paperer
patterer103112172patterer
scatterer11186292scatterer
taperer92511792taperer
utterer71910462utterer
wagerer11328492wagerer
watered113014952watered
waterers112312782waterers
waterier11312082waterier
waverer13319522waverer
acceder1235353acceder
acerber1135243_acerber
adherer1137573adherer
adorer74713453_adorer
aerier64823153_a_erier
aether94213673_aether
airer54927893_a_irer
alerter72111513_alerter
altered83215733altered
alterers82512493alterers
ameer75618983_ame_er
amercer1146373_amercer
atelier7311623_atelier
atoner64817193_atoner
austerer838383austerer
averter102410553_averter
bantered113313633bantered
banterers112410003banterers
barer74535803ba__rer
bartered113113013bartered
barterers11269633barterers
batcher144414853batcher
bather115322513bat_her
battener10369393battener
batter84928873bat_ter
battered113315053battered
batterers113110713batterers
battier93515713battier
battler94113383battler
bitterer10309773bitterer
blatherer14176713blatherer
cabaret112519043cabaret
caber95126833ca__ber
cabernet12410763cabernet
cabers105023923caber_s
cabler104519173ca_bler
cackler153812573cackler
cadaver1335783cadaver
cadger105013903ca_dger
cadre85419023ca_dre_
cadres94017933ca_dres
caesar8410933ca_esar
cager85229223ca__ger
cagers95624193cager_s
cagier93715933ca_gier
cahier113615773ca_hier
cajoler16398393cajoler
cakier123115243ca_kier
calender1138273calender
caliber1139733caliber
caliper11410963caliper
calker124917083ca_lker
caller85125483ca_ller
calmer105216933ca_lmer
caloyer1238143caloyer
camber124418483ca_mber
cambered15129003cambered
cameleer1246033cameleer
cameoed1238383cameoed
camera10313693camer_a
camerae11312063camerae
cameral11311283cameral
cameras11313363cameras
camper124722213ca_mper
campier133313273campier
canceler12238913canceler
cancer104220923ca_ncer
cancered132411553cancered
candler103516593candler
caner75334773ca__ner
caners84629203caner_s
canker124422523ca_nker
cankered153010223cankered
canner84625983ca_nner
cannier94014163cannier
canoer85121073ca_noer
canteen9411083cante_en
canter85230113ca_nter
canters94827733canter_s
capelet11517073capelet
caper94831623ca__per
capers105428143caper_s
capper124421983ca_pper
capture1138913capture_
captured1336573captured
capturers1344633capturers
captures1239443captures
carder94524183ca_rder
care66968373ca__re_
cared86050093ca__red
careen84119493care_en
careener1039323careener
careered1139493careered
careerers1137243careerers
careers95218783careers
carefree1346343carefree
carers85133963carer_s
cares77369183ca__res
caresser1038803caresser
caret75360563ca__ret
carex144822303ca__rex
caroler93816753caroler
carper104923633ca_rper
carr65434703ca__r_r
carrel84718633ca_rrel
carrier93619583carrier
carter84932273ca_rter
carters95327253carter_s
carver114420143ca_rver
casern84713313caser_n
caserne93710063caserne
casernes103810753casernes
caserns94711223caserns
cashier123713323cashier
caster85232573ca_ster
casters94729903caster_s
catarrh1245003catarrh
catbriers1344143catbriers
catchers153114063catchers
catches144320773catches
catchier15329863catchier
cate66254603cat__e_
catechu1444473catechu
category1443823category
catena8312483cate_na
catenae9311373catenae
catenary1346583catenary
catenas9313113catenas
caterans10313223caterans
catering112019903catering
cates75951893cat__es
catheters1437013catheters
cathexes2036273cathexes
catnaper1294933catnaper
catted95422473cat_ted
catteries11815523catteries
cattery123811603catter_y
cattie85221023cattie_
catties94023053catties
cattle85118903cattle_
caulker13456893caulker
causer84117783ca_user
cauteries11615393cauteries
cautery12349593cauter_y
cavemen1437143cavemen
caver105629063ca__ver
cavern115312453caver_n
caverned1436163caverned
caverns124510253caverns
cavers115026843caver_s
caviler1249063caviler
cavorter1335783cavorter
ceder85322233c__eder
centered112513523centered
cere66741473c__ere_
cered85227443c__ered
ceres75540013c__eres
chafferer20133923chafferer
chamferer19154693chamferer
chaptered17176793chaptered
chartered15158393chartered
charterers15146053charterers
chastener1445703chastener
chatter124416643chat_ter
chattered15197993chattered
chatterers15205463chatterers
chattier1337513chattier
cheder125113493c_heder
cheeper143610743cheeper
cheer105420383c_he_er
cheered133713293cheered
cheerers13319543cheerers
cheerier1348003cheerier
chewer145512613c_hewer
chiefer1536863chiefer
cipherer1545573cipherer
citer74827333cit__er
citers85022983citer_s
cither114616683cit_her
cithren12306593cithren
clamberer15185273clamberer
clamorer1236903clamorer
clatter94014973clat_ter
clattered12178403clattered
clatterers12155423clatterers
clavered14187633clavered
clearer93710823clearer
clever114611533c_lever
cleverer1334563cleverer
coatee84327223coate_e_
coatees93816553coate_es
coater84329573coat__er
coaters93525793coater_s
coercer1138383c_oercer
cohere112716993cohere_
cohered133514693cohered
coherers132310733coherers
coheres122917693coheres
colorer9312523colorer
corer75538873c__orer
coterie9417403coterie
coteries10422703coteries
cotter84926673cot_ter
cottered112511733cottered
cottier93814173cottier
covered133315293covered
coverers132712123coverers
coveter122912063coveter
cowered133214643cowered
cozener18328953cozener
crater85026643crat__er
craterlet1148413craterlet
craters95021893crater_s
creeper11339973creeper
crueler939023crueler
cumberer14266993cumberer
cupeler1177483cupeler
curer75030753c__urer
cuter74728233cut__er
cutesier1045623cutesier
cutler84718033cut_ler
cutover1235283cutover
cutter84521003cut_ter
dapperer1335763dapperer
darer65230793da__rer
dater65332313dat__er
daters74827373dater_s
deterger10147593deterger
deterrer9137013deterrer
dewaterer1343713dewaterer
ditherer12187763ditherer
easterner945053easterner
eater54639843eat__er
eateries8324313eateries
eaters65535953eater_s
eatery95316353eater_y
entered82718883entered
enterers82214153enterers
fairer95212063fa_irer
fakeer13378743fake_er
faltered122810983faltered
falterers12238033falterers
farer86733143fa__rer
fastener11227833fastener
father125116713fat_her
fathered151510433fathered
fattener11268113fattener
fatter94523213fat_ter
fattier103513463fattier
favorer1355883favorer
fetterer11207813fetterer
filterer11258143filterer
flatterer12187673flatterer
fosterer11239523fosterer
galere73716673galere_
galeres83514333galeres
gartered10319583gartered
gatemen1047603gatemen
gater64533653gat__er
gaters74728643gater_s
gather104115853gat_her
gathered13149373gathered
gatherers13156883gatherers
haeres94017033ha_eres
haltere103614703haltere_
haltered123112553haltered
halteres113414593halteres
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
hastener11259133hastener
hatcher153314723hatcher
hater85034753hat__er
haters94930403hater_s
hatred104814333hat_red
hatter94724873hat_ter
havered144011453havered
haverel13397153haverel
hoverer13319823hoverer
integer837993integer
jabberer1944023jabberer
jaeger14397193ja_eger
jeerer13389933_jeerer
labeler92310183labeler
laborer9249503laborer
lagered92311153lagered
lateen64014863late_en
lateener835763lateener
latened8711923latened
later54843923lat__er
laterad8310843laterad
lateral7313573lateral
latexes1438313latexes
lather95124353lat_her
lathered121512323lathered
latherers12158853latherers
lathier10310833lathier
latter65027893lat_ter
laveer94110423lave_er
layered11259413layered
letterer8259223letterer
litterer82810173litterer
loiterer837083loiterer
manurer938583manurer
marrer83716673ma_rrer
mastered112614003mastered
matcher143214283matcher
mater74438863mat__er
materiel10311253materiel
maters85032393mater_s
matier84321523mat_ier
matres84522233mat_res
matter84325343mat_ter
mattered112412903mattered
mature8313463mature_
matured10310033matured
maturers1037373maturers
matures9314303matures
merer75126233__merer
metered103514013metered
mitered103213233mitered
miterers10219683miterers
mutterer10218913mutterer
nakeder1254363nakeder
natter64420743nat_ter
nattered92011623nattered
nattier73614623nattier
nature6311263nature_
natured838963natured
natures7311963natures
oater55433733oat__er
oaters65029793oater_s
offerer1335543offerer
oftener1035923oftener
orderer8127943orderer
oysterer1136103oysterer
paltered113012483paltered
palterers11249533palterers
pamperer14228333pamperer
panderer112210913panderer
papered122513163papered
paperers122410453paperers
parer75839903pa__rer
parterre1036983parterre
pasturer1037523pasturer
patcher143515143patcher
pater74740723pat__er
paters84935833pater_s
patter84628263pat_ter
pattered112714203pattered
patterers112410123patterers
patzer173111643pat_zer
pesterer102412703pesterer
petered103314963petered
pewterer13256313pewterer
plasterer1178103plasterer
potterer102310263potterer
putterer10209913putterer
quarterer18145713quarterer
quaverer2054583quaverer
queerer16106503queerer
raftered1237663raftered
rarer54731703ra__rer
rater54943283rat__er
raters63936583rater_s
rather94319743rat_her
rattener8238533rattener
ratter64326313rat_ter
rattier74015593rattier
rattler74012743rattler
raveler104212463raveler
ravener104110733ravener
retirer74715013retirer
reverer103815833reverer
sabered103213023sabered
sateen63815013sate_en
satire63218003satire_
satires72617573satires
saunterer945033saunterer
savorer1057883savorer
scamperer1544623scamperer
scareder1135783scareder
scarer84524603sca__rer
scatter93815173scat_ter
scattered12197353scattered
scatterers12205043scatterers
scattier10267583scattier
serer55935503__serer
severer103511563severer
shatterer12177203shatterer
sheerer103813843sheerer
slaverer11196993slaverer
smatterer11185813smatterer
sneerer73512313sneerer
soberer93110353soberer
starer64027363_starer
steer55423863_ste_er
steerer73113633steerer
stere55328543_stere_
stereo65317913_stereo
steres63929533_steres
sterner7411913_sterner
storer64721673_storer
tabered103311593tabered
taborer9269293taborer
tamperer12248893tamperer
tapered102612933tapered
taperers10269773taperers
tater54138613tat__er
taters64932203tater_s
tatter64024573tat_ter
tattered92011443tattered
tattier74216243tattier
tattler73112213tattler
taverner1134423taverner
tearer64822903__tearer
termer85717253__termer
terser67317823__terser
titterer8268523titterer
totterer8217793totterer
uncatered1237403uncatered
uttered82712433uttered
utterers8218653utterers
vaporer1236983vaporer
wafered14288433wafered
wagered12299333wagered
wagerers12247613wagerers
waitered1238753waitered
wakener1446913wakener
wanderer122210123wanderer
watcher153113403watcher
water84733313wat__er
waterbed1436443waterbed
waterhen1485303waterhen
waterjet1848293waterjet
watermen1377613watermen
waters95030633water_s
watery123914493water_y
watter93221983wat_ter
wavered142910433wavered
waverers14318613waverers
whatever1742673whatever
winterer112110443winterer
witherer14187953witherer
yammerer15225483yammerer
yarer84321573ya__rer
yatter94116213yat_ter
yattered12239533yattered

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274977.36018210.2
3Display Results4974970.1862672.0
 (SQL Overall)1786914977.70223200.6
 
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.