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

133 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
scope9482148(None) 
cope86847381_cope
scape96921841scape
scone74621831scone
scop85925521scop_
scoped115116651scoped
scopes104719591scopes
scops95820191scops
score75526741score
slope75823561slope
stope74727241stope
aslope839012aslope
cape87242782_cape
cepe84926652_cepe
code77347732_code
coke107038382_coke
cole66956112_cole
come87547702_come
cone67256962_cone
cop711162372_cop_
coped105036842_coped
copen94826432_copen
coper95336092_coper
copes97747102_copes
cops86751372_cops
copse95623922_copse
copy116229802_copy
core67263112_core
cote66648732_cote
coupe96023482_coupe
cove95837072_cove
dope76038892_dope
elope75219342elope
escape103811662escape
grope84821612grope
hope96639672_hope
lope65941922_lope
mope86838042_mope
myope124010972myope
nope65934192_nope
ope56845242__ope
pope85535612_pope
rope65542912_rope
scale74629142scale
scaped115519552scaped
scapes105122262scapes
scare75334462scare
scene77220572scene
scoff134413342scoff
scold85414862scold
scolex1538242scolex
sconce104711722sconce
scones84521302scones
scoop95617162scoop
scooped124611742scooped
scooper113812032scooper
scoops105414362scoops
scoot75729152scoot
scored94621132scored
scorer84818262scorer
scores84725922scores
scorn75817452scorn
scot66242612sco_t
scoter83815482scoter
scots74025912scots
scour75315532scour
scouse84113632scouse
scout75031452scout
scow96021422sco_w
scowed124413832scowed
scowl1012012972scowl
scows106617802scows
scrape105917572scrape
scree720031712scree
scup84822382scup_
scups95316652scups
scute75520942scute
shape105125112shape
shoe75933442sho_e
shone83725982shone
shop95629842shop_
shoppe133110322shoppe
shops104222902shops
shore85432652shore
shote85526102shote
shove114421042shove
sipe67341042s_ipe
slipe75626132slipe
sloe45534952slo_e
slop66533872slop_
sloped94216852sloped
sloper84615912sloper
slopes84820452slopes
slops75026012slops
slype105112362slype
smoke115015822smoke
smote75820282smote
snipe75320572snipe
snore55424952snore
socle7419572socle
soke85436262s_oke
sole46053672s_ole
some66040382s_ome
sone46649982s_one
sop57557862s_op_
soph97024202s_oph
sops65244562s_ops
sore47059532s_ore
spode84617702spode
spoke114818662spoke
spore75428592spore
stipe76523372stipe
stoae55024262stoae
stoke94922512stoke
stole54928812stole
stone55431182stone
stop66532032stop_
stoped94721012stoped
stoper84320102stoper
stopes84525892stopes
stops74827282stops
stopt76528352stopt
store56333812store
stove85220252stove
stupe75217752stupe
supe65932762s_upe
swipe105217082swipe
swop95120502swop_
swops105913972swops
swore84920822swore
syncope1445382syncope
tope65946382_tope
trope75725802trope

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 Limit538001331.60633499.4
3Display Results1331330.0334030.3
 (SQL Overall)1786911331.95291542.5
 
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.