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

105 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
rampaged143410(None) 
rampage1237451rampage_
rampager1344451rampager
rampages1336671rampages
damaged1257452dam_aged
rampagers1443862rampagers
ramparted1443542ramparted
ramped114617902ramp__ed
ravaged1236492ra_vaged
rummaged1443272rummaged
amazed18519313_am_azed
ambage11510603_ambage_
ambages1269623_ambages
amped104820513_amp__ed
bandaged1337313bandaged
barraged1297683barraged
cabbaged1644383cabbaged
campagna1543413campagna
campagne1544413campagne
campaigned1842153campaigned
camped134720233camp__ed
campused1535253campused
compared153811823compared
cramped144712183cramp__ed
damage10410773dam_age_
damager1157973dam_ager
damages11511273dam_ages
damped124315583damp__ed
dampened1435623dampened
empaled12288953_empaled
garaged1039253ga_raged
hampered16239933hampered
homaged1497413hom_aged
imaged1097763_im_aged
impaled12288513_impaled
jampacked2742053jampacked
lampad114510033lampa__d
lampases1267293lampases
lamped114017543lamp__ed
managed113212603ma_naged
massaged1236753massaged
mispaged1438243mispaged
oompahed1642903oompahed
packaged18115753packaged
paged95926783___paged
palpated13249763palpated
pampered15229233pampered
passaged1236243passaged
radiated102512593radiated
raged74829453r___aged
ragged94620263ra__gged
ralphed1334363ralp_hed
ramate83921683ram_ate_
rambled123913523ram_bled
ramified1438043ramified
rammed113117303ram__med
rampageous1551943rampageous
rampaging1544513rampaging
rampancy1743693rampancy
rampant11312173rampa_nt
rampart11311993rampa_rt
ramparts1245583ramparts
rampike1536603rampike_
rampikes1635393rampikes
rampole1139693rampole_
rampoles1238893rampoles
ranged84824313ra__nged
raped85334623ra_p__ed
rapparee1245873rapparee
rapped114122683ra_p_ped
rappeled1335003rappeled
rasped94715203rasp__ed
ravage1039303ra_vage_
ravager1136563ra_vager
ravages1139403ra_vages
redamaged1443343redam_aged
reimaged1246173reimaged
remapped1534913remapped
remated103522473rem_ated
remerged12149173remerged
repaved133311133r_epaved
respaced1338503respaced
respaded1238133respaded
restaged103011863restaged
rimpled123311423rimp_led
romped114513653romp__ed
rumbaed12287493rumba_ed
rummage1234583rummage_
rummager1343593rummager
rummages1344933rummages
rumpled123810013rump_led
salvaged1335363salvaged
sambaed1238303samba_ed
sampled123410793samp_led
savaged1236993sa_vaged
tallaged10257923tallaged
tamped114317043tamp__ed
tampered13279463tampered
tamponed1336023tamponed
tramped124312433tramp__ed
trampled13247903tramp_led
unpaged113311043_unpaged
vamped144211013vamp__ed
warpage1336403warpage_
warpages1437053warpages

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621056.36022981.4
3Display Results1051050.0462282.6
 (SQL Overall)1786911056.82626178.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.