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 “scoping” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
scoping12351382(None) 
coping113927661_coping
scaping123715691scaping
scooping133610631scooping
scoring103117211scoring
scowing133812091scowing
sloping104114071sloping
stoping103716621stoping
coding104024792_coding
coking134523882_coking
coming114225452_coming
comping143518592_comping
coning94331822_coning
cooing94024922_cooing
cooping123918932cooping
copings124111842_copings
copping143918592_copping
copying153411982_copying
coring94433962_coring
coting94629252_coting
couping124317022_couping
coving124321522_coving
cowing124526322_cowing
coxing164218862_coxing
coying124021482_coying
doping103919462_doping
eloping103512832eloping
escaping1347062escaping
escoting1158712escoting
groping113313102groping
hooping133615702hooping
hoping123719742_hoping
looping103615282looping
loping93921412_loping
moping114017102_moping
oping86322412__oping
pooping123615442pooping
roping94023022_roping
sapping123519312sapping
scaling103519372scaling
scalping133410452scalping
scamping153510192scamping
scaring103421972scaring
scarping133312462scarping
scoffing17275942scoffing
scolding12278912scolding
sconcing1338262sconcing
scooting113012642scooting
scorning1169132scorning
scouring112810852scouring
scouting112612752scouting
scowling1458292scowling
scraping133310862scraping
scrooping1446592scrooping
scrying1338662scrying
sculping13298942sculping
seeping103817912seeping
shaping133116182shaping
shoeing113211882shoeing
shooing112112912shooing
shopping163611292shopping
shoring112820072shoring
shoving142910642shoving
showing143814662showing
siping94220632s_iping
sipping123117432sipping
sliping103314412sliping
slopping133811422slopping
slowing112814742slowing
smoking143210522smoking
sniping103712052sniping
snooping113811322snooping
snoring83917202snoring
snowing113913452snowing
soaping103616222soaping
socking143518602socking
soling74226822s_oling
sooting82820962sooting
sopping123917202sopping
soring74731882s_oring
souping104215532souping
sowing104222912s_owing
spoking143212222spoking
sporing104319412sporing
stoking123615592stoking
stomping13309762stomping
stoning83717442stoning
stooping113012362stooping
stopping133611412stopping
storing83921122storing
stowing113315132stowing
supping123814532supping
swiping13319822swiping
swooping14338402swooping
swopping16377962swopping
toping94122992_toping

Search took 8 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 Filter1786911076710.783228213.3
2DLD Change Limit107671966.29617101.5
3Display Results96960.0303200.0
 (SQL Overall)178691967.10925135.9
 
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.