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

424 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
reshot9351963(None) 
reshod103012231reshod
reshoe92816481reshoe
reshoot102513891reshoot
reshow123111431reshow
respot83117631respot
beshout12311832beshout
besot76429712bes_ot
despot93413292despot
escot75320082_escot
eyeshot1386542eyeshot
freshet133416642freshet
preshow15237412preshow
reboot84119332reboot
reknot10311732reknot
replot83818592replot
repot75132622re_pot
resat55139682res_at
reseat64131492reseat
resect84424702resect
resent63833622resent
reset55051862res_et
resh76523452resh__
reshes94124362reshes
reship11310672reship
reshoed112212152reshoed
reshoes102316032reshoes
reshone102414162reshone
reshoots11228412reshoots
reshown13257902reshown
reshows132510452reshows
resift94017722resift
resist64524532resist
resit54241042res_it
resod64720052res_od
resort65728612resort
resow88217242res_ow
respots92912762respots
rest46459842res__t
result6318222result
rimshot1246212rimshot
shot76150242__shot
upshot1138452upshot
airshot1059493airshot
ascot76522513_ascot
begot84625953be_got
beknot1239763beknot
beset76739133bes_et
beshouts1346763beshouts
besmut10310653besmut
besnow1145713besnow
besom95716973bes_om
besots86415453bes_ots
best66355323bes__t
bestow1149463bestow
birdshot1444193birdshot
bishop1336943bishop
bowshot1578253bowshot
cashoo11312253cashoo
cestoi84511953cestoi
cestos84718093cestos
cresol8310203cres_ol
cresset93319943cresset
crest74632693cres__t
cushat113513693cushat
dashpot1346123dashpot
dehort104618103de_hort
depot85727923de_pot
desalt7518313desalt
desert72725493desert
desist74818813desist
despots10319683despots
drest65530343dres__t
dropshot1445073dropshot
earshot10410823earshot
echo96615953_echo_
echos105216463_echos
echt95722903_ech_t
ephod1139123_ephod
ephor10310013_ephor
ergot65422893_ergot
erst47436433ers__t
escort84616483_escort
escots84211743_escots
estop74312103_estop
ethos85514193_ethos
exhort16410803_exhort
eyeshots1453373eyeshots
eyespot1265413eyespot
fest74949443fes__t
fleshpot1643843fleshpot
foreshow1785893foreshow
fresco1136473fresco_
frescos1236813frescos
fresh115012203fresh__
freshed143312593freshed
freshen133010883freshen
fresher132612643fresher
freshes133515823freshes
freshest143010583freshest
freshets14298673freshets
freshly16286833freshly
gemot84024233ge_mot
gesso649603gesso_
gest56149133ges__t
grapeshot1552883grapeshot
gunshot1156643gunshot
helot85332683he_lot
heriot9422343heriot
hest75950773hes__t
hipshot15106643hipshot
hot67776053___hot
hotshot1358343hotshot
jest116738503jes__t
jesuit1339583jesuit
lesbo739253lesbo_
lesbos837403lesbos
lesion64715063lesion
lesson64412043lesson
lessor64010603lessor
lest46956323les__t
mascot104016073mascot
merlot83217603merlot
mesh96823003mesh__
meshed124415933meshed
meshes115019443meshes
meshy135612783mesh_y
meson74118313mes_on
method1239023method
mishit112618193mishit
nest45548733nes__t
nestor63713413nestor
outshot10312103outshot
overhot13411223overhot
overshot1449433overshot
parashot13410143parashot
peso66925823pes_o_
pesos77221623pes_os
pest65555293pes__t
pesto75723723pesto_
pestos84719083pestos
phot95534353__phot
potshot1249733potshot
preriot9316413preriot
present94022723present
preset84430983pres_et
preship1439793preship
preshown16255633preshown
preshows16267013preshows
presift12312223presift
presort95219533presort
pressor93512873pressor
prest75736353pres__t
presto84216203presto_
prestos93716073prestos
rachet115028973rachet
rash76039933rash__
rasher95024113rasher
rashes95330153rashes
rashest103916873rashest
rashly123410213rashly
react74634333re_act
readopt10410843readopt
readout8615493readout
reallot7312133reallot
reason62616333reason
reassort8410683reassort
reavow1235723reavow
rebait8320403rebait
rebato83714683rebato
rebook125213203rebook
reboots93512093reboots
rebop9313283re_bop
rebut75927383re_but
recant83228683recant
recast83422773recast
recent83630853recent
recept103319073recept
rechart12314323rechart
recheat12415933recheat
rechew14310213rechew
rechose121312043rechose
recit75235103re_cit
reckon123010543reckon
recoat84024273recoat
recon75624243re_con
recook125513923recook
recto74520803recto_
rector84019743rector
rectos85718783rectos
recut74729243re_cut
redact9419043redact
redcoat10410883redcoat
redipt94116743redipt
redo56029363re_do_
redon65424883re_don
redos65126763re_dos
redout71820253redout
redox134714233re_dox
redroot8312903redroot
redshift1544613redshift
redshirt1245853redshirt
redtop937973redtop
reecho11318653reecho_
reedit7617223reedit
reemit8717223reemit
reest54938093re_est
refect114319333refect
refelt94521423refelt
refit84230063re_fit
reflet94024233reflet
refloat10310833refloat
reflow12379653reflow
refront10313263refront
reft75141273re__ft
regent74127673regent
regilt71217493regilt
region74614903region
reglet73724233reglet
reglow10339403reglow
regret73723533regret
regrow10309883regrow
rehab10312443re_hab
reheat94423943reheat
rehem103815353re_hem
reject154116283reject
reknit10312533reknit
reknots1136783reknots
relent64431853relent
relet54749823re_let
relict83623903relict
relist64628413relist
relit55340683re_lit
relook104813743relook
reluct83916113reluct
remeet86325473remeet
remelt85123123remelt
remet74843723re_met
remint85329973remint
remit75737223re_mit
remixt155014853remixt
remote84222603re_mote
renest64529713renest
rennet64624853rennet
rent46661243re__nt
renvoi945863renvoi
repast83520633repast
repeat85127213repeat
repent84728873repent
replots93412633replots
replow114210343replow
repo66027543re_po_
report85326013report
repos74725793re_pos
repots85621003re_pots
repro75315913repro_
repros84216003repros
rerent63832453rerent
reroof9315003reroof
res35565043res___
resaid74517083resaid
resail64418733resail
resale64025543resale
resaw84117253res_aw
resawn9399953resawn
resaws93713513resaws
resay85320543res_ay
resays93714153resays
reschool1344133reschool
rescore95616193rescore
rescue8313003rescue
reseal64819643reseal
reseats74319583reseats
reseau64216213reseau
resects94115593resects
reseda739703reseda
resee54336333res_ee
reseed74823293reseed
reseek103813133reseek
reseen64318413reseen
resees63827483resees
resell64215203resell
resend75016773resend
resents74221223resents
resets65427613resets
resew84519503res_ew
resewn9459813resewn
resews94814173resews
reshape1249043reshape
reshave1338603reshave
reshine102816943reshine
reships1239863reships
reshowed15117063reshowed
reshower14107063reshower
resid64124093res_id
reside74224933reside
resids74219153resids
resifts10378703resifts
resight11510643resight
resign74212583resign
resile64627673resile
resin54131053res_in
resins64528773resins
resiny94617363resiny
resists74414923resists
resite64128453resite
resits64725563resits
resize154117723resize
reslate73520593reslate
resmelt9411773resmelt
resmooth1343633resmooth
resoak10311093resoak
resods74116303resods
resojet14312823resojet
resold73915363resold
resole64624183resole
resorb84914343resorb
resorts74817193resorts
resown94112923resown
resows93915353resows
respect11412033respect
respelt9312143respelt
respite9513033respite
resplit9310373resplit
respoke134311283respoke
respond1039113respond
respool937633respool
resprout1078783resprout
restart7320033restart
restate73824873restate
rested74430783rested
rester63832433rester
restock1338673restock
restoke116113903restoke
restore75822973restore
rests54935873res_ts
results739833results
resume8313783resume
ret35982833re___t
retest64028453retest
retint65633443retint
retook104313443retook
retool63914483retool
retort66831143retort
retro55020953retro_
retros63820193retros
revert93529113revert
revest94623603revest
revet84938843re_vet
revolt9316223revolt
revote94917453re_vote
rewet85135153re_wet
rewon86920573re_won
rewrote1039113rewrote
rho65924833r__ho_
rhos76319063r__hos
right94430503righ_t
righto104111093righto
rimshots1343883rimshots
riot45947213r__iot
rishi8311253rish_i
rishis9312453rishis
robot7325973r_obot
rochet115423003rochet
root45655923r__oot
roscoe839763roscoe
roset55945243ros_et
roshi8310753rosh_i
roshis9311793roshis
rot37282953r___ot
rush76628183rush__
rushed104419863rushed
rushee93818773rushee
rusher94019653rusher
rushes94724363rushes
rushy115414813rush_y
russet6319433russet
rust45544913rus__t
ryot75528563r__yot
scot66242603__scot
senhor93010803senhor
sestet6826203sestet
sexpot1539543sexpot
shat76456593__shat
shit76745933__shit
shoat85633943__shoat
shod86225053__shod
shoe75933433__shoe
shog86025133__shog
shoo75929883__shoo
shoot84235893__shoot
shop95629833__shop
short85040523__short
shote85526083__shote
shots84730833__shots
shott85332173__shott
shout85433163__shout
show106229183__show
shut76137583__shut
slot46049823__slot
snot44745443__snot
soot45761053__soot
sot310384293__s_ot
spot65540683__spot
stot46347323__stot
swot75134653__swot
teapot8416763teapot
teashop1246083teashop
test48651623tes__t
teston6313303teston
toeshoe1047843toeshoe
unshod1067603unshod
unshut939013unshut
upshoot1256693upshoot
upshots1235193upshots
vest75743603ves__t
washout13410133washout
wecht13415443wech_t
weskit1338343weskit
west75748083wes__t
wrest84925433wres__t
yeshivot1742313yeshivot
zealot15313473zealot
zest136035703zes__t

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.1401276364.3
2DLD Change Limit1127164247.18615685.5
3Display Results4244240.1732450.9
 (SQL Overall)1786914247.49923828.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.