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

153 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
scone7462183(None) 
cone67256961_cone
scene77220571scene
sconce104711721sconce
scones84521301scones
scope94821481scope
score75526741score
shone83725981shone
sone46649981s_one
stone55431181stone
acne66625872ac_ne
agone65924552agone
alone55732962alone
ancone83916952ancone
atone56527982atone
axone125918472axone
bone65949322_bone
cane66653122_cane
cine66242952_cine
clone75728162clone
code77347742_code
coke107038382_coke
cole66956112_cole
come87547702_come
con510268022_con_
coned86040052_coned
cones76457422_cones
coney105932882_coney
conge85227592_conge
coni65534802_coni
conk106531442_conk
conn66229132_conn
cons66057692_cons
conte76633202_conte
cony96537832_cony
cope86847382_cope
core67263112_core
cote66648732_cote
cove95837072_cove
crone75231332crone
done55747912_done
drone65324982drone
gone55639042_gone
hone77549322_hone
icon66922042icon_
icones84616382icones
icons76516492icons
irone55126362irone
krone94018732krone
leone55018822leone
lone45849132_lone
none45743172_none
ochone11311292ochone
one37050912__one
oscine8311562oscine
ozone14310612ozone
phone105621932phone
pone65747532_pone
prone75332622prone
sane45954342s_ane
scale74629142scale
scan65530452scan_
scans74625102scans
scant79735072scant
scape96921842scape
scare75334462scare
scena74815782scena
scend85516292scend
scenes84520352scenes
scent75831622scent
scion72214992scion_
scions82612242scions
scoff134413342scoff
scold85414862scold
scolex1538242scolex
sconced12359172sconced
sconces113811452sconces
scoop95617162scoop
scoot75729152scoot
scop85925522sco_p
scoped115116662scoped
scopes104719592scopes
scops95820192scops
scored94621132scored
scorer84818262scorer
scores84725922scores
scorn75817452scorn
scorned10229952scorned
scorner9259762scorner
scorns85713022scorns
scot66242612sco_t
scoter83815482scoter
scots74025912scots
scour75315532scour
scouse84113632scouse
scout75031452scout
scow96021422sco_w
scowed124413832scowed
scowl1012012972scowl
scows106617802scows
scree720031712scree
scute75520942scute
second9411152second
seconde1037412seconde
seine55732872seine
sene46848052s_ene
shine85533092shine
shoe75933442sho_e
shore85432652shore
shote85526102shote
shove114421042shove
sine46560632s_ine
skene96118122skene
sloe45534952slo_e
slope75823562slope
smoke115015822smoke
smote75820282smote
snore55424952snore
socle7419572socle
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
stane55933002stane
stoae55024262stoae
stoke94922512stoke
stole54928812stole
stoned75923142stoned
stoner65823202stoner
stones65130032stones
stoney96217352stoney
stony85818642stony
stope74727242stope
store56333812store
stove85220252stove
swine85625302swine
swore84920822swore
syne75725762s_yne
tone46953742_tone
trone55131862trone
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.313570897.8
2DLD Change Limit538001531.56334421.0
3Display Results1531530.0463326.1
 (SQL Overall)1786911531.92292971.4
 
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.