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

108 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
sloping10411407(None) 
eloping103512831eloping
loping93921411_loping
scoping123513821scoping
sliping103314411sliping
slopping133811421slopping
slowing112814741slowing
stoping103716621stoping
blooping13248842blooping
blowing133813052blowing
cleping123310432cleping
clomping15329652clomping
cloning103215482cloning
clopping153511082clopping
closing103114842closing
cloying133511752cloying
cooping123918942cooping
coping113927672_coping
doping103919462_doping
flopping16388772flopping
flowing143411762flowing
galoping1258022galoping
globing113210002globing
glopping14307752glopping
gloving12308442gloving
glowing123211792glowing
glozing18338892glozing
groping113313102groping
hooping133615702hooping
hoping123719742_hoping
looing73621042_looing
looping103615282looping
lopping123815222_lopping
losing74022872_losing
louping104313982_louping
loving104416722_loving
lowing104623272_lowing
loxing143615272_loxing
moping114017102_moping
oping86322412__oping
plopping12318702plopping
plowing133111722plowing
ploying132811572ploying
pooping123615442pooping
roping94023022_roping
sapping123519312sapping
scaping123715692scaping
scooping133610632scooping
scoring103117212scoring
scowing133812092scowing
seeping103817912seeping
shaping133116182shaping
shoeing113211882shoeing
shooing112112912shooing
shopping163611292shopping
shoring112820072shoring
shoving142910642shoving
showing143814662showing
siloing83215502silo_ing
siping94220632s_iping
sipping123117432sipping
slaking123717472slaking
slapping133510842slapping
slating83724652slating
slaving113514832slaving
slaying113316842slaying
sleeping113812052sleeping
slewing113311352slewing
slicing103514642slicing
sliding93114552sliding
sliming102913952sliming
sling66028802sl__ing
slipping133510662slipping
slogging113410492slogging
slopingly1544592slopingly
sloshing12258822sloshing
slotting92612612slotting
sluing74315882sl_uing
slumping13359972slumping
slurping11278122slurping
smoking143210522smoking
sniping103712052sniping
snooping113811322snooping
snoring83917202snoring
snowing113913452snowing
soaping103616222soaping
soling74226822s_oling
soloing82813802soloing
solving112910852solving
sooting82820962sooting
sopping123917202sopping
soring74731882s_oring
souping104215532souping
sowing104222912s_owing
spoking143212222spoking
sporing104319412sporing
stoking123615592stoking
stomping13309762stomping
stoning83717442stoning
stooping113012362stooping
stopping133611412stopping
storing83921122storing
stowing113315132stowing
supping123814532supping
swiping13319822swiping
swooping14338402swooping
swopping16377962swopping
toping94122992_toping

Search took 4 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.403443402.0
2DLD Change Limit1076711083.47031029.1
3Display Results1081080.0333272.7
 (SQL Overall)1786911083.90645747.8
 
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.