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

126 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
scoped11511666(None) 
coped105036851_coped
scaped115519551scaped
scooped124611751scooped
scope94821481scope_
scopes104719591scopes
scored94621131scored
scowed124413831scowed
sloped94216851sloped
stoped94721011stoped
caped104931802_caped
coded95433182_coded
coed77140542_co_ed
coked124730692_coked
coled85540762_coled
comped135919872_comped
coned86040052_coned
cooed84534342_cooed
cooped114821612cooped
cope86847382_cope_
copen94826432_copen
coper95336092_coper
copes97747102_copes
copied114618572_copied
copped135221262_copped
cored85044222_cored
coted85033852_coted
couped115019312_couped
coved115027372_coved
cowed115637852_cowed
coxed154322812_coxed
coyed114623802_coyed
doped95326712_doped
eloped95914152eloped
escaped12388852escaped
escoted1038182escoted
groped107515062groped
hooped125518182hooped
hoped115628182_hoped
looped95217172looped
loped85128332_loped
moped105424732_moped
oped76230152__oped
pooped113915942pooped
roped84630812_roped
sapped114422012sapped
scaled94822442scaled
scalped124411992scalped
scamped144711962scamped
scape96921842scape_
scapes105122262scapes
scared95227292scared
scarped124314402scarped
scoffed16266182scoffed
scold85414862sco_ld
scolded11358862scolded
scolex1538242scolex
sconced12359172sconced
scone74621832scone_
scones84521302scones
scooper113812032scooper
scooted103612282scooted
scop85925522scop__
scops95820192scop_s
score75526742score_
scorer84818262scorer
scores84725922scores
scorned10229952scorned
scoter83815482scoter
scoured103811152scoured
scouted104112032scouted
scowled13398192scowled
scraped124313142scraped
screed95718932screed
scried95817312scried
scrooped1356412scrooped
sculped12398252sculped
seeped94317522seeped
shaped125020102shaped
shoed95723012sho_ed
shooed103916082shooed
shopped153512212shopped
shored105723652shored
shoved134214282shoved
showed135016972showed
siped84927682s_iped
sipped113720632sipped
sliped95417062sliped
slope75823562slope_
sloper84615912sloper
slopes84820452slopes
slopped123511442slopped
slowed104617072slowed
smoked134311722smoked
sniped94913482sniped
snooped103711812snooped
snored74819542snored
snowed104613622snowed
soaped95817972soaped
socked134721502socked
soled65835172s_oled
sooted73922592sooted
sopped114819902sopped
sored66141782s_ored
souped95017672souped
sowed94933862s_owed
sped76031492s__ped
spoked134413892spoked
spored94821792spored
stiped94517072stiped
stoked114718292stoked
stoled74521592stoled
stomped124110532stomped
stoned75923142stoned
stooped103813832stooped
stope74727242stope_
stoper84320102stoper
stopes84525892stopes
stopped124512202stopped
stored75524212stored
stowed105817202stowed
supped114415702supped
swiped123811092swiped
swooped13418752swooped
swopped15437672swopped
toped85631312_toped

Search took 7 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.393454684.5
2DLD Change Limit825511265.20315866.0
3Display Results1261260.453278.1
 (SQL Overall)1786911266.04929540.6
 
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.