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 “droppings” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
droppings1526450(None) 
drippings15313901drippings
dropping14309281dropping_
cropping153210892cropping_
dopings11408782d_o_pings
dripping14278032dripping_
drooping12268802drooping_
groupings13273812groupings
hoppings16306522_hoppings
propping122811672propping_
shoppings17295072shoppings
toppings13286422_toppings
trappings14265752trappings
trippings14225722trippings
wrappings17253712wrappings
bopping143512033_bopping_
brokings15317713bro_kings
bronzings2143643bronzings
cappings15369493_cappings
chopping183710263chopping_
cioppinos1542203cioppinos
clippings16273753clippings
clopping153511083clopping_
copings124111843_co_pings
copping143918593_copping_
crapping153911453crapping_
croppies143111153croppi_es
crossings12217163crossings
cuppings15336053_cuppings
dampings14377523d_ampings
dapping133714793d_apping_
dipping134014833d_ipping_
doings84913183d_o__ings
doping103919463d_o_ping_
draftings14334213draftings
draping114213353dr_aping_
drawings13386283dr_awings
dredgings13252953dredgings
dressings11265373dressings
drillings11285823drillings
drinkings15244773drinkings
drivings13265763dr_ivings
drolling103510763drolling_
droning93013723dro_ning_
drooling102610423drooling_
droopingly1742573droopingly
dropkicks1741763dropkicks
droppers13318603dropp_ers
dropsies1138703dropsi_es
drouking1436443drouking_
droving12379683dro_ving_
drowning13298363drowning_
drowsing13287773drowsing_
drubbings15262883drubbings
drypoints1542543drypoints
dumpings14295763d_umpings
dumplings15213853dumplings
dupping133711043d_upping_
flopping16388773flopping_
fopping153511133_fopping_
frapping16348103frapping_
frostings1335733frostings
glopping14307753glopping_
grapplings1642323grapplings
gripping14277543gripping_
groping113313103gro_ping_
grouping12308533grouping_
hopping154115273_hopping_
ironings9217583iro_nings
lippings13296093_lippings
lopping123815223_lopping_
mappings15296413_mappings
mopping143411473_mopping_
morphings1744683morphings
plopping12318703plopping_
popping113715413_popping_
prepping12309763prepping_
propines122618933pro_pines
rapping123619103_rapping_
raspings11337853_raspings
repping123314983_repping_
ripping123315743_ripping_
roarings9248293_roarings
rollings9419953_rollings
romping123113033_romping_
roofings12256023_roofings
roping94023023_ro_ping_
rouping103715793_rouping_
rovings11439493_ro_vings
rowings113710363_ro_wings
shippings17275683shippings
shopping163611293shopping_
slopping133811423slopping_
sopping123917203_sopping_
stopping133611413stopping_
strappings1543353strappings
stropping1436933stropping_
swopping16377963swopping_
tappings13267713_tappings
topping123514623_topping_
trapping132911393trapping_
tripping133210923tripping_
trollings10286693trollings
tromping13319603tromping_
trooping112710283trooping_
tropines102214923tro_pines
tropins93116313tro_pin_s
trouping11249503trouping_
uppings12257123__uppings
whippings20284183whippings
whopping19357373whopping_
wrapping16297623wrapping_

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411127.40620070.3
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.87522690.9
 
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.