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

187 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
rampant1131217(None) 
rampart11311991rampart
radiant82817132radiant
rampage1237452rampage
rampancy1743692rampancy
rampantly1643492rampantly
ramparts1245582ramparts
ramping123316872ramping
remnant9312642remnant
sampan102511892sampan_
sampans112411002sampans
tampan102512322tampan_
tampans113310982tampans
adamant101110443adam_ant
alant55742293_a_lant
ament76036543_am_ent
amount8414483_amount
amping114317573_amping
apart74330673_a_part
armband1265983armband
armpit10811093armp_it
arpent84822093_arpent
arrant6623253_arrant
askant10412713_askant
aslant6317753_aslant
avant86224663_a_vant
callant94121223callant
campagna1543413campagna
campagne1544413campagne
camping143118973camping
campong14318123campong
campout13412853campout
clamant11312433clam_ant
compact153712213compact
company1619711143company
compart134016003compart
cramping153411853cramping
crampit1338863cramp_it
crampon1336943crampon_
crampons1436643crampons
daman84821163dam_an_
damans94715983dam_ans
damiana1046563damiana
dampen114310593dampen_
dampens12348563dampens
dampest12411043dampest
damping133414003damping
dopant9316133_dopant
emanant9411093emanant
erumpent1245453erumpent
fragrant1247113fragrant
gallant83517113gallant
gardant9314463gardant
grampa115010173grampa__
grampas12399253grampa_s
impact122310453_impact
impaint11511223_impaint
impart102715143_impart
implant11311333_implant
japan14411233ja_pan_
japans1539823ja_pans
kampong16294933kampong
lambast11129893lambast
lambent113711303lambent
lament85024943lam_ent
lampad114510033lampa_d
lampads12477623lampads
lampas106615953lampa_s
lamping123116003lamping
meant76537213__meant
natant6318733na_tant
pageant10312783pageant
pampa114913423pampa__
pampas124913993pampa_s
pampean1335543pampean_
pampeans1444703pampeans
pant66061263___pant
passant9813943passant
pompano1345203pompano
rabat72832223ra_ba_t
radian74117273radian_
radians83013823radians
radiants9259443radiants
raglan73711503raglan_
raglans82410133raglans
ragman94013713ragman_
raiment9315413raiment
ramada9310183ram_ada
ramal74622243ram_a_l
ramate83921693ram_ate
ramen75625193ram_en_
ramenta9311183ram_enta
ramet75743143ram__et
ramjet15311543ram_jet
ramming123115063ramming
ramona8412413ram_ona
ramonas9311093ramonas
ramp85934003ramp___
rampaged1434103rampaged
rampager1344453rampager
rampages1336673rampages
rampaging1544513rampaging
ramparted1443543ramparted
ramped114617903ramp_ed
rampike1536603rampike
rampion11298583rampion
rampions12248023rampions
rampole1139693rampole
ramps96224633ramp__s
ramson8310463ramson_
ramsons939563ramsons
randan7315253randan_
randans8313213randans
rant45864683r___ant
rapine85023083ra_pine
raping94829853ra_ping
rapini84714683ra_pini
rapist82520673ra_pist
rappen103512713rappen_
rapping123619103rapping
rappini11347573rappini
rapport11311223rapport
rapt67245313ra_p__t
rasping104316253rasping
ratan53722663ra_tan_
ratans63819373ra_tans
ratany93411873ra_tany
rattan63613603rattan_
rattans73411953rattans
reactant10311433reactant
reboant9315093reboant
recant83228683r_ecant
regnant8312843regnant
regrant8317323regrant
reimplant1395303reimplant
reliant7319243reliant
reman75730153rem_an_
remand95618963rem_and
remans84823003rem_ans
remint85329983rem_int
remnants1036843remnants
remount9512283remount
repaint9318363r_epaint
repand95316063r_epand
repast83520633r_epast
repent84728873r_epent
replant93318533replant
reptant92817073reptant
riant55833153r__iant
rimland1035663rimland
roman75424823rom_an_
romano84912943rom_ano
romans84620243rom_ans
romaunt947803romaunt
romping123113033romping
ruminant1047863ruminant
saltant7316773saltant
savant9416043sa_vant
taggant9310223taggant
taipan82410663taipan_
taipans9269553taipans
tampala1136613tampala
tamping122815813tamping
tampon102911233tampon_
tampons112711563tampons
tarpan82814293tarpan_
tarpans92513533tarpans
timpana11226133timpana
timpani11266153timpani
timpano11235863timpano
tramping132711273tramping
trapan82412973tra_pan_
trapans92812463tra_pans
tympan13257013tympan_
tympana14255853tympana
tympani14275923tympani
tympano14245283tympano
tympans14236813tympans
tympany17254603tympany
unmeant9510903unmeant
vacant11415133va_cant
vagrant11410663vagrant
valiant10314623valiant
vamping152810233vamping
variant10316803variant
warrant10614243warrant
waxplant20144603waxplant

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.390458182.1
2DLD Change Limit1340271877.08018930.4
3Display Results1871870.0762460.5
 (SQL Overall)1786911877.54623680.2
 
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.