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

143 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
waterbed143644(None) 
waterbeds1544881waterbeds
watered113014951water_ed
catered103117762cater_ed
interbed112413102interbed
wafered14288432wafer_ed
wagered12299332wager_ed
waitered1238752waiter_ed
waterbird1554502waterbird
waterbus1345862waterbus
waterer103314072water_er
waterhead1644392waterhead
waterhen1485302waterhen
waterier11312082waterier
waterjet1848292waterjet
watermen1377612watermen
watershed1644632watershed
waterweed1644622waterweed
wavered142910432waver_ed
acerber1135233_acerber
aeried74221863_a_eried
alerted82512223_alerted
altered83215733alter_ed
amerced1256523_amerced
averred11237593_averred
averted112211613_averted
bantered113313633banter_ed
barbed115121313ba__rbed
bartered113113013barter_ed
battered113315053batter_ed
cantered113415983canter_ed
capered123014043caper_ed
caterer92815933cater_er
caverned1436163caverned
cratered1149673crater_ed
deterged11127923deterged
deterred10137803deterred
dewatered1444743dewater_ed
eateries8324303eateries
entered82718883enter_ed
faltered122810983falter_ed
fathered151510433father_ed
featherbed19174663featherbed
garbed104815663ga__rbed
gartered10319583garter_ed
gathered13149373gather_ed
haltered123112553halter_ed
hatred104814333hat_r_ed
havered144011453haver_ed
herbed123513453__herbed
interbeds12238903interbeds
interbred1248743interbred
interned93016653interned
interred92615263interred
kerbed13339693__kerbed
lagered92311153lager_ed
lakebed1434783lake_bed
latened8711923late_ned
laterad8310833later_ad
lateraled1047453lateraled
laterized1979903laterized
lathered121512323lather_ed
layered11259413layer_ed
mastered112614003master_ed
materiel10311253materiel
mattered112412903matter_ed
matured10310033matur_ed
metered103514013meter_ed
mitered103213233miter_ed
nattered92011623natter_ed
natured838963natur_ed
overbed132811843_overbed
paltered113012483palter_ed
papered122513163paper_ed
patented1188893patented
pattered112714203patter_ed
patterned1265743patterned
petered103314963peter_ed
raftered1237663rafter_ed
reverbed14269223reverbed
riverbed14245143riverbed
sabered103213023saber_ed
tabered103311593taber_ed
tapered102612933taper_ed
tattered92011443tatter_ed
termed94816703__termed
unwatered1345683unwater_ed
uttered82712433utter_ed
wagerer11328493wager_er
waired106015833wa_ir_ed
wakened1546873wake_ned
wandered132110793wander_ed
warbled133212163wa__rbled
warded115021043wa__rded
wardrobed1662523wardrobed
wared96339873wa__r_ed
warked144421213wa__rked
warmed124516893wa__rmed
warned104018913wa__rned
warped124816413wa__rped
warred104019843wa__rred
warted104223233wa__rted
wasterie111211583wasterie_
wasteries121115343wasteries
watched163012823wat_ched
water84733313water___
waterage1248663waterage
waterages1349373waterages
waterbirds1644053waterbirds
waterbuck2053133waterbuck
waterbuses1544943waterbuses
waterdog1344453waterdog
waterers112312783waterers
waterheads1744243waterheads
waterhens1574963waterhens
wateriest12312233wateriest
waterily1438783waterily
watering122316313watering
waterish14310533waterish
waterjets1944463waterjets
waterleaf1543703waterleaf
waterless1238013waterless
waterlog1245043waterlog
waterloo1145723waterloo
waterman1397283waterman
waters95030623water__s
watersheds1743533watersheds
waterside1345803waterside
waterski1543223waterski
waterway1745563waterway
waterweeds1743663waterweeds
watery123914493water__y
wattled113610503wat_tled
waverer13319523waver_er
weathered16168513weather_ed
webbed1436433w__ebbed
weltered12238433welter_ed
westered122511863wester_ed
wintered122111573winter_ed
winterfed1644993winterfed
withered15169433wither_ed
wuthered15157433wuther_ed
yattered12239533yatter_ed

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.1561145455.1
2DLD Change Limit1461621437.58019282.6
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.78222962.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.