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 “reset” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

201 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
reset5505186(None) 
beset76739131beset
preset84430981preset
reest54938091reest
relet54749821relet
remet74843721remet
resat55139681resat
reseat64131491reseat
resect84424701resect
resee54336331resee
resent63833621resent
resets65427611resets
resew84519501resew
resit54241041resit
rest46459841res_t
revet84938841revet
rewet85135151rewet
roset55945241roset
asset55932262asset
beet66457542be_et
beget85632562beget
beret74946362beret
beses75830722beses
besets85718802besets
besot76429712besot
best66355322bes_t
brevet115717332brevet
coset75748842coset
cresset93319942cresset
crest74632692cres_t
cruset84425092cruset
deet57356582de_et
desert72725492desert
desex13311982desex
drest65530342dres_t
erses55826802erses
erst47436432ers_t
eses45336102_eses
feet75352212fe_et
fest74949442fes_t
freest95318282freest
freshet133416642freshet
geest64829622geest
genet66038682genet
gest56149132ges_t
geste65920692geste
greet65835322gre_et
hest75950772hes_t
inset54430862inset
jest116738502jes_t
keet85347342ke_et
keyset13411532keyset
leet45957902le_et
leses54930812leses
lest46956322les_t
meet65350552me_et
nest45548732nes_t
onset54730172onset
peseta8310572peseta
pest65555292pes_t
prese75228382prese_
present94022732present
presets94216422presets
prest75736352pres_t
ramet75743142ramet
rase46149982rase_
rased65033932rased
raser55633412raser
rases55447212rases
react74634332react
rebec94416542rebec
rebel73421292rebel
rebut75927382rebut
recent83630852recent
recept103319072recept
recit75235102recit
recut74729242recut
rede55037672rede_
reded74829122reded
redes65139132redes
ree37974072re_e_
reed55549622re_ed
reef74938212re_ef
reek85232522re_ek
reel45240532re_el
rees45364192re_es
reests64618892reests
refect114319332refect
refed93921922refed
refel84920812refel
refelt94521422refelt
refer84822142refer
refit84230062refit
reflet94024232reflet
reft75141272re_ft
regent74127672regent
reges65628792reges
reglet73724232reglet
regret73723532regret
reheat94423942reheat
rehem103815352rehem
reject154116282reject
rekey124014732rekey
relent64431852relent
relets64025672relets
relit55340682relit
remeet86325472remeet
remelt85123122remelt
remex146315792remex
remit75737222remit
renest64529712renest
renew83917512renew
rennet64624852rennet
rent46661242re_nt
rente54733782rente
repeat85127212repeat
repeg84015052repeg
repel74921402repel
repent84728872repent
repot75132622repot
rerent63832452rerent
res35565042res__
resaw84117252resaw
resay85320542resay
reseal64819642reseal
reseats74319582reseats
reseau64216212reseau
resects94115592resects
reseda739702reseda
reseed74823292reseed
reseek103813132reseek
reseen64318412reseen
resees63827482resees
resell64215202resell
resend75016772resend
resents74221222resents
resewn9459812resewn
resews94814172resews
resh76523452res_h
reshes94124362reshes
reshot93519632reshot
resid64124092resid
resift94017722resift
resin54131052resin
resist64524532resist
resite64128452resite
resits64725562resits
resmelt9411772resmelt
resod64720052resod
resojet14312822resojet
resort65728622resort
resow88217242resow
respect11412032respect
respelt9312142respelt
respot83117632respot
rested74430782rested
rester63832432rester
rests54935872rests
result6318222result
ret35982832r__et
rete44944132rete_
retem74221952retem
retest64028452retest
reuse56025362reuse_
reused75419562reused
reuses66025522reuses
revel84423162revel
revert93529112revert
revest94623602revest
revets94022172revets
rewed95425452rewed
rewets94617212rewets
rexes124526952rexes
rise45945232rise_
risen54621882risen
riser55431052riser
rises55244042rises
rivet85636362rivet
rose46148902rose_
rosed65930342rosed
roses56445772roses
rosets65819952rosets
ruse45938932ruse_
ruses56136582ruses
russet6319432russet
rust45544912rus_t
sestet6826202sestet
set36681252__set
tenet55542212tenet
test48651622tes_t
trevet94818912trevet
unset54532432unset
upset73222592upset
verset94327322verset
vest75743602ves_t
weest85026772weest
weet75254152we_et
west75748082wes_t
wrest84925432wres_t
yeses85119322yeses
zest136035702zes_t

Search took 5 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 Filter178691538000.626285448.9
2DLD Change Limit538002013.26316487.9
3Display Results2012010.1261595.2
 (SQL Overall)1786912014.01544505.9
 
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.