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

136 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
sopping12391720(None) 
bopping143512031bopping
copping143918591copping
fopping153511131fopping
hopping154115271hopping
lopping123815221lopping
mopping143411471mopping
popping113715411popping
sapping123519311sapping
shopping163611291shopping
sipping123117431sipping
slopping133811421slopping
soaping103616221soaping
souping104215531souping
stopping133611411stopping
supping123814531supping
swopping16377961swopping
topping123514621topping
capping143819672capping
chopping183710262chopping
clopping153511082clopping
comping143518592comping
cooping123918932cooping
coping113927662co_ping
copying153411982copying
couping124317022couping
cropping153210882cropping
cupping144312382cupping
dapping133714792dapping
dipping134014832dipping
doping103919462do_ping
dropping14309282dropping
dupping133711042dupping
estopping1434792estopping
flopping16388772flopping
gapping134214782gapping
gipping133813122gipping
glopping14307752glopping
gypping16305842gypping
happing153817232happing
hipping153915102hipping
hooping133615702hooping
hoping123719742ho_ping
hoppings16306522hoppings
hoppling16206762hoppling
kepping16268592kepping
kipping163311872kipping
lapping124117022lapping
lipping123016072lipping
looping103615282looping
loping93921412lo_ping
louping104313982louping
mapping143413992mapping
moping114017102mo_ping
napping123514182napping
nipping123412872nipping
oping86322412_o_ping
opting94514402_opting
pepping113511622pepping
pipping113414742pipping
plopping12318702plopping
pooping123615442pooping
poppling12227322poppling
propping122811672propping
pupping114412502pupping
rapping123619102rapping
repping123314982repping
ripping123315742ripping
romping123113032romping
roping94023022ro_ping
rouping103715792rouping
sapling103217862sapling
scaping123715692scaping
scooping133610632scooping
scoping123513822scoping
seeping103817912seeping
shaping133116182shaping
shipping163611252shipping
shoppings17295072shoppings
siping94220632s_iping
skipping17297602skipping
slapping133510832slapping
sliping103314412sliping
slipping133510662slipping
sloping104114072sloping
snapping13349652snapping
sniping103712052sniping
snipping13308852snipping
snooping113811322snooping
soaking123116612soaking
soaring83521892soaring
sobbing127612882sobbing
socking143518602socking
sodding103712732sodding
soiling83422322soiling
soling74226822so_ling
soloing82813802soloing
solving112910852solving
sooting82820962sooting
sopiting11310762sopiting
soppier112711582soppier
sorbing102815262sorbing
soring74731882so_ring
sorning83116812sorning
sorting83221812sorting
souring83219062souring
sousing83517822sousing
sowing104222912so_wing
spoking143212222spoking
sporing104319412sporing
spring94526012s_pring
spuing94313362s_puing
spying123913252s_pying
stepping13329072stepping
stomping13309762stomping
stooping113012362stooping
stoping103716622stoping
stoppling1474962stoppling
stropping1436932stropping
suppling1359042suppling
swapping16348672swapping
swiping13319822swiping
swooping14338402swooping
tapping123317132tapping
tipping122814972tipping
toping94122992to_ping
toppings13286422toppings
toppling13197352toppling
tupping123411662tupping
upping114013702_upping
wapping153514602wapping
whopping19357372whopping
yapping153412612yapping
yipping152710682yipping
zapping213211472zapping
zipping212910572zipping

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.376475242.0
2DLD Change Limit1076711363.48330913.3
3Display Results1361360.0462956.5
 (SQL Overall)1786911363.90545759.5
 
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.