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

174 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
waterings1322924(None) 
watering122316311watering_
catering112019902catering_
craterings1345982craterings
gatherings15105272gatherings
layerings13235672layerings
wafering15208892wafering_
wagering13219522wagering_
waitering13310712waitering_
wakenings1743042wakenings
wanderings15215822wanderings
waterdogs1444552waterdogs
wateriness1348072wateriness
waterlines1348952waterlines
waterlogs1345382waterlogs
wavering152410542wavering_
weatherings1895252weatherings
ageings9437693_age_ings
airings83913833_a_irings
altering91917113altering_
athelings1345113_athelings
awakenings1841543awakenings
bacterins13410643bacterin_s
bantering122414233bantering_
bartering122313643bartering_
battering122715143battering_
battings114010573bat_tings
bitewings1542933bitewings
cagelings1335413cagelings
cantering122417373cantering_
capering132414963capering_
caterans10313203cateran_s
catlings113712043cat_lings
centerings13247653centerings
coverings15217883coverings
cratering12312653cratering_
darings93713643da__rings
datelines1088843datelines
dewatering1545773dewatering_
earings84517703ea__rings
earrings9299623ea_rrings
eateries8324303eateri_es
eatings84616433eat__ings
elaterins9410033elaterin_s
entering91920053entering_
fairings12388193fa_irings
faltering132211113faltering_
fastenings14273903fastenings
fathering161010093fathering_
fatlings12359303fat_lings
featherings18105363featherings
gartering112111573gartering_
gathering1499463gathering_
gatings95212823gat__ings
gutterings12224903gutterings
haltering132212003haltering_
hankerings18244743hankerings
hatchings18225673hatchings
havering152211053havering_
lacewings1543303lacewings
lagering102212313lagering_
latening9711493latening_
laterites9715043laterites
laterizes18513013laterizes
lathering13912253lathering_
lathings12469853lat_hings
latrines8515003lat_rines
lawyerings1752573lawyerings
layering122310353layering_
letterings11225993letterings
mastering122315303mastering_
materials11510783materials
materiels1147823materiels
matings104516203mat__ings
mattering122314053mattering_
mattings11369673mat_tings
maturing1139953maturing_
metering112915633metering_
mitering113015393mitering_
motherings16255623motherings
motorings1245963motorings
naethings1343873naethings
nattering102212203nattering_
niderings1175393niderings
offerings1643643offerings
outrings92811053out_rings
oysterings1443883oysterings
pairings11398313pa_irings
paltering122612893paltering_
panelings12107453panelings
papering132213313papering_
parings104219213pa__rings
pattering122314423pattering_
patternings1443183patternings
petering112516813petering_
plasterings1444743plasterings
pterins9812993_pterin_s
quarterings2143723quarterings
ratings84217403rat__ings
rattlings10235513rattlings
ravelings13377383ravelings
ravenings13235183ravenings
sabering112113743sabering_
sacrings11278923sa_crings
scatterings14103973scatterings
smatterings14103833smatterings
speerings12276833speerings
sterlings10308753_sterlings
strings84617133_st_rings
tabering112211423tabering_
tapering112112503tapering_
tattering102212323tattering_
tattings9408823tat_tings
uttering91613083uttering_
vaporings1544093vaporings
waddings14356463wa_ddings
wafflings1943023wafflings
wairing113414313wa_iring_
waistings1352710763waistings
waitings123413743wa_itings
wakening1636323wakening_
walkings16327313wa_lkings
wandering143310973wandering_
waring105029443wa__ring_
warnings12358453wa_rnings
warring113717973wa_rring_
washings15419273wa_shings
wasteries121115343wasteri_es
watching173011173watching_
waterage1248663water_age
waterages1349373waterages
waterbeds1544883waterbeds
waterbirds1644053waterbirds
waterbus1345863water_bus
waterdog1344453waterdog_
waterers112312783water_ers
waterhens1574963waterhens
waterier11312083wateri_er
wateriest12312233wateriest
waterily1438783wateri_ly
waterish14310533wateri_sh
waterjets1944463waterjets
waterless1238013waterless
waterline1249653waterlin_e
waterlog1245043waterlog_
waterloos1246043waterloos
waters95030623water___s
watersides1445533watersides
waterskiings2061113waterskiings
waterskis1643983waterskis
waterways1845093waterways
wattling12258783wattling_
waveringly2043723waveringly
waxings18366453wa__xings
waxwings2232953wa_xwings
wayfarings2041773wayfarings
waygoings1742203waygoings
weathering1798353weathering_
weepings14346483w_eepings
weltering13219493weltering_
westering132112643westering_
wettings12348403wet_tings
wheelings16284933wheelings
whitenings1742613whitenings
whitewings2042333whitewings
wintering13412353wintering_
wirings113910103w__irings
witchings18325303witchings
withering16108803withering_
witlings12328443wit_lings
wittings12328733wit_tings
wrings104012973w___rings
wuthering1697803wuthering_
yattering132410443yattering_

Search took 9 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 Filter1786911486410.203880251.2
2DLD Change Limit1486411747.97018650.1
3Display Results1741740.0762289.5
 (SQL Overall)1786911748.24921662.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.