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 “scopes” 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
scopes10471959(None) 
copes97747101_copes
scapes105122261scapes
scones84521301scones
scope94821481scope_
scoped115116661scoped
scops95820191scop_s
scores84725921scores
slopes84820451slopes
stopes84525891stopes
capes95441922_capes
cepes94424462_cepes
codes86247292_codes
cokes115537192_cokes
coles76055062_coles
comes97246992_comes
cones76457422_cones
cope86847382_cope_
coped105036852_coped
copen94826432_copen
copens106119962_copens
coper95336092_coper
copers104629842_copers
copies104130312_copies
cops86751372_cop_s
copse95623932_copse
copses104922482_copses
cores76361852_cores
coses76949492_coses
cotes76347842_cotes
coupes105022522_coupes
coves105539172_coves
coxes145430862_coxes
cozes166033242_cozes
dopes84935042_dopes
elopes85918162elopes
escapes113811672escapes
gropes95220402gropes
hopes105835642_hopes
icones84616382icones
lopes76437342_lopes
mopes95134982_mopes
myopes13419962myopes
opes65942612__opes
popes95933812_popes
ropes75940062_ropes
scales84529312scales
scape96921842scape_
scaped115519552scaped
scares85033002scares
scenes84520352scenes
scoffs14347502scoffs
scolds95011232scolds
scolex1538242scolex
sconces113811452sconces
scone74621832scone_
scooped124611752scooped
scooper113812032scooper
scoopers124210192scoopers
scoops105414362scoops
scoots85315942scoots
scop85925522scop__
score75526742score_
scored94621132scored
scorer84818262scorer
scorers94115322scorers
scorns85713022scorns
scoter83815482scoter
scoters93313812scoters
scots74025912sco_ts
scours84913592scours
scouse84113632scouse
scouses93313242scouses
scouts84817942scouts
scowed124413832scowed
scowls11549592scowls
scows106617802sco_ws
scrapes116217662scrapes
screes85023972screes
scries85226822scries
scups95316652scup_s
scutes85219192scutes
shapes115124952shapes
shoes85429662sho_es
shoppes143411402shoppes
shops104222902shop_s
shores94830412shores
shotes95321912shotes
shoves124919422shoves
sipes76036952s_ipes
slipes84921412slipes
sloes54728872slo_es
slope75823562slope_
sloped94216852sloped
sloper84615912sloper
slopers94213092slopers
slops75026012slop_s
slypes114410482slypes
smokes124814342smokes
snipes83917392snipes
snores64324322snores
socles8418452socles
sokes95031422s_okes
soles55547922s_oles
sones55444142s_ones
sophs104916022s_ophs
sops65244562s_op_s
sores55454282s_ores
spodes94817432spodes
spokes124417212spokes
spores84726612spores
stapes85028732stapes
stipes84524052stipes
stokes104821792stokes
stoles63927672stoles
stones65130032stones
stope74727242stope_
stoped94721012stoped
stoper84320102stoper
stopers94217372stopers
stops74827282stop_s
stores65533662stores
stoves93818922stoves
stupes84116952stupes
supes75628302s_upes
swipes114114332swipes
swops105913972swop_s
sycoses1249132sycoses
syncopes1545762syncopes
topes76941762_topes
tropes84824352tropes

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 Filter178691825510.343520965.0
2DLD Change Limit825511312.58031996.5
3Display Results1311310.0304366.7
 (SQL Overall)1786911312.95360511.7
 
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.