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

203 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
revamps143399(None) 
revamp1336011revamp_
decamps1435642decamps
preamps1336612pre_amps
ramps96224632r__amps
reams75729622re_am_s
reaps75626192re_a_ps
recaps103615732reca_ps
remaps105012872rema_ps
renames92418052renames
repumps1334402repumps
restamps1234702restamps
revamped1634142revamped
revamper1533532revamper
revampers1653442revampers
vamps125415482__vamps
abamps1236253_abamps
amps86230343___amps
beams95328173be_am_s
becaps123811403beca_ps
bedamns1235733bedamns
bedlamps1543663bedlamps
benames112814603benames
breams104815043bre_am_s
camps116330263__camps
champs154915683_champs
clamps124515083_clamps
cramps125615563_cramps
creams104715253cre_am_s
damps105220413__damps
decamp1338453decamp_
defames132812253defames
degames113312623degames
degamis11268443degamis
devas96218883deva__s
dreams94513983dre_am_s
encamps1335423encamps
evades1039023_evades
exams14199083_exam_s
firedamps1742843firedamps
gamps105323713__gamps
gramps114114273_gramps
heaps105223223he_a_ps
hemps126917333he__mps
kemps135012523ke__mps
lamps95624833__lamps
leaps75522933le_a_ps
levants1037723levants
metumps1334133metumps
neaps75618323ne_a_ps
preamp1238993pre_amp_
pregames1339003pregames
prenames12311643prenames
prestamps1543523prestamps
prevails1337663prevails
ramp85934003r__amp_
rams65950773r__am_s
ramus76418283r__amus
raps66247733r__a_ps
rasps74316663r__asps
ravages1139403ravages
reacts83616603re_acts
readds84111643re_adds
reads64835273re_a_ds
reales64934123re_ales
realms84913493re_alms
reals55038653re_a_ls
ream65841613re_am__
reamed94326123re_amed
reamer84325213re_amer
reamers94221083re_amers
reap65934743re_a_p_
rearms85114653re_arms
rears54739653re_a_rs
reatas64021013re_atas
reavails1134853reavails
reavers108320743reavers
reaves94127573re_aves
reavows1335273reavows
rebaits9312573rebaits
rebars84019833reba_rs
rebates95123183rebates
rebatos92913113rebatos
rebops10311433re_bops
recalls92613623recalls
recanes93222263recanes
recants93217093recants
recap95718023reca_p_
recasts93413533recasts
reclames12310893reclames
reclasps1235053reclasps
recombs1336753recombs
recoups1188843recoups
redacts10510943redacts
redans75421023reda_ns
redates83423873redates
redcaps1247073redcaps
redips93713843re_dips
redtops1037373redtops
reearns749103reearns
refaces123216743refaces
refalls103312243refalls
reframes1338993reframes
regains84316583regains
regales83520793regales
regards94112563regards
regimes104514743regimes
rehabs1139023reha_bs
rehangs1137563rehangs
rehems113410983rehem_s
relaces93420883relaces
relands85214883relands
relapse947703rela_pse
relates73731433relates
relaxes143215323relaxes
relays94316753rela_ys
relumes9612513relumes
remails94714563remails
remains94117913remains
remakes134116173remakes
remands104914883remands
remans84823003rema_ns
remap95418103rema_p_
remarks13329983remarks
remates93827113remates
rems66237723re__m_s
renails74917263renails
rename82718813renam_e
renamed103114523renamed
repacks15269543repacks
repairs9319973repairs
reparks13249513reparks
repass84114703repa_ss
repasts93611933repasts
repaves123513653repaves
repays113813973repa_ys
repps95114343re__pps
reps65937953re___ps
repump1235683repump_
reracks132310533reracks
resails74616743resails
resales74724903resales
resample1244673resample
resamples1344713resamples
resaws93713513resa_ws
resays93714153resa_ys
reships1239863reships
restamp1146483restamp_
resumes9313373resumes
retacks132210713retacks
retags73414303reta_gs
retails74718973retails
retains74522253retains
retakes113718863retakes
retape83917683reta_pe
retapes93917423retapes
retards85015003retards
retaxes143615093retaxes
reteams9339563reteam_s
retems83914573retem_s
retimes95020173retimes
revalue1038153revalue
revalues1137883revalues
revamping1734633revamping
reveals103812723reveals
revels94220573rev_els
reverbs12368863reverbs
reveres103621343reveres
revers94529633rev_ers
reverts104715043reverts
revests104413733revests
revets94022173rev_ets
reviews1335533reviews
reviles104421353reviles
revises104220533revises
revives134715543revives
revokes144212503revokes
revolts1038893revolts
revotes104716393revotes
revs75027053rev___s
revues9813903rev_ues
rewakes144614983rewakes
rewards114813993rewards
rewarms12439603rewarms
rewaxes173911333rewaxes
rewraps12136563rewraps
rivages1138873rivages
rivals94213183riva_ls
roams74919613r_oam_s
romps94617543r__omps
rumps95922293r__umps
samps96124673__samps
scamps125014173_scamps
seams75731663se_am_s
sesames9310743sesames
stamps105614023_stamps
swamps135910263_swamps
tamps95524093__tamps
teams75726513te_am_s
temps95417133te__mps
tramps105114453_tramps
vamp115521543__vamp_
vampy15539403__vampy

Search took 10 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.440406115.9
2DLD Change Limit1340272038.90315054.1
3Display Results2032030.0802537.5
 (SQL Overall)1786912039.42318963.3
 
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.