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

174 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
stoke9492251(None) 
smoke115015821smoke
soke85436261s_oke
spoke114818661spoke
stake95927531stake
stoae55024261stoae
stoked114718291stoked
stoker104417621stoker
stokes104821791stokes
stole54928811stole
stone55431181stone
stope74727241stope
store56333811store
stove85220251stove
stroke105116171stroke
toke86738491_toke
atone56527982atone
awoke124912002awoke
bloke114316632bloke
broke116019782broke
choke145118022choke
coke107038382_coke
evoke12478852evoke
hoke115935932_hoke
joke155926162_joke
moke106234222_moke
oke75839482__oke
poke105335362_poke
restoke116113902restoke
sake85244962s_ake
scone74621832scone
scope94821482scope
score75526742score
setose65114772setose
shake124726402shake
shoe75933442sho_e
shone83725982shone
shore85432652shore
shote85526102shote
shove114421042shove
sike87138782s_ike
slake93724052slake
sloe45534952slo_e
slope75823562slope
smoked134311722smoked
smoker124311692smoker
smokes124814342smokes
smokey15398652smokey
smoky14388682smoky
smote75820282smote
snake94821112snake
snore55424952snore
sokes95031422s_okes
sole46053672s_ole
some66040382s_ome
sone46649982s_one
sook84933392sook_
sooks94425452sooks
sore47059532s_ore
spake114322742spake
spike114922842spike
spode84617702spode
spoked134413892spoked
spoken124610002spoken
spokes124417212spokes
spore75428592spore
stade64825302stade
stage65330192stage
staked114621942staked
stakes103927292stakes
stale55637102stale
stane55933002stane
stare54440262stare
state56237332state
stave85324992stave
steek95418002steek
stele55026842stele
stere55328542stere
stile54931572stile
stime76521802stime
stipe76523372stipe
stoa45425912sto_a
stoai55417872stoai
stoas55126022stoas
stoat57135952stoat
stob66724612sto_b
stobs75718232stobs
stock114417562stock
stocked144312872stocked
stocker133713082stocker
stocks124715632stocks
stocky15369152stocky
stodge8369042stodge
stogey105811542stogey
stogie7311322stogie
stogy95414082stogy
stoic7317252stoic
stokers114515182stokers
stoled74521592stoled
stolen64315062stolen
stoles63927672stoles
stoma75918272stoma
stomp95616662stomp
stoned75923142stoned
stoner65823202stoner
stones65130032stones
stoney96217352stoney
stony85818642stony
stood65517712stood
stooge73811662stooge
stook95218212stook
stooked124312302stooked
stooker113811732stooker
stooks105115372stooks
stool55619892stool
stoop75821542stoop
stop66532032sto_p
stoped94721012stoped
stoper84320102stoper
stopes84525892stopes
stops74827282stops
stopt76528352stopt
stored75524212stored
storer64721672storer
stores65533662stores
storey95217612storey
stork96819692stork
storks106115952storks
storm76520402storm
story86723032story
stoss54316342stoss
stot46347332sto_t
stots54828552stots
stott56929792stott
stoup75517072stoup
stour54916742stour
stoure64814942stoure
stout57434052stout
stover94115642stover
stoves93818922stoves
stow77325742sto_w
stowed105817202stowed
stowp105614232stowp
stows86622702stows
strake104017392strake
strike105619732strike
strobe84513812strobe
strode75215972strode
stroked124613622stroked
stroker114113522stroker
strokes114316322strokes
strove95014792strove
stupe75217752stupe
stye76218972st_ye
style85519362style
swore84920822swore
syke115420562s_yke
take84739262_take
tike85534482_tike
toe310166852_to_e
toked105626492_toked
token95419312_token
toker95924912_toker
tokes95234972_tokes
tole46052902_tole
tome67543192_tome
tone46953742_tone
tope65946382_tope
tore47359322_tore
tote46643672_tote
troke94821052troke
tyke115720502_tyke
woke115527962_woke
yoke115626392_yoke

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.293609866.9
2DLD Change Limit538001741.47036598.6
3Display Results1741740.0463782.6
 (SQL Overall)1786911741.80998778.9
 
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.