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

132 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
estopped133499(None) 
estoppel1243171estoppel
stopped124512201_stopped
estoppels1342352estoppels
shopped153512212_shopped
slopped123511442_slopped
sopped114819902_s_opped
stepped123210052_stepped
stomped124110532_stomped
stooped103813832_stooped
stoped94721012_sto_ped
stopper113012602_stopper
stoppled1345002_stoppled
stropped1367342_stropped
swopped15437672_swopped
topped114617722__topped
unstopped1444402unstopped
astonied978983astonied
bestowed14156623besto_wed
bopped134413403__bopped
chopped174511003_chopped
clopped143611523_clopped
copped135221253__copped
cropped143812063_cropped
dropped13329283_dropped
eloped95914143e_lo_ped
entoiled968283entoiled
entombed13104503entombed
entrapped1484873entrapped
equipped2243073equipped
escaped12388853es_caped
escarped1355163escarped
escorted1136703escorted
escoted1038183esco_ted
espied9359773es__pied
espoused1134853espoused
estated83715573est_ated
esteemed1144483esteemed
estop74312103esto_p__
estoppage1452353estoppage
estoppages1552453estoppages
estopping1434793estopping
estops84011223esto_p_s
estrayed1236393estrayed
extolled1654313extolled
extorted1636233extorted
festooned1344303festooned
flopped15338763_flopped
fopped144012673__fopped
glopped13347613_glopped
hopped144318113__hopped
knopped16355453_knopped
lopped114218623__lopped
misstopped17102813misstopped
mopped134114323__mopped
overtopped1844653overtopped
plopped11288773_plopped
popped104117813__popped
propped113311953_propped
reshipped1753893reshipped
restamped1444433restamped
restocked1655173restocked
restoked135710533resto_ked
restored96417193resto_red
sapped114422013_s_apped
scooped124611743_scooped
scoped115116653_sco_ped
shipped153312103_shipped
shoppe133110323_shoppe_
shopper143312633_shopper
shoppes143411403_shoppes
sipped113720633_s_ipped
skipped16358413_skipped
slapped123511853_slapped
slipped124711743_slipped
sloped94216853_slo_ped
snapped124611203_snapped
snipped123510043_snipped
snooped103711813_snooped
soaped95817973_s_oaped
souped95017673_s_ouped
stamped124812813_stamped
stapled103613703_stapled
steeped103412283_steeped
steppe10319873_steppe_
stepper113010853_stepper
steppes113110693_steppes
stiped94517073_st_iped
stippled1345303_stippled
stobbed12287493_stobbed
stocked144312873_stocked
stodged10377983_stodged
stoked114718293_sto_ked
stoled74521593_sto_led
stomper114111233_stomper
stoned75923143_sto_ned
stooged94310733_stooged
stooked124312303_stooked
stooled84313893_stooled
stooper93813193_stooper
stope74727243_sto_pe_
stoper84320103_sto_per
stopes84525893_sto_pes
stoppered1444473_stoppered
stoppers123910593_stoppers
stopple1156583_stopple
stopples1236953_stopples
stored75524213_sto_red
storied8515163_storied
stormed1039043_stormed
stotted83511423_stotted
stowed105817203_sto_wed
strapped1357823_strapped
striped105214363_striped
stripped1357093_stripped
stropper1247763_stropper
stumped124210153_stumped
supped114415703_s_upped
swapped15429143_swapped
swooped13418753_swooped
tapped113820053__tapped
tipped114418263__tipped
toped85631313__to_ped
topper103817603__topper
toppled12348843__toppled
tupped114013233__tupped
unstepped1444213unstepped
unstopper1343523unstopper
untapped1376613untapped
untipped1335763untipped
upstepped1341943upstepped
whopped18358003_whopped

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621327.36019859.0
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.82922824.2
 
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.