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

107 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
stoping10371662(None) 
scoping123513821scoping
sloping104114071sloping
stoking123615591stoking
stomping13309761stomping
stoning83717441stoning
stooping113012361stooping
stopping133611411stopping
storing83921121storing
stowing113315131stowing
toping94122991_toping
atoning83514872atoning
cooping123918932cooping
coping113927662_coping
doping103919462_doping
eloping103512832eloping
estopping1434792estopping
groping113313102groping
hooping133615702hooping
hoping123719742_hoping
looping103615282looping
loping93921412_loping
moping114017102_moping
oping86322412__oping
pooping123615442pooping
roping94023022_roping
sapping123519312sapping
scaping123715692scaping
scooping133610632scooping
scoring103117212scoring
scowing133812092scowing
seeping103817912seeping
shaping133116182shaping
shoeing113211882shoeing
shooing112112912shooing
shopping163611292shopping
shoring112820072shoring
shoving142910642shoving
showing143814662showing
siping94220632s_iping
sipping123117432sipping
sliping103314412sliping
slopping133811422slopping
slowing112814742slowing
smoking143210522smoking
sniping103712052sniping
snooping113811322snooping
snoring83917202snoring
snowing113913452snowing
soaping103616222soaping
soling74226822s_oling
sooting82820962sooting
sopping123917202sopping
soring74731882s_oring
souping104215532souping
sowing104222912s_owing
spoking143212222spoking
sporing104319412sporing
staging93818372staging
staking123919802staking
staling83925422staling
stamping133310962stamping
staning83922242staning
stapling112813152stapling
staring84527052staring
stating83725162stating
staving113915702staving
staying114017322staying
steeping113412582steeping
stepping13329072stepping
stewing113412492stewing
sting65330242st__ing
stobbing13227242stobbing
stocking152912502stocking
stodging11277462stodging
stooging102810042stooging
stooking132711142stooking
stooling93113132stooling
stoppling1474962stoppling
storming11209422storming
storying12249672storying
stotin63215062stotin_
stotins73213872stotins
stotting92811162stotting
string75327562st_ring
striping112612522striping
stroking132610942stroking
stropping1436932stropping
strowing122310562strowing
stroying122410592stroying
stumping13289082stumping
stying105414572st_ying
styling112910652styling
supping123814532supping
swiping13319822swiping
swooping14338402swooping
swopping16377962swopping
taping94222392_taping
toeing74418472_toeing
toking114420722_toking
toling73926122_toling
toning74025792_toning
topping123514622_topping
toting74123792_toting
towing103823192_towing
toying105017302_toying
typing124110582_typing

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.406440125.6
2DLD Change Limit1076711073.51630623.2
3Display Results1071070.0303566.7
 (SQL Overall)1786911073.95245215.3
 
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.