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

325 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
rests5493587(None) 
bests75932611bests
crests85218701crests
fests85828041fests
gests66028811gests
hests85829931hests
jests125922451jests
nests55728001nests
pests75933271pests
prests84021261prests
reests64618891reests
rents55935181rents
resets65427611resets
resits64725561resits
rest46459841rest_
rets45352561re_ts
rusts55026991rusts
tests56530191tests
vests85325981vests
wests85727001wests
wrests95313081wrests
zests145419741zests
arrests73312682arrests
basts75936932basts
beasts84519722beasts
beats76042242beats
beets76131442beets
belts75931162belts
bents76033692bents
beses75830722beses
besets85718802besets
besots86415452besots
best66355322best_
bets67051442be_ts
breasts939702breasts
brents84717272brents
busts75227692busts
casts77237792casts
celts75325782celts
cents74730332cents
cess65326052ces_s
cesta75419482cesta
cestas85018542cestas
cesti75217422cesti
cestos84718092cestos
cestus84412912cestus
chests114916262chests
cists76624532cists
costs77231142costs
cress75022832cres_s
crest74632692crest_
crusts84916542crusts
cysts105912772cysts
debts86418372debts
deets65330242deets
deists74916432deists
delts65731792delts
dents65031802dents
desks105913072desks
dress65319832dres_s
drest65530342drest_
dusts65923562dusts
easts57530322easts
eats47054872_eats
efts76519482_efts
egests74411252egests
erects84116182erects
erses55826802erses
erst47436432erst_
eses45336102_eses
ess36030882_es_s
fasts86429682fasts
feasts95116092feasts
feats86432752feats
feists94915312feists
felts85324542felts
fess76529162fes_s
fest74949442fest_
fets75345942fe_ts
fists85527542fists
forests104114952forests
frets85523402fre_ts
frosts94214622frosts
gasts66628632gasts
geests75912162geests
gelts65924612gelts
gents65729612gents
gest56149132gest_
geste65920692geste
gestes75721392gestes
gets55442482ge_ts
gists66026192gists
greats76318392greats
greets75117422greets
grists74716482grists
guests74311202guests
gusts65722792gusts
heats85838402heats
hefts116218152hefts
heists96814632heists
hents87330742hents
hest75950772hest_
hets75547202he_ts
hists86328372hists
hosts85526702hosts
jess116022032jes_s
jest116738502jest_
jets115834102je_ts
justs124918262justs
keets95123482keets
kelts95222632kelts
kists95822112kists
lasts57731262lasts
leasts64616412leasts
leets54927122leets
lefts86517812lefts
leses54930812leses
less45635102les_s
lest46956322lest_
lets47147942le_ts
lists56628692lists
lusts55022802lusts
masts77035762masts
meats75034052meats
meets74224612meets
melts74930102melts
mesas76823202mesas
mess65932432mes_s
mists76633902mists
mosts76028542mosts
musts75527442musts
neats55931902neats
nerts55924982nerts
ness45526562nes_s
nest45548732nest_
nets45941532ne_ts
netts55320722netts
newts86015282newts
oasts56529182oasts
ousts55225702ousts
pasts75936502pasts
peats76140192peats
pelts76128812pelts
pesos77221622pesos
pest65555292pest_
pesto75723722pesto
pestos84719082pestos
pesty106421712pesty
pets66248332pe_ts
posts75228782posts
presets94216422presets
press75425952pres_s
prest75736352prest_
presto84216202presto
prestos93716082prestos
priests93810862priests
quests153310352quests
rafts87820632rafts
rants55935342rants
rases55447212rases
rasps74316662rasps
rats46260372r_ats
reacts83616602reacts
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
reata54225392reata
reatas64021012reatas
rebs65733562re_bs
rebus75721112rebus
rebuts84015192rebuts
recasts93413532recasts
recits83621352recits
recks115625132recks
recs65734182re_cs
recta74220262recta
recti73619622recti
recto74520802recto
rectos85718782rectos
rectus83314632rectus
recuts83817372recuts
redds74617832redds
redes65139132redes
redos65126762redos
reds56042862re_ds
reeds65430902reeds
reefs85121662reefs
reeks94124032reeks
reels55333262reels
rees45364192re_es
reest54938092reest_
refits94017652refits
refs75732242re_fs
reft75141272reft_
reges65628792reges
regs55436572re_gs
reifs84819092reifs
reins56234562reins
reis45343232re_is
relets64025672relets
relists73817052relists
remits85622942remits
rems66237722re_ms
rends65129952rends
renests74014212renests
rent46661242rent_
rente54733782rente
rentes65431192rentes
repasts93611932repasts
repos74725792repos
repots85621002repots
repps95114342repps
reps65937952re_ps
res35565042re__s
resat55139682resat
resaw84117252resaw
resaws93713512resaws
resay85320542resay
resays93714152resays
reseats74319582reseats
resects94115592resects
resee54336332resee
resees63827482resees
resents74221222resents
reset55051862reset
resew84519502resew
resews94814172resews
resh76523452res_h
reshes94124362reshes
resid64124092resid
resids74219152resids
resifts10378702resifts
resin54131052resin
resins64528772resins
resist64524532resist
resists74414922resists
resit54241042resit
resite64128452resite
resites74027792resites
resod64720052resod
resods74116302resods
resorts74817192resorts
resow88217242resow
resows93915352resows
respots92912762respots
rested74430782rested
rester63832432rester
resters74130402resters
results739832results
ret35982832re_t_
rete44944132re_te
retests73813852retests
reuses66025522reuses
revests104413732revests
revets94022172revets
revs75027052re_vs
rewets94617212rewets
rexes124526952rexes
rhesus936202rhesus
rifts85718642rifts
riots54922012riots
rises55244042rises
risks94917062risks
risus54216392risus
roasts64915412roasts
roosts64916322roosts
roots55933672roots
roses56445772roses
rosets65819952rosets
rots46454092r_ots
rousts617016722rousts
routs57133412routs
runts55927632runts
ruses56136582ruses
rusks95816192rusks
rust45544912rust_
rusty85221052rusty
ruts44541492r_uts
ryots85313782ryots
seats54844342seats
sects75622892sects
septs75420602septs
sets45549502se_ts
setts55124322setts
sexts125118382sexts
teats55636812teats
tents56434212tents
test48651622test_
testa54822042testa
testes65125822testes
testis64916712testis
testy85419062testy
tets45847462te_ts
texts125515042texts
treats64821692treats
tress55423162tres_s
trets55928022tre_ts
trusts64714432trusts
trysts9448792trysts
unrests7229462unrests
vasts86423772vasts
vents86125932vents
versts93914732versts
verts85724732verts
vest75743602vest_
vesta86618302vesta
vestas95916682vestas
vets76835092ve_ts
wasts87433672wasts
weets85427722weets
wefts116715492wefts
welts85225192welts
west75748082west_
wets75940292we_ts
wists86728522wists
wrest84925432wrest_
wrists95415642wrists
xysts15558122xysts
yeasts96413052yeasts
yeses85119322yeses
yetts86715132yetts
zest136035702zest_
zesty176512162zesty

Search took 3 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.313570897.8
2DLD Change Limit538003251.61033416.1
3Display Results3253250.0933494.6
 (SQL Overall)1786913252.01688636.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.