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

227 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
wantage1111962(None) 
vantage11109891vantage
waftage14115321waftage
wantages12109021wantages
wastage11109251wastage
wattage1186981wattage
anlage72514232_anlage
antae56828292_anta_e
bandage11311022bandage
cartage10312592cartage
chantage1446632chantage
manage93818902man_age
mintage101110122mintage
montage101211712montage
tankage12257772tankage
tannage8209582tannage
tentage81010642tentage
vantages12119022vantages
ventage11109622ventage
vintage11128142vintage
waftages15105392waftages
wannabe1234532wannabe
warpage1336402warpage
wastages12109752wastages
watape11208482wa_tape
wattages12106782wattages
wattape12135382wattape
windage1237932windage
adage7414053_a_dage
advantage1452183advantage
ambage11510603_ambage
anatase738943_anatase
anlace82513923_anlace
anlagen8238643_anlagen
anlages82414113_anlages
ansae55720973_ansa_e
ansate64517863_ansate
anta46839583_anta__
antas55432033_anta_s
ante46538903_ant__e
antigen8311123_antigen
antre55224523_ant_re
apanage1036803apan_age
baggage1235633baggage
bandaged1337313bandaged
bandager1237703bandager
bandages12310633bandages
bantam10314063banta_m
bantams1149063bantams
barrage10710843barrage
bondage1138253bondage
cabbage1446983cabbage
cabotage1345223cabotage
canape10913513can_ape
cantal84122033canta_l
cantala94114673cantala
cantals93919573cantals
cantata93811813cantata
cantle84522153cant_le
carnage10311743carnage
cartages11313313cartages
centare93113703centare
chantages1546583chantages
cottage104210573cottage
cuttage10318343cuttage
damage10410773da_mage
dentate8315153dentate
dotage82711613_dotage
dunnage9175213dunnage
ecotage1036883ecotage
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
fanfare1336673fanfare
fantail10310233fantail
fantasie11117743fantasie
fantasm1236593fantasm
fantast10311703fantast
fantasy1336153fantasy
flotage1136683flotage
footage1148843footage
frontage1296243frontage
garage8314513ga_rage
garbage1138053garbage
gavage1137193ga_vage
graftage1343683graftage
hangtag1244533hangtag_
hangtags1344163hangtags
hantle94318203hant_le
hastate10313913hastate
haulage1136913haulage
haylage1436443haylage
hostage113111233hostage
incage93513623_incage
innage73011573_innage
intake10510863_intake
kantar10311153kanta_r
kantars11310033kantars
kantele1138253kantele
lactase937953lactase
lactate9312693lactate
lanate6421263lan_ate
langrage10106033langrage
language10105003language
lantana739603lantana
lavage1038263la_vage
linage7713403lin_age
lineage878983lineage
linkage1295963linkage
maltase938903maltase
managed113212603man_aged
manager103413583man_ager
manages103418963man_ages
manatee9317663manatee
mandate10315573mandate
manege94113203man_ege
mange84930193man__ge
manmade1237963manmade
manta75629913manta__
mantas85725363manta_s
mantle84420923mant_le
massage1039893massage
meltage1037953meltage
menage93216543men_age
metage93114453_metage
mintages111110513mintages
montaged12107763montaged
montages111412183montages
montane91313623montane
nonage7313683non_age
nonwage1137163nonwage
onstage838363onstage
outage72017533_outage
package16128013package
pancake1536673pancake
pantalet10415903pantalet
pantie84326473pant_ie
pantile93918483pantile
parentage1245603parentage
partake1339643partake
passage1039803passage
pawnage1335873pawnage
pentane9415743pentane
portage103013643portage
postage103214853postage
potage92715903_potage
pottage103310603pottage
ragtag836643ragtag_
ragtags935373ragtags
rampage1237453rampage
range64728413ran__ge
ravage1039303ra_vage
restage83316193restage
rootage839053rootage
sabotage1144603sabotage
salvage1138193salvage
sanitate8612043sanitate
sausage847193sausage
savage10410173sa_vage
scutage1036333scutage
septage1078403septage
sinkage1287263sinkage
stage65330193__stage
syntagm1343313syntagm
tallage82712073tallage
tanager83010943tan_ager
tankages13217113tankages
tannages9228963tannages
tannate71813523tannate
tantara72410823tantara
tartare73012683tartare
tentages91011043tentages
thanage11117943than_age
tonnage8168053tonnage
tunnage8166373tunnage
uncage93014873_uncage
unitage838993unitage
untame82513603_untame
upstage10167443upstage
ventages12119773ventages
vintager12104823vintager
vintages12118273vintages
voltage1136863voltage
wafture1334853wafture
wage84834083w___age
wagonage1343293wagonage
wagtail1145043wagtail
wakame1535433wa_kame
wandle105316663wan_dle
wane76344723wan___e
wangan10311223wanga_n
wangans1149503wangans
wangle103817503wan_gle
wanigan1135213wanigan
waning103623803waning_
wannabee1343993wannabee
wannabes1344473wannabes
want76156173want___
wanted104319723want_ed
wanter94423053want_er
wanters104420093wanters
wanting114220173wanting
wanton94413813want_on
wantoned12117223wantoned
wantoner1187563wantoner
wantons103713013wantons
wants87932213want__s
wapentake1852003wapentake
warfare1336733warfare
warpages1437053warpages
wartime1237743wartime
wastable131410453wastable
waste86125053wast__e
wastrie101210303wastrie
watap102111673wa_ta_p
watapes12228383wa_tapes
wataps11248683wa_taps
waterage1248663waterage
wattapes1395253wattapes
wattle94314213wa_ttle
webpage1543133webpage
wharfage1842213wharfage
windages1338263windages
wintle94014603wint_le
wordage1236503wordage
xanthate1845713xanthate
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.406440125.6
2DLD Change Limit1340272277.31318327.2
3Display Results2272270.0762986.8
 (SQL Overall)1786912277.79522923.8
 
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.