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

157 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
stoae5502426(None) 
stoa45425911stoa_
stoai55417861stoai
stoas55126021stoas
stoat57135951stoat
stoke94922511stoke
stole54928811stole
stone55431181stone
stope74727241stope
store56333811store
stove85220251stove
atone56527982atone
psoae74411622psoae
sae38365182s__ae
scone74621832scone
scope94821482scope
score75526732score
setae56026222setae
setose65114772setose
shoal83920262shoal
shoat85633942shoat
shoe75933432sho_e
shone83725972shone
shore85432642shore
shote85526082shote
shove114421032shove
skoal93811452skoal
sloe45534952slo_e
slope75823562slope
smoke115015822smoke
smote75820272smote
snore55424952snore
soak87227662s_oak
soap65831132s_oap
soar46838672s_oar
soave84219052s_oave
soke85436262s_oke
sole46053672s_ole
some66040382s_ome
sone46649982s_one
sore47059532s_ore
spae65034322s_pae
spode84617702spode
spoke114818662spoke
spore75428592spore
stab67329932st_ab
stade64825302stade
stag57332002st_ag
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
star48037762st_ar
stare54440262stare
stat47352692st_at
state56237332state
stave85324992stave
staw78627692st_aw
stay78333722st_ay
stead65520272stead
steak95219802steak
steal56125472steal
steam76322922steam
stelae63716482stelae
stele55026842stele
stere55328542stere
stile54931572stile
stime76521792stime
stipe76523372stipe
stoats65117482stoats
stob66724612sto_b
stobs75718232stobs
stock114417562stock
stodge8369042stodge
stogey105811542stogey
stogie7311312stogie
stogy95414082stogy
stoic7317242stoic
stoked114718292stoked
stoker104417622stoker
stokes104821792stokes
stoled74521592stoled
stolen64315062stolen
stoles63927672stoles
stoma75918272stoma
stomal85213312stomal
stomas84816322stomas
stomate9313122stomate
stomp95616662stomp
stoned75923142stoned
stoner65823202stoner
stones65130032stones
stoney96217352stoney
stony85818642stony
stood65517712stood
stooge73811662stooge
stook95218212stook
stool55619892stool
stoop75821542stoop
stop66532032sto_p
stoped94721012stoped
stoper84320092stoper
stopes84525892stopes
stops74827282stops
stopt76528352stopt
storage8310472storage
storax1389782storax
stored75524212stored
storer64721672storer
stores65533642stores
storey95217612storey
stork96819692stork
storm76520372storm
story86723032story
stoss54316342stoss
stot46347322sto_t
stots54828542stots
stott56929782stott
stoup75517072stoup
stour54916742stour
stoure64814942stoure
stout57434052stout
stover94115642stover
stoves93818922stoves
stow77325742sto_w
stowage1136702stowage
stowed105817202stowed
stowp105614232stowp
stows86622702stows
strafe95215972strafe
strake104017392strake
strap77925262strap
straw813321292straw
stray88525572stray
striae65422272striae
strobe84513812strobe
strode75215972strode
stroke105116172stroke
strove95014792strove
stupe75217752stupe
stye76218972st_ye
style85519362style
swore84920812swore
tae38267052_t_ae
thae76825562_thae
toad55830182_toad
toe310166852_to_e
toea46732332_toea
togae67020112_togae
toke86738492_toke
tole46052902_tole
tome67543192_tome
tone46953742_tone
tope65946382_tope
tore47359322_tore
tote46643672_tote
twae74719572_twae

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.0931921408.6
2DLD Change Limit538001571.86028924.7
3Display Results1571570.0463413.0
 (SQL Overall)1786911571.99989390.2
 
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.