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

159 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
warpage133640(None) 
warpages1437051warpages
barrage10710842barrage
carnage10311742carnage
carpale113414352carpale
cartage10312592cartage
garage8314512gar_age
garbage1138052garbage
rampage1237452rampage
waftage14115322waftage
wantage11119622wantage
warfare1336732warfare
warpath1545202warpath
warplane1345982warplane
wastage11109252wastage
wattage1186982wattage
webpage1543132webpage
wharfage1842212wharfage
wordage1236502wordage
yardage1235732yardage
acreage1037843acreage
adage7414053_a_dage
ambage11510603_ambage
anlage72514233_anlage
apace94718383_a_pace
arame75026623_ar_ame
arcade91013643_arcade
arcane81216743_arcane
areae55229743_area_e
arrange838683_arrange
baggage1235633baggage
bandage11311023bandage
barbate11314543barbate
barege94713543bar_ege
barge85631023bar__ge
baronage1147073baronage
barraged1297683barraged
barrages11711083barrages
barware12610703barware
borage93917013bor_age
burgage1136633burgage
cabbage1446983cabbage
campagne1544413campagne
carafe115416163car_afe
carapace1446093carapace
carate84734003car_ate
carcase11312743carcase
carfare12310073carfare
carnages11312213carnages
carpal103716253carpa_l
carpals113414633carpals
carriage1137853carriage
cartages11313313cartages
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
damage10410783da_mage
drayage1234433drayage
enrage72715073enr_age
farrago1144923farrago
forage104617003for_age
garaged1039253gar_aged
garages9314113gar_ages
garbages1238183garbages
garbagey1543373garbagey
garbagy1444243garbagy
garpike1435093garpike
gavage1137193ga_vage
haulage1136913haulage
haylage1436443haylage
herbage1337003herbage
karate105320923kar_ate
large65325463lar__ge
larvae938843larva_e
lavage1038263la_vage
manage93818903ma_nage
marge85328333mar__ge
marriage1147253marriage
massage1039893massage
mirage92313653mir_age
mispage12310523mispage
narrate7313493narrate
package16128013package
page76036103___page
palpate113213923palpate
parade94720643par_ade
parae76335703par_a_e
parbake1538353parbake
parge85831853par__ge
parkade1437583parkade
partake1339643partake
passage1039803passage
pawnage1335873pawnage
pipage1199143_pipage
portage103013643portage
rage55742353__r_age
rampaged1434103rampaged
rampager1344453rampager
rampages1336673rampages
ravage1039303ra_vage
salpae84614273salpa_e
salvage1138193salvage
sarape84817573sar_ape
sarge65531133sar__ge
sausage847193sausage
savage10410173sa_vage
seepage1037543seepage
serfage1138403serfage
tallage82712073tallage
tankage12257773tankage
tannage8209583tannage
targe65227093tar__ge
tarpan82814293tarpa_n
tarpans92513533tarpans
tarpaper1244603tarpaper
tartare73012683tartare
triage72812893_triage
vantage11109893vantage
variate101316433variate
vorlage1136403vorlage
waftages15105393waftages
wage84834083w___age
wagonage1343293wagonage
wakame1535433wa_kame
wannabe1234533wannabe
wantages12109023wantages
warble113516603war_ble
ware76254723war___e
warfares1436683warfares
waring105029443waring_
warlike142410473warlike
warmaker1735973warmaker
warp95635003warp___
warpaths1643973warpaths
warped124816413warp_ed
warper114015583warp_er
warpers123413583warpers
warping133715183warping
warplanes1445893warplanes
warpower1645043warpower
warps107126423warp__s
warpwise1642853warpwise
warragal1243863warragal
warrant10614243warrant
warsaw1236193warsa_w
warsaws1335763warsaws
warsle93112923war_sle
warstle10328013warstle
wartime1237743wartime
wastages12109753wastages
watape11208483wa_tape
waterage1248663waterage
wattages12106783wattages
wattape12135383wattape
webpages1643053webpages
wharfages1942633wharfages
windage1237933windage
wordages1337053wordages
yardages1336203yardages

Search took 7 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 Limit1340271596.00022337.8
3Display Results1591590.0463456.5
 (SQL Overall)1786911596.45227695.4
 
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.