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

506 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
resorts7481719(None) 
presorts105311671presorts
reports94916211reports
resorbs95010521resorbs
resort65728611resort_
retorts76016511retorts
assorts73310152assorts
besots86415452beso_ts
dehorts11379772dehorts
deports105012882deports
deserts82513052deserts
desorbs10437712desorbs
escorts9418402_escorts
presort95219532presort_
reassorts945622reassorts
reboots93512092reboots
rebores95319162rebores
recoats92616642recoats
records105213922records
recorks134813022recorks
redouts81411652redouts
reforms1239812reforms
remoras9314072remoras
report85326012report_
repots85621002repo_ts
rescores105415692rescores
reseats74319582reseats
resects94115592resects
resents74221222resents
resets65427612res_ets
reshoots11228412reshoots
resifts10378702resifts
resists74414922resists
resits64725562res_its
resoaks1148972resoaks
resods74116302reso_ds
resojets1535342resojets
resoles73823652resoles
resorb84914342resor_b
resorted9313492resorted
resorter8312172resorter
resorters939682resorters
resows93915352reso_ws
respots92912762respots
restarts8310872restarts
restores85222982restores
rests54935872res__ts
results739832results
retort66831142retort_
reverts104715042reverts
revolts1038892revolts
rewords115413972rewords
reworks145113592reworks
sorts54536662__sorts
aborts84916183_aborts
absorbs1135603absorbs
adsorbs1044703adsorbs
allsorts844913allsorts
asserts74311793asserts
assort64916373assort_
bedsores1157633bedsores
besets85718803bes_ets
beshouts1346763beshouts
besmuts1134683besmuts
besoms105712733beso_ms
besot76429713beso_t_
bests75932613bes__ts
bevors111610343bevor_s
beworms1437913beworms
bistorts10118803bistorts
borts76735453__borts
cavorts1237933cavorts
censors93611833censor_s
ceorls848163ce_orls
cesuras958683cesuras
cohorts123411103cohorts
consorts101512333consorts
cresols939643creso_ls
cressets10309103cressets
crests85218703cres__ts
decocts1237833decocts
decors94017773decor_s
deforms1337803deforms
dehorns11428363dehorns
dehort104618103dehort_
departs104310683departs
deport94922393deport_
depots94716343depo_ts
desalts839573desalts
desert72725493desert_
desires81316133desires
desists83611723desists
desorb95210203desor_b
despots10319683despots
desserts9247923desserts
deworms1338013deworms
disports111111113disports
distorts91112343distorts
efforts1334703efforts
ergots74512373ergo_ts
errors63311313error_s
escort84616483_escort_
escots84211743_escots
esprits938393_esprits
estrus61912113_estrus
everts94514893_everts
exerts133712293_exerts
exhorts1746313exhorts
exports1647983exports
exserts1467013exserts
extorts1447753extorts
eyesores1145113eyesores
fedoras1137923fedoras
felworts1445953felworts
fests85828043fes__ts
fetors91014473fetor_s
forts86034453__forts
freshets14298673freshets
gemots93712153gemo_ts
gests66028813ges__ts
gosports1185903gosports
hearts96218943he_arts
helots95217703helo_ts
hests85829933hes__ts
imports11309623imports
inserts74013993inserts
intorts7310963intorts
jests125922453jes__ts
jesuits1436323jesuits
jetports1743533jetports
lessors73610523lessor_s
mesons83215843meso_ns
missorts1038323missorts
morts75533563__morts
mysosts1234543mysosts
nerts55924983ne__rts
nestors73614953nestor_s
nests55728003nes__ts
oestrus7169573oestrus
orts46538333___orts
pelorus939263pelorus
pesos77221623peso__s
pests75933273pes__ts
pieforts1344863pieforts
ports75934593__ports
preforms1537393preforms
prescores133912163prescores
presents103315633presents
presets94216423pres_ets
presifts1366593presifts
presoaks1436593presoaks
presorted1239453presorted
pressors103212673pressor_s
prestores114716063prestores
prests84021263pres__ts
pretors9316803pretor_s
preworks17599003preworks
ragouts838533ragouts
ragworts12125803ragworts
rapports1245963rapports
rasboras1045893rasboras
rasers64526783raser_s
rasures7312013rasures
razors154711653razor_s
reabsorbs1342693reabsorbs
reacts83616603re_acts
readopts1146483readopts
readorns938273readorns
readouts938883readouts
rearms85114653re_arms
rears54739653re_ar_s
reasons72514943reaso_ns
reasserts945983reasserts
reassort8410683reassort_
rebaits9312573rebaits
rebars84019823rebar_s
rebirth1244933rebirth
rebirths1343083rebirths
reboards1138773reboards
reboils94111713reboils
rebooks134010513rebooks
reboot84119333reboot_
rebops10311423rebo_ps
rebore86625643rebor_e
rebored105015883rebored
reborn810016953rebor_n
rebozos1835143rebozos
rebuts84015193re_buts
recants93217093recants
recasts93413533recasts
recepts113010263recepts
recharts1337663recharts
recits83621353re_cits
recoals94214623recoals
recoat84024273recoat_
recocks154711463recocks
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recombs1336753recombs
recons84922993reco_ns
recooks134711233recooks
record96117423recor_d
recork126315483recor_k
recounts1038773recounts
recoups1188843recoups
recross989833recross
rectors93520513rector_s
recurs83315803recur_s
recuts83817373re_cuts
redacts10510943redacts
redcoats1147123redcoats
redocks14409933redocks
redoes74623753redo_es
redons75222183redo_ns
redos65126763redo__s
redoubts11153973redoubts
redout71820253redout_
redowas1138393redowas
redoxes15310883redoxes
redroots937753redroots
redshirts1342903redshirts
redstarts1044243redstarts
reearns749103reearns
reedits8511743reedits
reemits9611303reemits
reests64618893re_ests
reexports1843243reexports
refects124012743refects
refers93921083refer_s
refires104820313refires
refits94017653re_fits
reflets103513153reflets
refloats1156903refloats
refocus1236973refocus
refolds11298953refolds
reforest1139963reforest
reforests1245533reforests
reforge11259033reforge
reforges12249333reforges
reform11312703refor_m
reformats1445713reformats
refronts1137773refronts
regards94112563regards
regents83416543regents
reglets83512983reglets
regorge9257833regorge
regorges10238413regorges
regrets83212923regrets
regrows11269153regrows
reheats104513523reheats
rehires105016113rehires
reimports1343663reimports
reinserts946423reinserts
rejects163910693rejects
rejoins143111383rejoins
reknits1137073reknits
reknots1136783reknots
relents74018503relents
relets64025673re_lets
relicts94414593relicts
relists73817053relists
reloads8911313reloads
reloans7313133reloans
relocks134411293relocks
relooks114010723relooks
relucts9369673relucts
remarks13329983remarks
remeets93712413remeets
remelts93511493remelts
remints95117293remints
remits85622943re_mits
remolds10299703remolds
remora8414583remor_a
remorid10311863remorid
remorse9311713remorse
remorses10311993remorses
remote84222603remo_te
remotes94521613remotes
remounts1036373remounts
removes124514713removes
renests74014213renests
rennets75212633rennets
renowns10277833renowns
rents55935183re__nts
reoils64516873re_oils
reparks13249513reparks
repasts93611933repasts
repeats94316053repeats
repents93717623repents
reperks13298093reperks
replots93412633replots
repolls939053repolls
reported11312703reported
reporter10411423reporter
reporters1139173reporters
repos74725793repo__s
reposes94021263reposes
reposits10310453reposits
repot75132623repo_t_
repours9310223repours
repros84216003re_pros
rerents73319423rerents
rerolls739943rerolls
reroofs1037943reroofs
reroute7313963reroute
reroutes8312223reroutes
resails74616743resails
resales74724903resales
resat55139683res_at_
resaws93713513res_aws
resays93714153res_ays
rescore95616193rescor_e
rescored114513103rescored
rescripts1374573rescripts
rescues9312753rescues
reseals73917663reseals
reseat64131493reseat_
reseaus74012153reseaus
resect84424703resect_
resedas839123resedas
reseeds84012333reseeds
reseeks11348623reseeks
resees63827483res_ees
resells73313203resells
resends83513713resends
resent63833623resent_
reserve101011203reserve
reserves111011983reserves
reset55051863res_et_
resews94814173res_ews
reshes94124363res_hes
reships1239863reships
reshoes102316033reshoes
reshoot102513893reshoot_
reshot93519633reshot_
reshows132510453reshows
resides84523283resides
resids74219153res_ids
resift94017723resift_
resights1246733resights
resigns83910963resigns
resiles74026543resiles
resins64528773res_ins
resist64524533resist_
resit54241043res_it_
resite64128453res_ite
resites74027793resites
resizes164216843resizes
reslate73520593reslate
reslates83619493reslates
resmelts1046143resmelts
resmooth1343633resmooth
resmooths1442643resmooths
resoak10311093reso_ak
resod64720053reso__d
resoften1145443resoften
resoftens1243713resoftens
resojet14312823resojet
resold73915363reso_ld
resole64624183reso_le
resoled84119283resoled
resolute868513resolute
resolutes968193resolutes
resolve103910983resolve
resolves113010783resolves
resonants946693resonants
resonate8513513resonate
resonates9412403resonates
resorbed1138523resorbed
resorcin1046823resorcin
resorcins1146983resorcins
resorting10614613resorting
resound869263resound
resounds956483resounds
resource1046313resource
resources1146203resources
resow88217243reso__w
resowed113712253resowed
resown94112923reso_wn
respects1247703respects
respires10311903respires
respite9513033respite
respites10513243respites
resplits1037723resplits
responds1136913responds
respools1036243respools
respot83117633respot_
respray1236503respray
resprays1344713resprays
resprouts1174823resprouts
rest46459843res__t_
restart7320033restart_
restate73824873restate
restates83423413restates
resters74130403resters
restocks1437503restocks
restokes125213043restokes
restoral8810983restoral
restorals978073restorals
restore75822973restor_e
restored96417193restored
restorer84813723restorer
restorers95110113restorers
restress82511773restress
restricts1138823restricts
result6318223result_
resumes9313373resumes
resurge839073resurge
resurges9310123resurges
retards85015003retards
retests73813853retests
retints74717013retints
retires74726213retires
retools73411023retools
retore67630763retor_e
retorn610923423retor_n
retorted9312333retorted
retorter8410733retorter
retorters938773retorters
retros63820193re_tros
rets45352563re___ts
returns79712593returns
reverbs12368863reverbs
reveres103621343reveres
revers94529633rever_s
revert93529113revert_
revests104413733revests
revets94022173re_vets
revisors11379063revisor_s
revokes144212503revokes
revolt9316223revolt_
revote94917453revo_te
revotes104716393revotes
rewards114813993rewards
rewarms12439593rewarms
rewets94617213re_wets
rewires104717113rewires
reword106321403rewor_d
rewore938030153rewor_e
rework136619783rewor_k
reworn98122193rewor_n
rewrote1039113rewrote
rezeros1647453rezeros
rezones163213943rezones
rhetors1038513rhetor_s
ribworts1345093ribworts
rigors72813713rigor_s
riots54922013r_io_ts
riposts9279403riposts
risers64624783riser_s
risotto744323risotto
risottos843583risottos
ristras7311543ristras
robots8313143robo_ts
roosts64916323r_oosts
roots55933673r__oots
rosets65819953ros_ets
rotors64917933rotor_s
rots46454093r__o_ts
routs57133413r__outs
rubouts937973rubouts
rumors81110393rumor_s
runouts737343runouts
russets738163russets
rusts55026993rus__ts
ryots85313783r_yo_ts
seaports1038463seaports
seisors73212813seisor_s
senoras72714953senoras
senores73218113senores
senors63620783senor_s
sensors73514623sensor_s
sestets7911473sestets
setouts74110333setouts
shorts95321733_shorts
skorts104211293_skorts
snorts64116493_snorts
softs85019233__softs
soots55536203__soots
soras55041013__soras
sorbs75022103__sorbs
sords64527803__sords
sores55454283__sores
sorns55028413__sorns
sort46264813__sort_
sorta57125413__sorta
sorus54527583__sorus
sots45552443__so_ts
sports84619183_sports
tenors63217753tenor_s
tensors72712373tensor_s
tests56530193tes__ts
torts56138123__torts
tremors93711213tremor_s
tsores65113663_tsores
tsoris63411193_tsoris
verts85724733ve__rts
vests85325983ves__ts
visors92912223visor_s
weskits1434743weskits
wests85727003wes__ts
whorts125111433_whorts
worts88631183__worts
wrests95313083wres__ts
zests145419743zes__ts

Search took 9 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.1561145455.1
2DLD Change Limit1340275067.89016986.9
3Display Results5065060.2661902.3
 (SQL Overall)1786915068.31221498.0
 
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.