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

131 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
spoke11481866(None) 
poke105335361_poke
smoke115015821smoke
soke85436261s_oke
spake114322741spake
spike114922841spike
spode84617701spode
spoked134413891spoked
spoken124610001spoken
spokes124417211spokes
spore75428591spore
stoke94922511stoke
awoke124912002awoke
bespoke15468112bespoke
bloke114316632bloke
broke116019782broke
choke145118022choke
coke107038382_coke
epode85114092epode
evoke12478852evoke
hoke115935932_hoke
joke155926162_joke
moke106234222_moke
mopoke1436632mopoke
oke75839482__oke
peke105926202_peke
pike106335222_pike
poked125425392_poked
poker115122882_poker
pokes116133012_pokes
pokey145318972_pokey
poky135922152_poky
pole65951302_pole
pome85636692_pome
pone65747532_pone
pope85535612_pope
pore66451262_pore
pose66441732_pose
psoae74411622psoae
puke105025462_puke
respoke134311282respoke
sake85244962s_ake
sapote8314362sapote
scone74621832scone
scope94821482scope
score75526742score
shake124726402shake
shoe75933442sho_e
shone83725982shone
shore85432652shore
shote85526102shote
shove114421042shove
sike87138792s_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
space95325672space
spade84423322spade
spae65034322sp_ae
spale74929212spale
spare75135562spare
spate74731582spate
spice95528812spice
spik105419712spik_
spiked134915552spiked
spiker124315662spiker
spikes124520712spikes
spikey155411332spikey
spiks114117472spiks
spiky146014112spiky
spile75230082spile
spine76534422spine
spire75828692spire
spite75430662spite
splake1259782splake
splore81611302splore
spodes94817432spodes
spoil75818652spoil
sponge939662sponge
spoof105019012spoof
spook115416042spook
spooked144510472spooked
spooks124312932spooks
spooky15418092spooky
spool75219042spool
spoon74719442spoon
spoor75016352spoor
spored94821792spored
spores84726612spores
sport75935982sport
spot65540692spo_t
spots74424112spots
spouse84112512spouse
spout75029632spout
spree74830862spree
sprue74717632sprue
spue66025522sp_ue
spume95817312spume
stake95927532stake
stoae55024262stoae
stoked114718292stoked
stoker104417622stoker
stokes104821792stokes
stole54928812stole
stone55431182stone
stope74727242stope
store56333812store
stove85220252stove
stroke105116172stroke
swore84920822swore
syke115420562s_yke
toke86738492_toke
troke94821052troke
unspoke1336572unspoke
woke115527962_woke
yoke115626392_yoke

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.330541487.9
2DLD Change Limit538001312.20324421.2
3Display Results1311310.0462847.8
 (SQL Overall)1786911312.57969286.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.