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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

68 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
yawningly194348(None) 
fawningly1944051fawningly
damningly1644762damningly
warningly1635512warningly
yappingly2043792yappingly
yawning14378342yawning__
yearningly1743382yearningly
achingly1736613_achingly
atoningly1365373atoningly
awning105013393_awning__
awninged1342433_awninged
awnings11406713_awning_s
bowingly1735793bow_ingly
burningly1545043burningly
calmingly1745613calmingly
carpingly1736673carpingly
cunningly1545533cunningly
daringly1348573da_ringly
darlingly1436043darlingly
dartingly1436943dartingly
dashingly1745163dashingly
daubingly1644263daubingly
dauntingly1544223dauntingly
dawning124111013dawning__
drawlingly1843293drawlingly
droningly1445763droningly
failingly1636123failingly
fawning14409133fawning__
frowningly2042843frowningly
gallingly1435853gallingly
gapingly1536183ga_pingly
gaspingly1644813gaspingly
gnawingly1763933gnaw_ingly
haltingly1645693haltingly
hauntingly1743803hauntingly
howlingly1944193howlingly
japingly2135763ja_pingly
jarringly2045193jarringly
lastingly1337233lastingly
meaningly1546413meaningly
moaningly1535783moaningly
naggingly1544273naggingly
pantingly1537853pantingly
passingly1545783passingly
pawning134711413pawning__
punningly1545153punningly
rackingly1945113rackingly
ragingly1337863ra_gingly
rantingly1337923rantingly
raspingly1535813raspingly
ravingly1537293ra_vingly
savingly1537313sa_vingly
shiningly16155223shiningly
takingly1635913ta_kingly
tauntingly1443903tauntingly
tawnily1335443tawni__ly
taxingly1935483ta_xingly
varyingly1944683varyingly
vauntingly1743613vauntingly
wailingly1635513wailingly
wastingly1636363wastingly
whiningly19124253whiningly
winningly1644413winningly
yarning113512953yarning__
yawing134215613yaw_ing__
yawling14369183yawling__
yawping16357333yawping__
yawpings17253583yawping_s

Search took 7 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.420425454.8
2DLD Change Limit148641686.00024773.5
3Display Results68680.0332060.6
 (SQL Overall)178691686.45327691.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.