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

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

100 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
waterage124866(None) 
waterages1349381waterages
average1158852_average
interage9314492interage
layerage1244962layerage
meterage1147932meterage
wattage1186982wat_tage
acerate92818913_acerate
acreage1037843_acreage
aerate64830553_a_erate
amperage1347743amperage
averaged1356213_averaged
averages1249183_averages
barrage10710843ba_rrage
beverage1445143beverage
camerae11312063camera_e
catenae9311373catena_e
catenate10312833catenate
cateran9313773catera_n
caterans10313223caterans
coverage1438733coverage
deterge9118463deter_ge
esterase849483esterase
factorage1543363factorage
fosterage1344663fosterage
garage8314513ga__rage
iterate71119113_iterate
lacerate102214713lacerate
langrage10106033langrage
laterad8310843latera_d
lateral7313573latera_l
lateraled1047463lateraled
laterals8312753laterals
laterite8716343laterite
laterize17613303laterize
layerages1345303layerages
leverage1285393leverage
literate81216893literate
macerate122314073macerate
maturate10312623maturate
meterages1248183meterages
outrage82616893out_rage
overage11514053_overage
pasturage1244923pasturage
peerage1089803_peerage
porterage1245763porterage
quarterage2053043quarterage
saturate8312813saturate
sewerage1245513sewerage
steerage946833steerage
storage8310473_storage
tutelage944063tutelage
tutorage945743tutorage
unaverage1343553unaverage
underage101012273underage
valerate11311473valerate
waftage14115323wa_ftage
wagonage1343293wagonage
wakerife1843673wakerife
wantage11119623wa_ntage
warpage1336403wa_rpage
washrag1444043washrag_
washrags1543893washrags
wastage11109253wa_stage
wasterie111211583waster_ie
watape11208483wat__ape
water84733313water___
waterbed1436443waterbed
waterbus1345863waterbus
waterdog1344453waterdog
waterdogs1444553waterdogs
watered113014953water_ed
waterer103314073water_er
waterers112312783waterers
waterfall1544583waterfall
waterhen1485313waterhen
waterier11312083waterier
waterily1438783waterily
watering122316313watering
waterings13229253waterings
waterish14310533waterish
waterjet1848293waterjet
waterline1249653waterline
waterlog1245043waterlog
waterlogs1345383waterlogs
waterloo1145723waterloo
waterman1397283waterman
watermark1844123watermark
watermen1377613watermen
waters95030633water__s
waterscape1753003waterscape
watershed1644643watershed
waterside1345803waterside
waterski1543223waterski
waterway1745563waterway
waterways1845093waterways
waterweed1644623waterweed
watery123914493water__y
wattages12106783wat_tages
wattape12135383wat_tape

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.453394461.4
2DLD Change Limit1461621006.79621507.1
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.29524495.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.