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

132 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
rampart1131199(None) 
rampant11312171rampant
ramparts1245581ramparts
apart74330672_a_part
compart134016002compart
impart102715142_impart
rampage1237452rampage
ramparted1443542ramparted
rapport11311222rapport
ambari103012173_ambari
ambary134010543_ambary
amort75832203_am_ort
ampere10514413_ampere
aport75432173_a_port
apparat11711713_apparat
armpit10811093armp_it
braggart1245613braggart
brassart1047503brassart
camper124722213camper_
campers134220293campers
campout13412853campout
carport11316033carport
compact153712213compact
compare135814993compare
comparts144210833comparts
comport133616843comport
crampit1338863cramp_it
damar84117733dam_ar_
damars93814993dam_ars
dammar11438903dammar_
dammars12308193dammars
damper114117753damper_
dampers123915693dampers
dampest12411043dampest
depart94720563_depart
dispart101115283dispart
dumpcart1543463dumpcart
gabbart1248883gabbart
gramary1355903gram_ary
grammar12406893grammar_
grammars13345943grammars
grampa115010173grampa__
grampas12399253grampa_s
hamper134518653hamper_
hampers143616953hampers
impact122310453_impact
impark14287073_impark
imparts11298533_imparts
import102713763_import
lambast11129893lambast
lambert113617113lambert
lampad114510033lampa_d
lampads12477623lampads
lampas106615953lampa_s
lampers113817333lampers
mammary1335993mammary
mart66865983__m_art
mispart111113773mispart
pampa114913423pampa__
pampas124913993pampa_s
pamper124316663pamper_
pampero13328093pampero
pampers133615933pampers
part65967463___part
rabat72832223ra_ba_t
radar61316723ra_dar_
radars71314673ra_dars
radiant82817133radiant
ragwort11510743ragwort
ramada9310183ram_ada
ramal74622243ram_a_l
ramate83921683ram_ate
ramet75743143ram__et
ramjet15311543ram_jet
rammer103519653rammer_
rammers113715043rammers
ramp85934003ramp___
rampaged1434103rampaged
rampager1344453rampager
rampagers1443863rampagers
rampages1336673rampages
rampancy1743693rampancy
rampantly1643493rampantly
ramparting1543893ramparting
ramped114617903ramp_ed
rampike1536603rampike
ramping123316873ramping
rampion11298583rampion
rampole1139693rampole
ramps96224633ramp__s
raper74932753ra_per_
rapers84327183ra_pers
rapist82520673ra_pist
rapparee1245873rapparee
rapper104621573rapper_
rappers113618443rappers
rapports1245963rapports
rapt67245313ra_p__t
rasper83917333rasper_
raspers94415923raspers
rechart12314323rechart
reimport1246503reimport
remark123512373rem_ark
remnant9312633remnant
repark123511713r_epark
repast83520633r_epast
report85326023r_eport
restart7320033restart
romper104213683romper_
rompers113412243rompers
samara8313853sam_ara
sambar103914163sambar_
sambars115113843sambars
sampan102511893sampa_n
sampans112411003sampans
samsara936913samsara
smart75834093_sm_art
subpart11311123subpart
tamari8313403tam_ari
tampala1136613tampala
tampan102512323tampa_n
tampans113310983tampans
tamper104618513tamper_
tampers113516743tampers
tramcar1135593tramcar_
tramcars1245233tramcars
tramper113812163tramper_
trampers123210393trampers
tripart9311433tripart
vamper134212653vamper_
vampers143111623vampers
vampire14296673vampire

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.420425454.8
2DLD Change Limit1340271326.80019709.9
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.26624592.8
 
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.