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

204 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
stone5543118(None) 
atone56527981atone
scone74621831scone
shone83725981shone
sone46649981s_one
stane55933001stane
stoae55024261stoae
stoke94922511stoke
stole54928811stole
stoned75923141stoned
stoner65823201stoner
stones65130031stones
stoney96217351stoney
stony85818641stony
stope74727241stope
store56333811store
stove85220251stove
tone46953741_tone
agone65924552agone
alone55732962alone
astony9510522astony
atoned75417542atoned
atoner64817192atoner
atones65225772atones
atony87218852atony
axone125918472axone
bone65949322_bone
clone75728162clone
cone67256962_cone
crone75231332crone
done55747912_done
drone65324982drone
estrone7413952estrone
gone55639042_gone
histone10312842histone
hone77549322_hone
intone61115432intone
irone55126362irone
isotone7239982isotone
ketone105014532ketone
krone94018732krone
leone55018822leone
lone45849132_lone
none45743172_none
one37050912__one
ozone14310612ozone
phone105621932phone
pone65747532_pone
prone75332622prone
sane45954342s_ane
scene77220572scene
sconce104711722sconce
scones84521302scones
scope94821482scope
score75526732score
seine55732872seine
sene46848052s_ene
seton55223542seton_
setons64620172setons
setose65114772setose
shine85533092shine
shoe75933442sho_e
shore85432652shore
shote85526102shote
shove114421042shove
sine46560622s_ine
skene96118122skene
sloe45534952slo_e
slope75823562slope
smoke115015822smoke
smote75820282smote
snore55424952snore
soke85436262s_oke
sole46053672s_ole
some66040382s_ome
son37761952s_on_
sonde64622832s_onde
sones55444142s_ones
song55133672s_ong
sons46049552s_ons
soon46240502soon_
sooner64220462sooner
sore47059532s_ore
spine76534422spine
spode84617702spode
spoke114818662spoke
sponge939662sponge
spore75428592spore
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stance84316912stance
stand65923282stand
staned74824642staned
stanes64933402stanes
stang66424682stang
stank95823302stank
stare54440262stare
state56237332state
stave85324992stave
stele55026842stele
steno54716862steno
stent55634512stent
stere55328542stere
stile54931572stile
stime76521802stime
sting65330242sting
stink95122502stink
stint57037662stint
stipe76523372stipe
stoa45425912sto_a
stoai55417872stoai
stoas55126022stoas
stoat57135952stoat
stob66724612sto_b
stobs75718232stobs
stock114417562stock
stodge8369042stodge
stogey105811542stogey
stogie7311322stogie
stogy95414082stogy
stoic7317252stoic
stoked114718292stoked
stoker104417622stoker
stokes104821792stokes
stoled74521592stoled
stolen64315062stolen
stoles63927672stoles
stoma75918272stoma
stomp95616662stomp
stoners74817952stoners
stonier72013792stonier
stood65517712stood
stooge73811662stooge
stook95218212stook
stool55619892stool
stoop75821542stoop
stop66532032sto_p
stoped94721012stoped
stoper84320102stoper
stopes84525892stopes
stops74827282stops
stopt76528352stopt
stored75524212stored
storer64721672storer
stores65533662stores
storey95217612storey
stork96819692stork
storm76520392storm
story86723032story
stoss54316342stoss
stot46347332sto_t
stots54828552stots
stott56929792stott
stound7399902stound
stoup75517072stoup
stour54916742stour
stoure64814942stoure
stout57434052stout
stover94115642stover
stoves93818922stoves
stow77325742sto_w
stowed105817202stowed
stowp105614232stowp
stows86622702stows
strobe84513812strobe
strode75215972strode
stroke105116172stroke
strong74914882strong
strove95014792strove
stun45623452stun_
stung65417152stung
stunk94616292stunk
stuns54719492stuns
stunt55328172stunt
stupe75217752stupe
stye76218972st_ye
style85519362style
subtone9310342subtone
swine85625302swine
swore84920812swore
syne75725762s_yne
tine45855132_tine
toe310166852_to_e
toke86738492_toke
tole46052902_tole
tome67543192_tome
ton310265102_ton_
toned65435342_toned
toner55336242_toner
tones56048662_tones
toney86027412_toney
tong56434352_tong
tonne54921432_tonne
tons46553052_tons
tony75635152_tony
tope65946382_tope
tore47359322_tore
tote46643672_tote
trone55131862trone
tune45635862_tune
tyne76325052_tyne
zone135231082_zone

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.0802233637.5
2DLD Change Limit538002041.59333772.8
3Display Results2042040.0464434.8
 (SQL Overall)1786912041.719103950.6
 
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.