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 “rampager” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
rampager134445(None) 
rampage1237451rampage_
rampaged1434101rampaged
rampagers1443861rampagers
rampages1336671rampages
damager1157972dam_ager
ravager1136562ra_vager
rummager1343592rummager
ambage11510603_ambage_
ambages1269623_ambages
ampler104313303_amp_ler
armiger1036253arm_iger
bandager1237703bandager
campagna1543413campagna
campagne1544413campagne
campaigner1751953campaigner
camper124722213camp__er
campier133313273camp_ier
capmaker1855203capmaker
comparer143611363comparer
crampier14288903cramp_ier
damage10410773dam_age_
damaged1257453dam_aged
damagers1237063dam_agers
damages11511273dam_ages
dampener1335533dampener
damper114117753damp__er
empaler11288353_empaler
hamper134518653hamp__er
hamperer15379093hamperer
homager13107853hom_ager
imager9108123_im_ager
impaler11298393_impaler
laager74312783la__ager
lampases1267293lampases
manager103413583ma_nager
mapmaker1864373mapmaker
massager1136873massager
meager94515203__meager
packager17136153packager
pager84728203___pager
pamper124316663pamp__er
pamperer14228333pamperer
ramate83921683ram_ate_
rambler113313263ram_bler
rammer103519653ram__mer
rammier112811023ram_mier
rampageous1551943rampageous
rampaging1544513rampaging
rampancy1743693rampancy
rampant11312173rampa_nt
rampart11311993rampa_rt
ramparted1443543ramparted
ramparts1245583ramparts
ramped114617903ramp__ed
rampike1536603rampike_
rampikes1635393rampikes
rampole1139693rampole_
rampoles1238893rampoles
ranger73925523ra__nger
raper74932753ra_p__er
rapider1067903ra_pider
rapier84019993ra_p_ier
rapparee1245873rapparee
rapper104621573ra_p_per
rasper83917333rasp__er
raspier93110643rasp_ier
ratepayer1442133ratepayer
ravage1039303ra_vage_
ravaged1236493ra_vaged
ravagers1235583ra_vagers
ravages1139403ra_vages
remaker133813173rem_aker
repaper11310023r_epaper
romper104213683romp__er
rummage1234583rummage_
rummaged1443273rummaged
rummagers1443033rummagers
rummages1344933rummages
rumplier1235303rumplier
salvager1235593salvager
sampler113212013samp_ler
savager1137133sa_vager
tamper104618513tamp__er
tamperer12248893tamperer
tanager83010943ta_nager
tarpaper1244603tarpaper
taxpayer2041813taxpayer
tramper113812163tramp__er
trampier12318243tramp_ier
trampler12278013tramp_ler
vamper134212653vamp__er
vampier14308233vamp_ier
warpage1336403warpage_
warpages1437053warpages

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 Filter1786911461620.406440125.6
2DLD Change Limit146162956.93621073.0
3Display Results95950.0462065.2
 (SQL Overall)178691957.38824186.7
 
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.