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

138 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
hopingly173565(None) 
mopingly1636011mopingly
bodingly1536382bodingly
boringly1438402boringly
bowingly1735792bowingly
chokingly2243982chokingly
cooingly1436352cooingly
dotingly1337342dotingly
gapingly1536182gapingly
gropingly1644852gropingly
hoping123719742hoping__
howlingly1944192howlingly
japingly2135762japingly
jokingly2334772jokingly
losingly1236392losingly
lovingly1535702lovingly
movingly1735912movingly
pipingly1635702pipingly
posingly1436932posingly
rompingly1745032rompingly
rovingly1536922rovingly
slopingly1544592slopingly
wooingly1534902wooingly
achingly1736613achingly
adoringly1445423adoringly
alpinely1344343alpinely
atoningly1365363atoningly
bitingly1437383bitingly
boilingly1545903boilingly
boomingly1744793boomingly
bovinely1664423bovinely
carpingly1736673carpingly
chidingly1944243chidingly
cloyingly1843823cloyingly
coaxingly2245133coaxingly
comingle1336053comingle
coping113927663coping__
copings124111843coping_s
cryingly1735743cryingly
daringly1348573daringly
dopily123510463dopi__ly
doping103919463doping__
dopings11408783doping_s
droningly1445763droningly
droopingly1742573droopingly
erringly1237773erringly
flowingly1943963flowingly
fumingly1735743fumingly
gaspingly1644813gaspingly
gibingly1534793gibingly
glowingly1743613glowingly
growingly1744523growingly
gulpingly1644163gulpingly
haltingly1645673haltingly
hedgingly1843573hedgingly
hoeing104117023hoeing__
hokily16409093hoki__ly
hoking144419513hoking__
holily123612953holi__ly
holing104025073holing__
homily144712333homi__ly
homing123718383homing__
hominy144511483homin__y
honing103421503honing__
hooping133615703hooping__
hopping154115273hopping__
hoppings16306523hopping_s
hornily1338283ho_rnily
hosing103421103hosing__
hyping15408483hyping__
jibingly2144433jibingly
jingly174111933__jingly
jointly1735483jo_intly
joltingly2044723joltingly
joshingly2343853joshingly
jumpingly2473863jumpingly
kingly143511303__kingly
knowingly2043463knowingly
limpingly1794573limpingly
lispingly1584813lispingly
livingly1535623livingly
lollingly1345343lollingly
longingly1445333longingly
longly10279603lo__ngly
loping93921413loping__
lumpingly1784663lumpingly
luringly1237323luringly
lyingly14115263_lyingly
moaningly1535783moaningly
mockingly2143993mockingly
moilingly1545833moilingly
moping114017103moping__
mopishly1864053mopishly
musingly1436433musingly
nippingly1743983nippingly
noddingly1543783noddingly
openly1137123_open_ly
oping86322413_oping__
pinkly155012243__pinkly
plyingly1734503plyingly
popinjay2241213popinjay
popishly1844193popishly
pouringly1545953pouringly
poutingly1536483poutingly
probingly1746013probingly
pryingly1735543pryingly
pulingly1436803pulingly
ragingly1337863ragingly
raspingly1535813raspingly
ravingly1537293ravingly
rippingly1744233rippingly
roaringly1336453roaringly
rockingly1944773rockingly
ropily113312443ropi__ly
roping94023023roping__
rousingly1335773rousingly
savingly1537313savingly
shingly143210803_shingly
shiningly16155223shiningly
shockingly2342683shockingly
singly104015853__singly
soaringly1337273soaringly
sobbingly1744343sobbingly
spangly1336473_spangly
spindly13257383_spindly
supinely1376283supinely
takingly1635903takingly
taxingly1935473taxingly
tingly103815963__tingly
toping94122993toping__
tryingly1535883tryingly
unkingly1637253unkingly
urgingly1336733urgingly
vexingly2244663vexingly
vyingly1794153_vyingly
weepingly1844263weepingly
whiningly19124253whiningly
yappingly2043793yappingly

Search took 9 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.1561145455.1
2DLD Change Limit1461621388.68616827.3
3Display Results1381380.0502760.0
 (SQL Overall)1786911388.89220095.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.