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

167 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
rampage123745(None) 
rampaged1434101rampaged
rampager1344451rampager
rampages1336671rampages
ambage11510602_ambage
campagne1544412campagne
damage10410772dam_age
ramate83921682ram_ate
rampagers1443862rampagers
rampant11312172rampant
rampart11311992rampart
rampike1536602rampike
rampole1139692rampole
ravage1039302ra_vage
rummage1234582rummage
warpage1336402warpage
adage7414053_a_dage
amaze166016603_am_aze
ambages1269623_ambages
amperage1347743_amperage
ampere10514413_ampere
ample94720303_amp_le
ampule10710613_ampule
anlage72514233_anlage
apace94718383_a_pace
baggage1235633baggage
bandage11311023bandage
barrage10710843barrage
brakeage1544013brakeage
brassage1145283brassage
cabbage1446983cabbage
campagna1543413campagna
campaign1544213campaign
carnage10311743carnage
carpale113414353carpale
cartage10312593cartage
champagne1942783champagne
compare135814993compare
creepage1344343creepage
damaged1257453dam_aged
damager1157973dam_ager
damages11511273dam_ages
drainage1045783drainage
drayage1234423dra_yage
empale102611263_empale
fromage1336753from_age
gambade1336383gambade
gamboge1335583gamboge
garage8314513ga_rage
garbage1138053garbage
gavage1137193ga_vage
graftage1343683graftage
grampa115010173grampa__
grampas12399253grampa_s
hamate113319833ham_ate
haulage1136913haulage
haylage1436443haylage
homage121210603hom_age
homepage1644933homepage
image81411293_im_age
impale102811663_impale
lamiae84817453lamia_e
lampad114510033lampa_d
lampads12477623lampads
lampas106615953lampa_s
lampases1267293lampases
lavage1038263la_vage
mage75739133__m_age
mammae94613213mamma_e
mammate104411273mammate
manage93818903ma_nage
massage1039893massage
mispage12310523mispage
ohmage1295063ohm_age
package16128013package
page76036103___page
palpate113213923palpate
pampa114913423pampa__
pampas124913993pampa_s
passage1039803passage
pawnage1335873pawnage
pipage1199143_pipage
primage12169143prim_age
radiale83813523radiale
radiate83416313radiate
ragbag1045463ragbag_
ragbags1135113ragbags
rage55742353r___age
ragtag836643ragtag_
ragtags935373ragtags
ramada9310183ram_ada
ramal74622243ram_a_l
ramble104519973ram_ble
ramee74633853ram__ee
ramie75027823ram__ie
ramilie9310283ramilie
ramose8314403ram_ose
ramp85934003ramp___
rampageous1551943rampageous
rampaging1544513rampaging
rampancy1743693rampancy
ramparted1443543ramparted
ramparts1245583ramparts
ramped114617903ramp_ed
rampikes1635393rampikes
ramping123316873ramping
rampion11298583rampion
rampoles1238893rampoles
ramps96224633ramp__s
range64728413ra__nge
ranpike1335933ranpike
rape65041633ra_p__e
raphae114311733ra_phae
raphe104916423ra_p_he
rapine85023083ra_pine
rapparee1245873rapparee
rappee103618673ra_ppee
ratbag956563ratbag_
ratbags1035763ratbags
ravaged1236493ra_vaged
ravager1136563ra_vager
ravages1139403ra_vages
redamage1244193redam_age
reimage1037913reimage
remade94316983rem_ade
remake124016113rem_ake
remate84428683rem_ate
remerge10148923remerge
repave114813873r_epave
respace11310913respace
respade1039573respade
restage83316193restage
rimple103814583rimp_le
rivage1038843r_ivage
rootage839053rootage
rummaged1443273rummaged
rummager1343593rummager
rummages1344933rummages
rumple103913013rump_le
salpae84614273salpa_e
salvage1138193salvage
sampan102511893sampa_n
sampans112411003sampans
sample104215013samp_le
sausage847193sausage
savage10410173sa_vage
scrappage1642443scrappage
seepage1037543seepage
stumpage1343303stumpage
tallage82712073tallage
tamale83717403tam_ale
tampala1136613tampala
tampan102512323tampa_n
tampans113310983tampans
tankage12257773tankage
tannage8209583tannage
trackage1545653trackage
trample11299703tramp_le
vampire14296673vampire
vantage11109893vantage
waftage14115323waftage
wantage11119623wantage
warpages1437053warpages
wastage11109253wastage
wattage1186983wattage
webpage1543133webpage
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.423422437.4
2DLD Change Limit1340271676.89019452.4
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.37624226.0
 
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.