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

222 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
repump123568(None) 
repumps1334401repumps
metump1235712metump
pump105726852__pump
relume8313272relume
replumb1343392replumb
repp85418742rep__p
repugn946492repugn
repumped1534382repumped
repute84716092repute
resume8313782resume
revamp1336012revamp
rump86729082r__ump
bedumb1335063bedumb
begum105213923begum_
begums11429493begums
benumb1235773benumb
bethump1642823bethump
bump106228243__bump
cecum11611843cecum_
chump145315443_chump
clump115517453_clump
crump115616423_crump
decamp1338453decamp
degum94711903degum_
degums10438623degums
deplume1255063deplume
depute94512303depute
deputy12426713deputy
dump95927093__dump
equip16467263_equip
flump124614723_flump
frenum1188803frenum_
frenums1236203frenums
frump126912563_frump
gazump2032453gazump
getup83410263getu_p
geum75424553ge_um_
geums85414113ge_ums
grump105115313_grump
heaume1137543heaume
hemp115725623he__mp
hump116228723__hump
jump156621723__jump
kemp126418773ke__mp
legume936913legume
letup73712163letu_p
lump86531703__lump
metumps1334133metumps
mump105425723__mump
neum66723083ne_um_
neume74414403ne_ume
neums75414253ne_ums
overpump1743723overpump
peplum12156823peplum_
peplums13145503peplums
pimp106024913__pimp
plump115315263_plump
pomp106225463__pomp
preamp1238993pre_amp
prepuce1337833prepuce
prepupa1064023prepupa
presume11310303presume
pulp84825353__pulp
puma85424123__puma
pumps115520603__pumps
pup76339883__pu_p
ramp85934003r__amp
realm75621623realm_
realms84913493realms
ream65841613re_am_
reams75729623re_ams
reap65934743re__ap
rearm75923573rearm_
rearms85114653rearms
rebop9313283re_bop
rebuff1437023rebuff
rebuke124010123rebuke
rebury11349213rebury
rebus75721113rebu_s
rebut75927383rebu_t
rebuts84015193rebuts
rebuy104714683rebu_y
rebuys11428783rebuys
recap95718023re_cap
recomb1238873recomb
recoup10810373recoup
rectum103411283rectum_
rectums11338523rectums
recur74116843recu_r
recurs83315803recurs
recuse85519163recuse
recut74729243recu_t
recuts83817373recuts
redcap1158493redcap
redip87816963re_dip
redtop937973redtop
redub84212413redu_b
redubs9358383redubs
reduce9713253reduce
redux133811103redu_x
reequip1842423reequip
refuel93912623refuel
refuge105312613refuge
refund104810303refund
refuse94817513refuse
refute95515703refute
regime95313943regime
regma84612333re_gma
regnum957163regnum_
reguli738143reguli
rehem103815353rehem_
rehems113410983rehems
rehung1036343rehung
reluct83916113reluct
relumed1069813relumed
relumes9612513relumes
rem56150043re__m_
remap95418103re_map
rems66237723re__ms
remuda936823remuda
rename82718813rename
rep55847803re___p
repack142412163repack
repaid94716323repaid
repair84011463repair
repand95316063repand
repark123511713repark
repass84114703repass
repast83520633repast
repave114813873repave
repay104818453rep_ay
repays113813973repays
repeal84718293repeal
repeat85127213repeat
repeg84015053rep_eg
repegs93311943repegs
repel74921403rep_el
repels84318763repels
repent84728873repent
reperk122511773reperk
repin75324703rep_in
repine85627813repine
repins84924313repins
replan83215823replan
replay113412923replay
repled93319783repled
replot83818593replot
replow114210343replow
replumbs1442183replumbs
reply104015853rep_ly
repo66027543rep__o
repoll8410793repoll
report85326023report
repos74725793rep_os
repose84121413repose
repot75132623rep_ot
repots85621003repots
repour8310993repour
repours9310233repours
repped114616723repped
repps95114343rep_ps
repro75315913rep_ro
repros84216003repros
reps65937953rep__s
repugns1035393repugns
repulse938193repulse
repumping1634813repumping
reputed104613483reputed
reputes94615963reputes
requin15310713requin
rerun58722153reru_n
reruns66413743reruns
reship11310673reship
restamp1146483restamp
result6318223result
resumed10310623resumed
resumer9410113resumer
resumes9313373resumes
retem74221953retem_
retems83914573retems
retime85321803retime
retune69121953retune
return623222523return
retuse66617223retuse
reuse56025363re_use
revamps1434003revamps
revue81114453revu_e
revues9813903revues
rewrap11127533rewrap
rheum1038843rheum_
rheums1135463rheums
rheumy1433353rheumy
rhumb12438653r_humb
riprap1055513riprap
romp85926573r__omp
roup66627693r_ou_p
rum56644643r__um_
rumps95922293r__umps
rums64833473r__ums
sebum93814553sebum_
sebums10369813sebums
sedum84115573sedum_
sedums93910483sedums
septum1038003septum_
septums1135743septums
serum75223473serum_
serums83916303serums
setup73915823setu_p
shlump1345713shlump
slump94816633_slump
spume95817313_spume
spumy124610363_spumy
stump94616463_stump
sump86331533__sump
temp85323333te__mp
thump126211573_thump
trump95615123_trump
tump85927033__tump
ump76130443___ump
velum10713383velum_
whump154910043_whump

Search took 6 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.420425454.8
2DLD Change Limit1127162225.48620546.1
3Display Results2222220.0603700.0
 (SQL Overall)1786912225.96629951.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.