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

212 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
wastage1110925(None) 
waftage14115321waftage
wantage11119621wantage
wastages12109751wastages
wattage1186981wattage
cartage10312592cartage
hastate10313912hastate
hostage113111232hostage
massage1039892massage
onstage838362onstage
passage1039802passage
postage103214852postage
restage83316192restage
stage65330192__stage
upstage10167442upstage
vantage11109892vantage
waftages15105392waftages
wantages12109022wantages
warpage1336402warpage
wastable131410452wastable
waste86125052wast__e
wastrie101210302wastrie
watape11208482wa_tape
wattages12106782wattages
wattape12135382wattape
adage7414053_a_dage
ambage11510603_ambage
anlage72514233_anlage
antae56828293_anta_e
assuage835683assuage
asswage1144673asswage
astute6310763_astute
backstage1845423backstage
baggage1235633baggage
bandage11311023bandage
barrage10710843barrage
bastard103012423bastard
baste74829983bast__e
bastile9313913bastile
bistate9313823bistate
boscage1276533boscage
boskage1465413boskage
brassage1145283brassage
cabbage1446983cabbage
cabotage1345223cabotage
carnage10311743carnage
cartages11313313cartages
cascade12118603cascade
casease939323casease
caseate9314783caseate
castable121613973castable
castanet10416193castanet
caste75932363cast__e
castle84918963cast_le
castrate10313863castrate
chantage1446633chantage
costae85319683costa_e
costate94019273costate
cottage104210573cottage
cuttage10318343cuttage
damage10410773da_mage
dastard9279703dastard
diastase946603diastase
dosage82810003dos_age
dotage82711613_dotage
downstage1443373downstage
ecotage1036883ecotage
elastase845643elastase
estate64719763_estate
flotage1136683flotage
footage1148843footage
garage8314513ga_rage
garbage1138053garbage
gasbag1035413gasbag_
gasbags1135473gasbags
gavage1137193ga_vage
gestate83614073gestate
graftage1343683graftage
haste85927863hast__e
haulage1136913haulage
haylage1436443haylage
hostages122311693hostages
instate71616483instate
lactase937953lactase
lactate9312693lactate
lasagne844063las_agne
lavage1038263la_vage
maltase938903maltase
manage93818903ma_nage
massaged1236753massaged
massager1136873massager
massages1159883massages
mastaba1146223mastaba
meltage1037953meltage
message1037833message
metage93114453_metage
mintage101110123mintage
mispage12310523mispage
mistake131312623mistake
montage101211713montage
offstage1541903offstage
outage72017533_outage
package16128013package
partake1339643partake
passade1039233passade
passaged1236243passaged
passages1139513passages
pasta76624533pasta__
pastas85422873pasta_s
paste74932953past__e
pastie85525523past_ie
pastime114611973pastime
pasturage1244923pasturage
pasture9311463pasture
pawnage1335873pawnage
portage103013643portage
postages112815323postages
potage92715903_potage
pottage103310603pottage
ragtag836643ragtag_
ragtags935373ragtags
rampage1237453rampage
ravage1039303ra_vage
restaged103011863restaged
restages92815773restages
restate73824883restate
rootage839053rootage
sabotage1144603sabotage
sage55044593__s_age
salvage1138193salvage
sausage847193sausage
savage10410173sa_vage
scutage1036333scutage
septage1078403septage
stade64825303__stade
stag57332003__stag_
staged84521563__staged
stager74821343__stager
stages75629493__stages
stagey105915583__stagey
stags66226743__stags
stagy96618893__stagy
stake95927533__stake
stale55637103__stale
stane55933003__stane
stare54440263__stare
state56237333__state
stave85324993__stave
substage11117183substage
swage94919563__swage
tallage82712073tallage
tankage12257773tankage
tannage8209583tannage
tartare73012683tartare
tastable101511973tastable
taste55127233tast__e
tentage81010643tentage
testae64216253testa_e
testate73916233testate
unitage838993unitage
unstate71916213unstate
upstaged12135243upstaged
upstager11164633upstager
upstages11147373upstages
upstare9158683upstare
upstate91610493upstate
usage6410213_us_age
vantages12119023vantages
ventage11109623ventage
vestige1137433vestige
vintage11128143vintage
visage1049083vis_age
voltage1136863voltage
wafture1334853wafture
wage84834083w___age
wagonage1343293wagonage
wagtail1145043wagtail
wakame1535433wa_kame
wannabe1234533wannabe
warfare1336733warfare
warpages1437053warpages
warstle10328013warst_le
wartime1237743wartime
wasabi1154643was_abi
washable16138043washable
washrag1444043washrag_
washrags1543893washrags
wassail1056133wassail
wast75655853wast___
wasted104423023wast_ed
waster95228943wast_er
wasterie111211583wasterie
wasters104026593wasters
wastery134610993wastery
wastes96224883wast_es
wasting114422843wasting
wastrel1037553wastrel
wastries111212883wastries
wastry12388773wast_ry
wasts87433673wast__s
watap102111673wa_ta_p
watapes12228383wa_tapes
wataps11248683wa_taps
waterage1248663waterage
wattapes1395253wattapes
wattle94314213wa_ttle
webpage1543133webpage
wharfage1842213wharfage
windage1237933windage
wordage1236503wordage
wrastle10368993wrast_le
yardage1235733yardage

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272126.59620319.4
3Display Results2122120.0762789.5
 (SQL Overall)1786912127.07525256.7
 
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.