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

148 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
wattages1210678(None) 
waftages15105391waftages
wantages12109021wantages
wastages12109751wastages
wattage1186981wattage_
wattapes1395251wattapes
cartages11313312cartages
cottages113310492cottages
cuttages11297222cuttages
pottages112910452pottages
vantages12119022vantages
waftage14115322waftage_
wantage11119622wantage_
warpages1437052warpages
wastage11109252wastage_
watapes12228382wa_tapes
waterages1349382waterages
wattape12135382wattape_
wattles103814072watt_les
adages8412953_a_dages
ambages1269623_ambages
anlages82414113_anlages
atlases72410643_atlases
attaches13137723_attaches
attacks13126943_attacks
attains7310983_attains
attars64515313_atta_rs
attires72312953_attires
attunes737823_attunes
baggages1335443baggages
bandages12310633bandages
barrages11711083barrages
battles94517683batt_les
battues94610193batt_ues
cabbages1537203cabbages
cabotages1444853cabotages
carnages11312213carnages
cartage10312593cartage_
catfaces1536963catfaces
cattails1038553cattails
cattaloes1146183cattaloes
cattalos1037933cattalos
catties94023053catt_ies
chantages1546583chantages
cottage104210573cottage_
cottager11306813cottager
cottagers12305383cottagers
cottagey14305233cottagey
cuttage10318343cuttage_
damages11511283da_mages
dotages92311793_dotages
ecotages1136973ecotages
fatties103018203fatt_ies
flotages1237163flotages
footages1239053footages
frottages1384993frottages
garages9314113ga_rages
garbages1238183garbages
gavages1237683ga_vages
graftages1443683graftages
haulages1236623haulages
haylages1536013haylages
hostages122311693hostages
lactases1038513lactases
lactates10311223lactates
lattes65324203latt__es
lattices1038383lattices
lavages1138603la_vages
maltases1039693maltases
manages103418963ma_nages
massages1159883massages
mattes85624533matt__es
meltages1148243meltages
metages102714973_metages
mintages111110513mintages
montages111412183montages
oatcakes1445543oatcakes
outages82317323_outages
outrages92215933outrages
outtakes12310033outtakes
packages17138733packages
partakes1449923partakes
passages1139513passages
patties93425143patt_ies
pawnages1435313pawnages
plottages1244243plottages
portages112613223portages
postages112815323postages
potages102416423_potages
pottage103310603pottage_
ragtags935373ragtag_s
rampages1336673rampages
ratbags1035763ratbag_s
rattails837133rattails
rattans73411953ratta_ns
rattles73217303ratt_les
ravages1139403ra_vages
restages92815773restages
rootages939103rootages
sabotages1244433sabotages
salvages1238123salvages
satiates8314633satiates
sausages937003sausages
savages1139973sa_vages
scutages1136503scutages
septages1168263septages
stages75629493__stages
tallages92312003tallages
tankages13217113tankages
tannages9228963tannages
tatties74120343tatt_ies
tattles73616283tatt_les
tentages91011043tentages
twattles1154383twatt_les
unitages938273unitages
upstages11147373upstages
vantage11109893vantage_
ventages12119773ventages
vintages12118273vintages
voltages1237253voltages
waftures1434853waftures
wages95330933w___ages
wagonages1443303wagonages
wagtails1244443wagtails
wakames1635283wa_kames
waltzes1935953walt_zes
wannabes1344473wannabes
warfares1436683warfares
warpage1336403warpage_
wartimes1336963wartimes
wastes96224883wast__es
wastries111212883wastries
watape11208483wa_tape_
wataps11248683wa_ta_ps
watches153017373wa_tches
waterage1248663waterage_
watter93221983watt__er
wattest102412153watt__est
wattle94314213watt_le_
wattled113610503watt_led
wattless11268723wattless
watts86923093watt___s
webpages1643053webpages
wetwares1445953wetwares
wharfages1942633wharfages
windages1338263windages
wordages1337053wordages
yardages1336203yardages

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621488.20317818.1
3Display Results1481480.0632349.2
 (SQL Overall)1786911488.68620572.3
 
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.