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

131 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
lopping12381522(None) 
bopping143512031bopping
clopping153511081clopping
copping143918591copping
flopping16388771flopping
fopping153511131fopping
glopping14307751glopping
hopping154115271hopping
lapping124117021lapping
lipping123016071lipping
looping103615281looping
loping93921411lo_ping
louping104313981louping
mopping143411471mopping
plopping12318701plopping
popping113715411popping
slopping133811421slopping
sopping123917201sopping
topping123514621topping
blipping15306802blipping
blooping13248842blooping
capping143819672capping
chopping183710262chopping
clapping153810602clapping
clipping15349152clipping
clomping15329652clomping
comping143518592comping
cooping123918932cooping
coping113927662co_ping
copying153411982copying
couping124317022couping
cropping153210882cropping
cupping144312382cupping
dapping133714792dapping
dipping134014832dipping
doping103919462do_ping
dropping14309282dropping
dupping133711042dupping
eloping103512832elo_ping
flapping16298152flapping
flipping16307662flipping
gapping134214782gapping
gipping133813122gipping
gypping16305842gypping
happing153817232happing
hipping153915102hipping
hooping133615702hooping
hoping123719742ho_ping
hoppings16306522hoppings
hoppling16206762hoppling
kepping16268592kepping
kipping163311872kipping
lamping123116002lamping
lapsing103511162lapsing
lapwing13308262lapwing
leaping103215992leaping
limping124614112limping
lippings13296092lippings
lisping103412752lisping
loading94114612loading
loafing11319792loafing
loaming103613732loaming
loaning83614832loaning
lobbing123110912lobbing
locking143718152locking
locoing102810972locoing
lodging103110812lodging
lofting113311312lofting
logging103316802logging
loiding93313402loiding
lolling83415772lolling
longing93915782longing
looing73621042lo_oing
looking123415042looking
looming102814852looming
loosing83515962loosing
looting83019642looting
loppering14237282loppering
loppier11369722loppier
lording93115232lording
losing74022872lo_sing
lotting82917752lotting
louring83916502louring
lousing83817732lousing
louting83719382louting
loving104416722lo_ving
lowing104623272lo_wing
loxing143615272lo_xing
lumping123314642lumping
mapping143413992mapping
moping114017102mo_ping
napping123514182napping
nipping123412872nipping
oping86322412_o_ping
opting94514402_opting
pepping113511622pepping
pipping113414742pipping
pooping123615442pooping
poppling12227322poppling
propping122811672propping
pupping114412502pupping
rapping123619102rapping
repping123314982repping
ripping123315742ripping
romping123113032romping
roping94023022ro_ping
rouping103715792rouping
sapping123519312sapping
shopping163611292shopping
sipping123117432sipping
slapping133510832slapping
slipping133510662slipping
sloping104114072slo_ping
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 Limit1076711313.14334257.4
3Display Results1311310.0462847.8
 (SQL Overall)1786911313.56250165.9
 
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.