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

129 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
waftage1411532(None) 
waftages15105391waftages
wantage11119621wantage
wastage11109251wastage
wattage1186981wattage
cartage10312592cartage
graftage1343682graftage
vantage11109892vantage
wafture1334852wafture
wantages12109022wantages
warpage1336402warpage
wastages12109752wastages
watape11208482wa_tape
wattages12106782wattages
wattape12135382wattape
adage7414053_a_dage
aflame1138723_aflame
ambage11510603_ambage
anlage72514233_anlage
antae56828293_anta_e
baggage1235633baggage
bandage11311023bandage
barrage10710843barrage
cabbage1446983cabbage
cabotage1345223cabotage
caftan111710123cafta_n
caftaned1445093caftaned
caftans12179443caftans
carnage10311743carnage
cartages11313313cartages
catface1436763catface
chantage1446633chantage
cottage104210573cottage
cuttage10318343cuttage
damage10410773da_mage
dotage82711613_dotage
driftage1342933driftage
ecotage1036883ecotage
flotage1136683flotage
footage1148843footage
garage8314513ga_rage
garbage1138053garbage
gavage1137193ga_vage
graftages1443683graftages
haftara13136093haftara
hastate10313913hastate
haulage1136913haulage
haylage1436443haylage
hostage113111233hostage
kaftan13185823kafta_n
kaftans14185353kaftans
lactase937953lactase
lactate9312693lactate
lavage1038263la_vage
leafage1194573leaf_age
maltase938903maltase
manage93818903ma_nage
massage1039893massage
meltage1037953meltage
metage93114453_metage
mintage101110123mintage
montage101211713montage
offstage1541903offstage
onstage838363onstage
outage72017533_outage
package16128013package
partake1339643partake
passage1039803passage
pawnage1335873pawnage
portage103013643portage
postage103214853postage
potage92715903_potage
pottage103310603pottage
ragtag836643ragtag_
ragtags935373ragtags
rampage1237453rampage
ravage1039303ra_vage
restage83316193restage
rootage839053rootage
sabotage1144603sabotage
salvage1138193salvage
sausage847193sausage
savage10410173sa_vage
scutage1036333scutage
septage1078403septage
stage65330193__stage
tallage82712073tallage
tankage12257773tankage
tannage8209583tannage
tartare73012683tartare
tentage81010643tentage
unitage838993unitage
upstage10167443upstage
vantages12119023vantages
ventage11109623ventage
vintage11128143vintage
voltage1136863voltage
waffie15338563waf_fie
waffle15369183waf_fle
waft106139003waft___
wafted134012143waft_ed
wafter124114613waft_er
wafters134112813wafters
wafting143911663wafting
wafts116920553waft__s
waftures1434853waftures
wage84834083w___age
wagonage1343293wagonage
wagtail1145043wagtail
wakame1535433wa_kame
wannabe1234533wannabe
warfare1336733warfare
warpages1437053warpages
wartime1237743wartime
wastable131410453wastable
waste86125053wast__e
wastrie101210303wastrie
watap102111673wa_ta_p
watapes12228383wa_tapes
wataps11248683wa_taps
waterage1248663waterage
wattapes1395253wattapes
wattle94314213wa_ttle
webpage1543133webpage
wharfage1842213wharfage
windage1237933windage
wordage1236503wordage
yardage1235733yardage
zaftig1933253zaftig_

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.423422437.4
2DLD Change Limit1340271296.62320236.6
3Display Results1291290.0502580.0
 (SQL Overall)1786911297.09625181.9
 
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.