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

104 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
mopping14341147(None) 
bopping143512031bopping
copping143918591copping
fopping153511131fopping
hopping154115271hopping
lopping123815221lopping
mapping143413991mapping
moping114017101mo_ping
popping113715411popping
sopping123917201sopping
topping123514621topping
capping143819672capping
chopping183710262chopping
clopping153511082clopping
comping143518592comping
cooping123918932cooping
coping113927662co_ping
copying153411982copying
couping124317022couping
cropping153210882cropping
cupping144312382cupping
dapping133714792dapping
dipping134014832dipping
doping103919462do_ping
dropping14309282dropping
dupping133711042dupping
flopping16388772flopping
gapping134214782gapping
gipping133813122gipping
glopping14307752glopping
gypping16305842gypping
happing153817232happing
hipping153915102hipping
hooping133615702hooping
hoping123719742ho_ping
hoppings16306522hoppings
hoppling16206762hoppling
kepping16268592kepping
kipping163311872kipping
lapping124117022lapping
lipping123016072lipping
looping103615282looping
loping93921412lo_ping
louping104313982louping
mappings15296412mappings
moaning103714442moaning
moating104218152moating
mobbing14299702mobbing
mocking163614452mocking
mogging123311492mogging
moiling103417662moiling
molding114213752molding
molting103517172molting
mooing93718372mo_oing
mooning103415552mooning
mooring102514442mooring
mooting103019362mooting
morning103215042morning
morphing1637552morphing
moshing134214882moshing
mossing103915422mossing
mousing103816272mousing
moving123913282mo_ving
mowing124119092mo_wing
mumping143411632mumping
napping123514182napping
nipping123412872nipping
oping86322412_o_ping
opting94514402_opting
pepping113511622pepping
pipping113414742pipping
plopping12318702plopping
pooping123615442pooping
poppling12227322poppling
propping122811672propping
pupping114412502pupping
rapping123619102rapping
repping123314982repping
ripping123315742ripping
romping123113032romping
roping94023022ro_ping
rouping103715792rouping
sapping123519312sapping
shopping163611292shopping
sipping123117432sipping
slopping133811422slopping
soaping103616222soaping
souping104215532souping
stopping133611412stopping
supping123814532supping
swopping16377962swopping
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.373479064.3
2DLD Change Limit1076711042.90637051.3
3Display Results1041040.0333151.5
 (SQL Overall)1786911043.31253952.6
 
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.