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 “watery” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
watery12391449(None) 
eatery95316351eatery
wafery15398691wafery
wastery134610991wastery
water84733311water_
waters95030631waters
wavery154610051wavery
aery77231682_a_ery
apery106517902_apery
artery9911452artery
bakery155911002bakery
battery124911812battery
cater74840712cater_
caters85336502caters
cattery123811602cattery
cautery12349592cautery
datary10310242datary
dater65332312dater_
daters74827372daters
eater54639842eater_
eaters65535952eaters
faery116015482fa_ery
fakery16509262fakery
gater64533652gater_
gaters74728642gaters
hater85034752hater_
haters94930402haters
japery18439142japery
lately93413842lately
later54843922later_
lathery133911122lathery
mastery124214322mastery
mater74438862mater_
maters85032392maters
matey107022662mate_y
mattery123810712mattery
napery11489812napery
nitery94412172nitery
oater55433732oater_
oaters65029792oaters
papery134812742papery
pater74740722pater_
paters84935832paters
rater54943282rater_
raters63936582raters
tater54138612tater_
taters64932202taters
wader95325362wader_
waders109120642waders
wafer114417642wafer_
wafers124316142wafers
wafter124114612wafter_
wafters134112812wafters
wager95925052wager_
wagers105122202wagers
waggery15276902waggery
waiter94321252waiter_
waiters104218622waiters
waker125526592waker_
wakers134822492wakers
waler84229262waler_
walers94824462walers
waney115120322wane_y
wanter94423052wanter_
wanters104420092wanters
wary106740012wa__ry
waster95228942waster_
wasters104026592wasters
wastry12388772wastry
watered113014952watered
waterer103314072waterer
waterily1438782waterily
waterway1745562waterway
watter93221982watter_
waver115025702waver_
wavers125022472wavers
wavey145115542wave_y
waxer154317482waxer_
waxers164014302waxers
winery125014282winery
wintery13399752wintery

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit82551812.54632423.8
3Display Results81810.0332454.5
 (SQL Overall)178691812.68966452.6
 
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.