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

452 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
waterer10331407(None) 
caterer92815941caterer
wagerer11328491wagerer
watered113014951watered
waterers112312781waterers
waterier11312081waterier
waverer13319521waverer
alterer72713992alterer
banterer102811772banterer
barterer102711632barterer
batterer102713212batterer
caperer113013402caperer
catered103117772catered
caterers102814402caterers
dewaterer1343712dewaterer
eagerer8248822eagerer
enterer72015632enterer
falterer11239852falterer
gatherer12147902gatherer
latherer111310442latherer
maturer938972maturer
miterer92511332miterer
palterer102411272palterer
paperer113111902paperer
patterer103112172patterer
taperer92511792taperer
utterer71910462utterer
wafered14288432wafered
wagered12299332wagered
wagerers12247612wagerers
waitered1238752waitered
wakener1446912wakener
wanderer122210122wanderer
watcher153113402watcher
water84733312wat__er
waterbed1436442waterbed
waterhen1485302waterhen
waterjet1848292waterjet
watermen1377612watermen
waters95030632water_s
watery123914492water_y
watter93221982wat_ter
wavered142910432wavered
waverers14318612waverers
whatever1742672whatever
winterer112110442winterer
witherer14187952witherer
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
awakener1543433awakener
bantered113313633bantered
banterers112410003banterers
barer74535803ba__rer
bartered113113013bartered
barterers11269633barterers
batcher144414853batcher
bather115322513bat_her
battener10369393battener
batter84928873bat_ter
battered113315053battered
batterers113110713batterers
battier93515713battier
battler94113383battler
bitterer10309773bitterer
blatherer14176713blatherer
cantered113415983cantered
capered123014043capered
caperers122611723caperers
capturer1246093capturer
career85822243care_er
careerer1038583careerer
carer74942333ca__rer
catbrier1236173catbrier
catcher143115823catcher
cater74840723cat__er
cateran9313773cateran
cateress102311613cateress
caters85336503cater_s
catheter1338153catheter
cattier93317073cattier
charterer14197323charterer
chatterer14196843chatterer
cheerer123511753cheerer
clatterer11186983clatterer
coherer122912783coherer
coverer123113523coverer
cratered1149683cratered
dapperer1335763dapperer
darer65230793da__rer
dater65332313dat__er
daters74827373dater_s
deterger10147593deterger
deterrer9137013deterrer
dewatered1444743dewatered
dewaterers1442933dewaterers
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
scatterer11186293scatterer
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
swaggerer1442943swaggerer
swather134213603swat_her
swatter104113323swat_ter
tabered103311593tabered
taborer9269293taborer
tamperer12248893tamperer
tapered102612933tapered
taperers10269773taperers
tater54138613tat__er
taters64932203tater_s
tatter64024573tat_ter
tattered92011443tattered
tattier74216243tattier
tattler73112213tattler
taverner1134423taverner
tearer64822903__tearer
termer85717253__termer
terser67317823__terser
titterer8268523titterer
totterer8217793totterer
twitterer1243303twitterer
unwatered1345683unwatered
uttered82712433uttered
utterers8218653utterers
vaporer1236983vaporer
wabbler143511923wabbler
wacker154920123wa_cker
wackier16369733wackier
wadder114215483wa_dder
waddler124010793waddler
wader95325363wa__der
waders109120643wader_s
wafer114417643wa__fer
wafers124316143wafer_s
wafery15398693wafer_y
waffler16377783waffler
wafter124114613wa_fter
wafters134112813wafter_s
wafture1334853wafture_
waftures1434853waftures
wager95925053wa__ger
wagers105122203wager_s
wagger113616013wa_gger
wagoner1136093wagoner
wailer93720323wa_iler
waired106015833wa_ired
waister103812383waister
waiter94321253wa_iter
waiters104218623waiter_s
waiver124212713wa_iver
wakened1546873wakened
wakeners1535843wakeners
waker125526593wa__ker
wakers134822493waker_s
waler84229263wa__ler
walers94824463waler_s
walker133913993wa_lker
waltzer1934383waltzer
wander104423713wa_nder
wandered132110793wandered
wanderers13228483wanderers
wangler113312653wangler
wanier93920683wa_nier
wanker134219973wa_nker
wanner94019623wa_nner
wanter94423053wa_nter
wanters104420093wanter_s
wantoner1187563wantoner
warbler123211463warbler
warder104020273wa_rder
ware76254723wa__re_
wared96339873wa__red
wares88250583wa__res
warier93722893wa_rier
warmer113816733wa_rmer
warner93717223wa_rner
warper114015583wa_rper
warred104019843wa_rred
warren95012853wa_rren
warrener1136913warrener
warsler10289893warsler
wartier103413913wartier
washer124720393wa_sher
washier133611153washier
waspier12259053waspier
waster95228943wa_ster
wasterie111211583wasterie
wasteries121115343wasteries
wasters104026593waster_s
wastery134610993waster_y
wastrel1037553wastrel
watape11208483watape_
watapes12228383watapes
watched163012823watched
watchers163511793watchers
watches153017373watches
waterage1248663waterage
waterages1349383waterages
waterbeds1544883waterbeds
waterbird1554503waterbird
waterbus1345863waterbus
waterdog1344453waterdog
waterhead1644393waterhead
waterhens1574963waterhens
wateriest12312233wateriest
waterily1438783waterily
watering122316313watering
waterish14310533waterish
waterjets1944463waterjets
waterleaf1543703waterleaf
waterless1238013waterless
waterlog1245043waterlog
waterloo1145723waterloo
waterman1397283waterman
watermark1844123watermark
waterpower1854083waterpower
watershed1644633watershed
waterski1543223waterski
waterway1745563waterway
waterweed1644623waterweed
waterwork1946643waterwork
waterworn1546173waterworn
wattle94314213wattle_
wattled113610503wattled
wattles103814073wattles
wattmeter1443723wattmeter
wavelet13310943wavelet
waver115025703wa__ver
wavers125022473waver_s
wavery154610053waver_y
wavier124613083wa_vier
waxer154317483wa__xer
waxers164014303waxer_s
waxier16439903wa_xier
wayfarer1742923wayfarer
weakener1534913weakener
wearer94319403w_earer
weather133513223weat_her
weathered16168513weathered
weber10313523w__eber
weeder103315513w_eeder
weeper114313303w_eeper
weer75535093w__e_er
weever123811443w_eever
weltered12238433weltered
were76238333w__ere_
westered122511863westered
westerner1244953westerner
wether123315393wet_her
wetter93919443wet_ter
wheeler13298773wheeler
wheezer22296673wheezer
where117019423w_here_
wheres125917433w_heres
whether16346623whether
whetter13348803whetter
whitener1435733whitener
whoever1634103whoever
widener11318693widener
wiener94513543w_iener
wintered122111573wintered
winterers12209723winterers
winterier1238333winterier
wirer85124953w__irer
wither124321353wit_her
withered15169433withered
witherers15146843witherers
withier132910493withier
wittier103910823wittier
wonderer12249183wonderer
wrathier1435903wrathier
wuther124511613wut_her
wuthered15157433wuthered
yammerer15225483yammerer
yarer84321573ya__rer
yatter94116213yat_ter
yattered12239533yattered

Search took 10 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 Limit1340274528.69015423.1
3Display Results4524520.576784.7
 (SQL Overall)1786914529.42218965.3
 
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.