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

227 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
stores6553364(None) 
scores84725921scores
shores94830401shores
snores64324311snores
sores55454281s_ores
spores84726611spores
stares66038751stares
steres63929531steres
stokes104821791stokes
stoles63927671stoles
stones65130031stones
stopes84525891stopes
store56333811store_
stored75524211stored
storer64721671storer
storers75018681storers
storey95217611storey
storeys10559651storeys
stories7324271stories
storks106115931storks
storms85814611storms
stoures74614161stoures
stoves93818921stoves
tores55352671_tores
tsores65113661tsores
adores74420712adores
atones65225772atones
bores76448252_bores
chores114828022chores
cores76361852_cores
crores86121162crores
fores85847102_fores
gores65740372_gores
lores55045402_lores
mores76249642_mores
ores46056682__ores
ostoses71213542ostoses
pores75849032_pores
ptoses83514672ptoses
restores85222982restores
sabres85520862sabres
satires72617572satires
satoris7317232satoris
scares85033002scares
scones84521302scones
scopes104719592scopes
score75526732score_
scored94621132scored
scorer84818252scorer
scorers94115312scorers
scorns85713012scorns
senores73218112senores
seres55448892s_eres
shares95236412shares
shires95225572shires
shoers94518322shoers
shoes85429652sho_es
shore85432642shore_
shored105723642shored
shorls94516192shorls
shorts95321732shorts
shotes95321892shotes
shoves124919412shoves
sires55945372s_ires
skorts104211292skorts
sloes54728872slo_es
slopes84820452slopes
smokes124814342smokes
snares65329032snares
snore55424952snore_
snored74819542snored
snorer64316762snorer
snorers74313792snorers
snorts64116492snorts
sokes95031422s_okes
soles55547922s_oles
sones55444142s_ones
soras55041012s_oras
sorbs75022102s_orbs
sords64527802s_ords
sore47059532s_ore_
sored66141782s_ored
sorel56231442s_orel
sorels63921162s_orels
sorer56236572s_orer
sorest65027992s_orest
sorns55028412s_orns
sorts54536662s_orts
sorus54527582s_orus
spares84834552spares
spires84628112spires
splores91910942splores
spodes94817432spodes
spokes124417212spokes
spore75428592spore_
spored94821792spored
sports84619182sports
stades74626242stades
stages75629492stages
stakes103927292stakes
stales65538292stales
stanes64933402stanes
stapes85028732stapes
stare54440262stare_
stared75429872stared
starer64027362starer
starers74522312starers
starets73515922starets
stars55836572star_s
starts65423122starts
starves104614552starves
stases64225562stases
states64337082states
staves94525192staves
steers63820982steers
steles63725662steles
stere55328542stere_
stereo65317912stereo
stereos74314972stereos
sterns64616752sterns
sties55132982st_ies
stiles64328762stiles
stimes85920572stimes
stipes84524052stipes
stirks104914232stirks
stirpes95011292stirpes
stirps85011812stirps
stirs55921612stir_s
stoae55024262stoae_
stoas55126022sto_as
stoats65117482stoats
stobs75718232sto_bs
stocks124715632stocks
stodges9309082stodges
stogey105811542stogey
stogeys11486122stogeys
stogies8413692stogies
stoics8311112stoics
stoke94922512stoke_
stoked114718292stoked
stoker104417622stoker
stokers114515182stokers
stole54928812stole_
stoled74521592stoled
stolen64315062stolen
stomas84816322stomas
stomps105612832stomps
stone55431182stone_
stoned75923142stoned
stoner65823202stoner
stoners74817952stoners
stoney96217352stoney
stooges83611482stooges
stooks105115372stooks
stools65117022stools
stoops85917892stoops
stope74727242stope_
stoped94721012stoped
stoper84320092stoper
stopers94217362stopers
stops74827282sto_ps
storages9311102storages
storax1389782storax
storaxes1536882storaxes
storied8515162storied
stork96819692stor_k
storm76520372stor_m
stormed1039042stormed
stormy115510722stormy
story86723032stor_y
stoss54316342sto_ss
stots54828542sto_ts
stotts64612852stotts
stoups85313272stoups
stoure64814942stoure_
stours65015622stours
stouts65019002stouts
stove85220252stove_
stover94115642stover
stovers103713732stovers
stowed105817202stowed
stowps115710582stowps
stows86622702sto_ws
strep77120852st_rep
streps86218062st_reps
stress66616672st_ress
strew89220652st_rew
strews96817092st_rews
strobes93813262strobes
strokes114316322strokes
strops86220382strops
strows96718272strows
stroys95914602stroys
stupes84116952stupes
sturts63915142sturts
styes86316522st_yes
styles94418652styles
sucres84218892sucres
sutures7314222sutures
swords104510792swords
swore84920812swore_
tares57456562_tares
tires55437492_tires
toes46956442_to_es
tokes95234972_tokes
toles55147132_toles
tomes76037382_tomes
tones56048662_tones
topes76941762_topes
toras55540372_toras
torcs75123762_torcs
tore47359322_tore_
tories65435882_tories
toros54336192_toros
torrs53923562_torrs
tors46157382_tor_s
torse55833332_torse
torses64727952_torses
tortes64826052_tortes
torts56138122_torts
torus54329762_torus
totes55139682_totes
tres46542902_t_res
tsoris63411192tsoris
tyres84725232_tyres
whores125617102whores
yores85031322_yores

Search took 4 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 Filter178691825510.1231452772.4
2DLD Change Limit825512272.79629524.7
3Display Results2272270.0802837.5
 (SQL Overall)1786912272.99959583.5
 
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.