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

260 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
revamp133601(None) 
revamps1433991revamps
decamp1338452decamp
preamp1238992pre_amp
ramp85934002r__amp
ream65841612re_am_
reams75729622re_ams
reap65934742re_a_p
recap95718022reca_p
remap95418102rema_p
rename82718812rename
repump1235682repump
restamp1146482restamp
revamped1634142revamped
revamper1533532revamper
vamp115521542__vamp
abamp11310603_abamp
amp77541023___amp
beam86939233be_am_
beams95328173be_ams
beamy126218573be_amy
became123213163became
becap114315053beca_p
bedamn1137813bedamn
bedlamp1464513bedlamp
bename103316073bename
bream95121813bre_am_
breams104815043bre_ams
camp106336453__camp
champ145017963_champ
clamp115517653_clamp
cramp115120693_cramp
cream95721353cre_am_
creams104715253cre_ams
creamy134811363cre_amy
damp96228843__damp
decamps1435643decamps
defame123212433defame
degame102713183degame
degami10279013degami
deva85720983deva__
devas96218883deva_s
dream85120393dre_am_
dreams94513983dre_ams
dreamt94615713dre_amt
dreamy12509993dre_amy
encamp1235943encamp
evade938183_evade
exam132514623_exam_
exams14199083_exams
firedamp1643743firedamp
gamp98833213__gamp
gramp106218323_gramp
heap96432893he_a_p
hemp115725623he__mp
kemp126418763ke__mp
lamp86233823__lamp
leap66032683le_a_p
leva77020713leva__
levant9314493levant
metump1235713metump
neap66927013ne_a_p
preamps1336613pre_amps
pregame1239553pregame
prename11412643prename
prestamp1445323prestamp
prevail1238243prevail
ram56867273r__am_
rami66034093r__ami
ramps96224633r__amps
rams65950773r__ams
rap56261963r__a_p
rasp66029163r__asp
ravage1039303ravage
reach105123883re_ach
react74634333re_act
read55942533re_a_d
readd74617133re_add
reads64835273re_ads
ready94821503re_ady
real45750293re_a_l
realm75621623re_alm
realms84913493realms
reals55038653re_als
reamed94326123re_amed
reamer84325213re_amer
reaps75626193re_aps
rear45644553re_a_r
rearm75923573re_arm
rearms85114653rearms
rears54739653re_ars
reata54225393re_ata
reavail1035643reavail
reave84528023re_ave
reaved104523923reaved
reaver94524733reaver
reaves94127573reaves
reavow1235723reavow
rebait8320403rebait
rebar75420193reba_r
rebars84019833rebars
rebate84424113rebate
rebato83714683rebato
rebop9313283re_bop
recall83815723recall
recane83022873recane
recant83228683recant
recaps103615733recaps
recast83422773recast
reclame11411063reclame
reclasp1136643reclasp
recomb1238873recomb
recoup10810373recoup
redact9419043redact
redan66125013reda_n
redans75421023redans
redate74124683redate
redcap1158493redcap
redip87816963re_dip
redtop937973redtop
reearn6612143reearn
reface113616353reface
refall94314393refall
reframe1239393reframe
regain74517763regain
regal65023793rega_l
regale74821453regale
regard85215773regard
regave104713383regave
regime95313943regime
regma84612333re_gma
rehab10312443reha_b
rehabs1139023rehabs
rehang1039823rehang
rehash1237433rehash
rehem103815353rehem_
rehems113410983rehems
relace83122153relace
relaid75518443relaid
reland75920433reland
relate64033633relate
relax124817803rela_x
relay84424673rela_y
relays94316753relays
relume8313273relume
rem56150043re__m_
remade94316983remade
remail85017123remail
remain85919863remain
remake124016113remake
reman75730153rema_n
remand95618963remand
remans84823003remans
remaps105012873remaps
remark123512373remark
remate84428683remate
rems66237723re__ms
renail65020763renail
renal55929503rena_l
renamed103114523renamed
renames92418053renames
rep55847803re___p
repack142412163repack
repaid94716323repaid
repair84011463repair
repand95316063repand
repark123511713repark
repass84114703repass
repast83520633repast
repave114813873repave
repay104818453repa_y
repays113813973repays
repp85418743re__pp
repumps1334403repumps
rerack122513163rerack
reran57329103rera_n
resaid74517083resaid
resail64418733resail
resale64025543resale
resample1244673resample
resat55139683resa_t
resaw84117253resa_w
resawn9399953resawn
resaws93713513resaws
resay85320543resa_y
resays93714153resays
reship11310673reship
restamps1234703restamps
resume8313783resume
retack122612823retack
retag63618413reta_g
retags73414303retags
retail65522073retail
retain64523283retain
retake104718533retake
retape83917683retape
retard75018933retard
retax124517973reta_x
reteam83214533reteam_
reteams9339563reteams
retem74221953retem_
retems83914573retems
retime85321803retime
rev65336623rev___
revalue1038153revalue
revampers1653443revampers
revamping1734633revamping
reveal94115053reveal
reveals103812723reveals
revel84423163rev_el
revels94220573revels
reverb113912573reverb
revere94621253revere
revers94529633revers
revert93529113revert
revery124014213revery
revest94623603revest
revet84938843rev_et
revets94022173revets
review1238693review
revile94921613revile
revise94019743revise
revive124914823revive
revoke135216243revoke
revolt9316223revolt
revote94917453revote
revs75027053rev__s
revue81114453rev_ue
revues9813903revues
revved13469723revved
rewake135218463rewake
rewan85623663rewa_n
reward106017643reward
rewarm115913493rewarm
rewarms12439603rewarms
rewash1237673rewash
rewax155713923rewa_x
rewrap11127533rewrap
rivage1038843rivage
rival85216503riva_l
rivals94213183rivals
roam67132413r_oam_
roams74919613r_oams
romp85926573r__omp
rump86729083r__ump
samp85733593__samp
scamp115717313_scamp
seam66645973se_am_
seams75731663se_ams
seamy105921273se_amy
sesame8311013sesame
stamp95217363_stamp
swamp125015323_swamp
tamp86133003__tamp
team66238653te_am_
teams75726513te_ams
temp85323333te__mp
tramp96319773_tramp
vamps125415483__vamps
vampy15539403__vampy

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 Filter1786911127160.406440125.6
2DLD Change Limit1127162607.06315958.7
3Display Results2602600.0763421.1
 (SQL Overall)1786912607.54523683.4
 
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.