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

237 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
store5633381(None) 
score75526731score
shore85432641shore
snore55424951snore
sore47059531s_ore
spore75428591spore
stare54440261stare
stere55328541stere
stoae55024261stoae
stoke94922511stoke
stole54928811stole
stone55431181stone
stope74727241stope
stored75524211stored
storer64721671storer
stores65533641stores
storey95217611storey
stork96819691stork
storm76520371storm
story86723031story
stoure64814941stoure
stove85220251stove
swore84920811swore
tore47359321_tore
adore65723662adore
afore85818602afore
ashore9414612ashore
atone56527982atone
bore66051332_bore
chore105126762chore
core67263112_core
crore74922862crore
dore56353302_dore
fore78351472_fore
frore86218802frore
gore55744962_gore
kore85834162_kore
lore45850352_lore
more67154522_more
ore36661832__ore
pore66451262_pore
restore75822972restore
retore67630762retore
sabre74821502sabre
satire63218002satire
satori6415832satori
scare75334462scare
scone74621832scone
scope94821482scope
scored94621132scored
scorer84818252scorer
scores84725922scores
scorn75817442scorn
sere46153472s_ere
setose65114772setose
share86437082share
shire84727132shire
shoe75933432sho_e
shoer84722152shoer
shone83725972shone
shored105723642shored
shores94830402shores
shorl84720242shorl
shorn85722172shorn
short85040522short
shote85526082shote
shove114421032shove
sire46150412s_ire
skort94925632skort
sloe45534952slo_e
slope75823562slope
smoke115015822smoke
smote75820272smote
snare54429982snare
snored74819542snored
snorer64316762snorer
snores64324312snores
snort54833752snort
soke85436262s_oke
sole46053672s_ole
some66040382s_ome
sone46649982s_one
sora45746912s_ora
sorb68333042s_orb
sord56237202s_ord
sored66141782s_ored
sorel56231442s_orel
sorer56236572s_orer
sores55454282s_ores
sori46039832s_ori
sorn46641062s_orn
sort46264812s_ort
spare75135562spare
spire75828692spire
splore81611302splore
spode84617702spode
spoke114818662spoke
spored94821792spored
spores84726612spores
sport75935982sport
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
star48037762star_
stared75429872stared
starer64027362starer
stares66038752stares
stark95425622stark
stars55836572stars
start55642312start
starve94613742starve
state56237332state
stave85324992stave
steer55423862steer
stele55026842stele
stereo65317912stereo
steres63929532steres
stern55319122stern
stile54931572stile
stime76521792stime
stipe76523372stipe
stir45723242stir_
stirk95717412stirk
stirp76815502stirp
stirs55921612stirs
stoa45425912sto_a
stoai55417862stoai
stoas55126022stoas
stoat57135952stoat
stob66724612sto_b
stobs75718232stobs
stock114417562stock
stodge8369042stodge
stogey105811542stogey
stogie7311312stogie
stogy95414082stogy
stoic7317242stoic
stoked114718292stoked
stoker104417622stoker
stokes104821792stokes
stoled74521592stoled
stolen64315062stolen
stoles63927672stoles
stoma75918272stoma
stomp95616662stomp
stoned75923142stoned
stoner65823202stoner
stones65130032stones
stoney96217352stoney
stony85818642stony
stood65517712stood
stooge73811662stooge
stook95218212stook
stool55619892stool
stoop75821542stoop
stop66532032sto_p
stoped94721012stoped
stoper84320092stoper
stopes84525892stopes
stops74827282stops
stopt76528352stopt
storage8310472storage
storax1389782storax
storers75018682storers
storeys10559652storeys
storied8515162storied
stories7324272stories
storks106115932storks
stormed1039042stormed
storms85814612storms
stormy115510722stormy
stoss54316342stoss
stot46347322sto_t
stots54828542stots
stott56929782stott
stoup75517072stoup
stour54916742stour
stoures74614162stoures
stourie7469342stourie
stours65015622stours
stoury9529942stoury
stout57434052stout
stover94115642stover
stoves93818922stoves
stow77325742sto_w
stowed105817202stowed
stowp105614232stowp
stows86622702stows
strep77120852st_rep
strew89220652st_rew
strobe84513812strobe
strode75215972strode
stroke105116172stroke
strop77422242strop
strove95014792strove
strow88920572strow
stroy87720392stroy
stupe75217752stupe
sturt56028962sturt
stye76218972st_ye
style85519362style
sucre75019102sucre
sure45447412s_ure
suture6313202suture
sware85828212sware
sword95214112sword
sworn86115302sworn
tare45957622_tare
tire46143352_tire
toe310166852_to_e
toke86738492_toke
tole46052902_tole
tome67543192_tome
tone46953742_tone
tope65946382_tope
tor39261682_tor_
tora47545992_tora
torc66333352_torc
tores55352672_tores
tori47542152_tori
torn46044252_torn
toro48045682_toro
torr45630902_torr
tors46157382_tors
torse55833332_torse
tort46967462_tort
torte55431702_torte
tory75840542_tory
tote46643672_tote
tsores65113662tsores
tyre75428252_tyre
uptore8279452uptore
whore116018042whore
wore77144672_wore
yore76335942_yore

Search took 2 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.0931921408.6
2DLD Change Limit538002371.58034050.6
3Display Results2372370.0603950.0
 (SQL Overall)1786912371.733103110.8
 
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.