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

481 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
watering12231631(None) 
catering112019901catering
wafering15208891wafering
wagering13219521wagering
waitering13310711waitering
waterings13229251waterings
wavering152410541wavering
altering91917112altering
bantering122414232bantering
bartering122313642bartering
battering122715142battering
cantering122417372cantering
capering132414962capering
cratering12312652cratering
dewatering1545772dewatering
entering91920052entering
faltering132211112faltering
fathering161010092fathering
gartering112111572gartering
gathering1499462gathering
haltering132212002haltering
havering152211052havering
lagering102212312lagering
latening9711492latening
lathering13912252lathering
layering122310352layering
mastering122315302mastering
mattering122314052mattering
maturing1139952maturing
metering112915632metering
mitering113015402mitering
nattering102212212nattering
paltering122612892paltering
papering132213312papering
pattering122314422pattering
petering112516812petering
sabering112113742sabering
tabering112211422tabering
tapering112112502tapering
tattering102212322tattering
uttering91613082uttering
wairing113414312wa_iring
wakening1636322wakening
wandering143310982wandering
waring105029442wa__ring
warring113717972wa_rring
watching173011172watching
waterdog1344452waterdog
waterier11312082waterier
waterily1438782waterily
waterish14310532waterish
waterline1249652waterline
waterlog1245042waterlog
wattling12258782wattling
weathering1798352weathering
weltering13219492weltering
westering132112642westering
wintering13412362wintering
withering16108812withering
wuthering1697802wuthering
yattering132410442yattering
adhering1338883adhering
adoring9412523_adoring
ageing84213403_age_ing
airing74927503_a_iring
alerting91312383_alerting
amercing1337193_amercing
anearing9413973_anearing
aneling82719503_aneling
angering102113803angering
anteing8312813ante_ing
atheling1249203_atheling
atoning83514873_atoning
attiring939483attiring
averring12239063_averring
averting122512733_averting
awakening1743203awakening
aweing103911253_awe_ing
bacterin12410273bacterin_
bacterins13410643bacterins
badgering1436963badgering
bannering12208803bannering
barbering14229683barbering
baring95135853ba__ring
barring104021593ba_rring
batching163712093batching
bathing134816243bat_hing
batiking1537503batiking
bating95132253bat__ing
battening12268853battening
batting104422273bat_ting
battling113110493battling
batwing13509813bat_wing
beavering1538703beavering
bettering122212753bettering
bitewing1435293bitewing
bittering122511993bittering
blathering16107583blathering
blattering13108713blattering
bothering152210203bothering
bowering142911713bowering
buttering122312523buttering
cageling12310843cageling
cambering16109873cambering
cameoing1379063cameoing
cankering162110793cankering
capturing1436623capturing
careering12311203careering
caring95137993ca__ring
catching163712773catching
cateran9313773cateran_
caterans10313223caterans
catling104819793cat_ling
catting103922643cat_ting
caverning1536283caverning
centering122915143centering
cering94522533__cering
chaptering18107963chaptering
chartering16109253chartering
chattering16108643chattering
cheering143612703cheering
clattering13109233clattering
clavering1538373clavering
cohering142413833cohering
covering142215723covering
cowering142514033cowering
craterings1346003craterings
dackering1737383dackering
daggering13246113daggering
daikering1536103daikering
dandering122511063dandering
dangering12239303dangering
daring84928683da__ring
dateline9810353dateline
dating85326483dat__ing
davening13258873davening
deterging1237853deterging
deterring1138623deterring
diapering1339033diapering
dithering1499853dithering
dowering132510613dowering
earing75235483ea__ring
earring83519013ea_rring
eateries8324313eateries
eating75134403eat__ing
elaterin849903elaterin_
elaterins9410033elaterins
faceting1438783faceting
factoring1537523factoring
fairing113614013fa_iring
faring105231283fa__ring
fastening13268603fastening
fating105328673fat__ing
fatling113815683fat_ling
fattening13287833fattening
fatting113818703fat_ting
favoring1596673favoring
feathering17108793feathering
featuring1337323featuring
festering132413173festering
fettering132310513fettering
fevering152510083fevering
filtering13199723filtering
flattering1498743flattering
fleering123811283fleering
fostering132411263fostering
gaeing84617223ga_e_ing
gandering122111293gandering
garnering11298083garnering
garring93116713ga_rring
gatherings15105293gatherings
gating84826953gat__ing
gaveling133410163gaveling
gettering112310033gettering
guttering112410443guttering
haeing104118923ha_e_ing
hammering1737633hammering
hampering1738863hampering
hankering17239383hankering
haring104233003ha__ring
hastening13259483hastening
hatching173312213hatching
hating104929713hat__ing
hatting113920233hat_ting
havening15258553havening
homering141512073homering
hovering151911143hovering
inhering12913713inhering
interning10315253interning
interring10315423interring
iteming1037753_iteming
jabbering2134443jabbering
jarring153613193ja_rring
jeering153513043_jeering
jittering17218423jittering
kashering1736253kashering
laagering1136833laagering
labeling11311643labeling
laboring112110143laboring
lacewing1435843lacewing
lackering1639373lackering
laddering1237593laddering
ladening1078823ladening
lairing83715343la_iring
lappering14258843lappering
latching143712023latching
lateraling11148803lateraling
laterite8716333laterite
laterize17613293laterize
laterizing2049093laterizing
lathing114315693lat_hing
latrine7715123lat_rine
laveering1336813laveering
lawyering1655213lawyering
layerings13235683layerings
leathering1488683leathering
leering83417643_leering
lettering102112073lettering
levering122212503levering
littering102411983littering
livering122012383livering
loitering1039683loitering
lowering122210913lowering
lustering102711203lustering
majoring1836363majoring
mammering1337333mammering
manuring1139223manuring
marring103319553ma_rring
martyring1535783martyring
matching163512393matching
material10314103material
materiel10311253materiel
mating94832913mat__ing
matting103620143mat_ting
metring103215293met_ring
mitring103514143mit_ring
mothering152110183mothering
motoring11410953motoring
mustering122212333mustering
muttering122611323muttering
naething1236073naething
neatening1038353neatening
neutering1038963neutering
nidering10510483nidering
oaring74225303oa__ring
ochering14219393ochering
offering1536393offering
ordering1039353ordering
outring84021023out_ring
overing111918053_overing
oystering1337563oystering
pairing103716733pa_iring
pampering1638383pampering
pandering133211963pandering
paneling111013623paneling
paring94236493pa__ring
parring103222063pa_rring
partnering1345553partnering
pastoring12310853pastoring
pasturing1238433pasturing
patching163212753patching
patenting1248943patenting
patining11312303patining
patterning1346073patterning
patting103722343pat_ting
paupering1437273paupering
peering103520353_peering
peltering122011673peltering
pestering122315663pestering
plastering1339243plastering
portering122012303portering
pothering151911283pothering
pottering122612003pottering
powering142210803powering
pterin81014153_pterin_
pterins9812993_pterins
puttering122611643puttering
quartering2045843quartering
quavering2235953quavering
queering1838203queering
rapturing1245353rapturing
raring74332873ra__ring
rating74938703rat__ing
rattening10288763rattening
ratting83822363rat_ting
rattling92510873rattling
raveling123414373raveling
ravening122611293ravening
razeeing1834363razeeing
razoring1836443razoring
realtering1139473realtering
retearing102214253retearing
retiring92717413retiring
revering122918073revering
rogering10310273rogering
sabeing102611863sabe_ing
sabring102614843sa_bring
sacring103115983sa_cring
saggering12197793saggering
sating74735453sat__ing
sauntering1137223sauntering
sauteing937913saute_ing
savoring1269483savoring
scattering1398013scattering
sering74731813__sering
severing122013853severing
sewering122411093sewering
shattering1498283shattering
sheering123715103sheering
sintering101014803sintering
sistering101213753sistering
slathering14108283slathering
slavering1338723slavering
smattering1397583smattering
sneering93414503sneering
sobering111912783sobering
spattering13107793spattering
speering113116323speering
sphering142811943sphering
spiering112713353spiering
staring84527053_staring
starring92312953starring
steering93916793steering
sterling93615553_sterling
stewing113412493_stewing
storing83921123_storing
string75327563_st_ring
supering11317683supering
suturing9310373suturing
swaggering16233623swaggering
swathing15248713swat_hing
swatting12309593swat_ting
sweltering1445233sweltering
swithering17105213swithering
taboring113010193taboring
tampering1438453tampering
taring73932283__taring
tarring83318303ta_rring
tatting84019523tat_ting
tattling9259473tattling
tautening1035843tautening
tearing84021493__tearing
teeing73916973__teeing
teetering10239893teetering
tentering102313203tentering
terming104016003__terming
tethering1339133tethering
tewing103914823__tewing
tiering8315253_tiering
tiring74023093__tiring
tittering102310313tittering
tottering10229613tottering
towering122610873towering
tutoring938433tutoring
twattling1332693twattling
twittering1444583twittering
tyring104613023__tyring
ulcering1139333ulcering
umbering1399433umbering
untiring9312003untiring
unwavering1743223unwavering
uptearing1236103uptearing
ushering1258923ushering
uterine7315193_uterine
valeting1238843valeting
vaporing1437653vaporing
vatting113614853vat_ting
veering113213683_veering
wabbling16207743wabbling
wadding133711943wa_dding
waddling14237933waddling
waddying17204723waddying
wading114619533wa__ding
waffing173710243wa_ffing
waffling1845423waffling
wafting143911663wa_fting
wagging133313353wa_gging
waggling14197063waggling
waging114318383wa__ging
wagoning1336923wagoning
waifing142910893wa_ifing
wailing113620903wa_iling
waisting123615213waisting
waiting113618953wa_iting
waiving14329633wa_iving
wakenings1743043wakenings
wakerife1843673wakerife
waking144821383wa__king
waling104525303wa__ling
walking154013303wa_lking
walling113520973wa_lling
waltzing2134263waltzing
wambling16198443wambling
wanderings15215833wanderings
wangling132310993wangling
waning103623803wa__ning
wanking154216783wa_nking
wanning113816213wa_nning
wanting114220173wa_nting
wantoning1337083wantoning
wapping153514603wa_pping
warbling14198943warbling
warding123918143wa_rding
warking153519573wa_rking
warming133515083wa_rming
warning113717093wa_rning
warping133715183wa_rping
warsling12198593warsling
washing145119283wa_shing
wasterie111211583wasteri_e
wasteries121115343wasteries
wasting114422843wa_sting
water84733313water___
waterage1248663waterage
waterbed1436443waterbed
waterbird1554503waterbird
waterbus1345863waterbus
waterdogs1444553waterdogs
watered113014953water_ed
waterer103314073water_er
waterers112312783waterers
waterhen1485303waterhen
waterhens1574963waterhens
wateriest12312233wateriest
wateriness1348073wateriness
waterjet1848293waterjet
waterlily1544343waterlily
waterlines1348953waterlines
waterlogs1345383waterlogs
waterloo1145723waterloo
waterman1397283waterman
watermen1377613watermen
waters95030633water__s
waterside1345803waterside
waterski1543223waterski
waterskiing1951793waterskiing
waterway1745563waterway
watery123914493water__y
wauking153410013wa_uking
wauling112713113wa_uling
waveringly2043723waveringly
waving134018203wa__ving
wawling143810963wa_wling
waxing174215283wa__xing
waxwing2154723wa_xwing
wayfaring1942513wayfaring
waygoing1633273waygoing
weakening1734843weakening
wearing113318863w_earing
weaseling1335613weaseling
weatherings1895263weatherings
wedeling1338773wedeling
weeding123815213w_eeding
weening114113973w_eening
weeping133613673w_eeping
weeting113816053w_eeting
wetting114117383wet_ting
wheeling15318593wheeling
wheeping17337103wheeping
wheezing24315383wheezing
whetting1535973whetting
whirring15286283whirring
whitening1635103whitening
whitewing1943853whitewing
whoring142910293w_horing
widening13237833widening
wildering1456743wildering
wiring104521023w__iring
witching173410633witching
withing143814493wit_hing
witing103522823wit__ing
witling113215813wit_ling
witting113417063wit_ting
wizening21255463wizening
wondering142110463wondering
wotting112913843wot_ting
wrathing15248923wrat_hing
wring95920713w___ring
wyting13277243wyt__ing
yabbering1734023yabbering
yammering1735193yammering

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.1701051123.5
2DLD Change Limit1461624817.19020328.5
3Display Results4814810.2032369.5
 (SQL Overall)1786914817.56323627.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.