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 “staringly” 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
staringly133796(None) 
searingly1338271searingly
soaringly1337271soaringly
sparingly1537281sparingly
daringly1348572_daringly
flaringly1646252flaringly
glaringly1445822glaringly
roaringly1336452roaringly
savingly1537312s_avingly
staring84527052staring__
startlingly1542752startlingly
sterlingly1445202sterlingly
stringily1346002st_ringily
stringy114111072st_ring_y
strongly1245952st_rongly
takingly1635902_takingly
taxingly1935472_taxingly
wearingly1636412wearingly
adoringly1445423adoringly
alarmingly1643233alarmingly
amazingly2444123amazingly
atoningly1365363atoningly
beamingly1745843beamingly
blazingly2444463blazingly
boringly1438403_boringly
bracingly1745943bracingly
carpingly1736673_carpingly
charmingly2143413charmingly
coaxingly2245133coaxingly
darlingly1436033_darlingly
dartingly1436933_dartingly
erringly1237773_erringly
evadingly1744133evadingly
flamingly1845023flamingly
gapingly1536183_gapingly
gnawingly1763923gnawingly
gratingly1437393gratingly
grazingly2344933grazingly
japingly2135763_japingly
jarringly2045193jarringly
jeeringly2045143jeeringly
leeringly1345963leeringly
luringly1237323_luringly
meaningly1546413meaningly
moaningly1535783moaningly
pouringly1545953pouringly
pratingly1538363pratingly
purringly1545743purringly
quakingly2644223quakingly
ragingly1337863_ragingly
ravingly1537293_ravingly
retiringly1444503retiringly
saintly1039343s_a_intly
scarily12311703scari__ly
scaring103421973scaring__
scathingly1943303scathingly
searchingly2042843searchingly
searing83330923searing__
seemingly1545713seemingly
sharing113723243sharing__
shingly143210803s__hingly
shiningly16155223shiningly
sidlingly1445083sidlingly
singly104015853s___ingly
slantingly1445133slantingly
slashingly1743863slashingly
slopingly1544593slopingly
smashingly1943193smashingly
smilingly1545733smilingly
snaring83920953snaring__
sneakingly1843813sneakingly
soaring83521893soaring__
soarings93210393soaring_s
sobbingly1744343sobbingly
spangly1336473spa__ngly
sparing104823873sparing__
sportingly1645543sportingly
springily1545583s_pringily
springy13359663s_pring_y
staggeringly1851363staggeringly
stagily1139053stagi__ly
staging93818373staging__
stagings10378343staging_s
staidly1136683sta_i_dly
staking123919803staking__
staling83925423staling__
staminal1046983staminal_
staminody1541743staminody
staning83922243staning__
starchily1745013starchily
starkly14277033star__kly
starling93017123starling__
starlings10237923starling_s
starring92312953starring__
starting93116173starting__
starving122510173starving__
stating83725163stating__
staving113915703staving__
staying114017323staying__
sterilely1244603sterilely
sternly1037853ster_n_ly
stiflingly1743433stiflingly
stingily1236793st__ingily
stingingly1544093stingingly
stingy105213203st__ing_y
stinkingly1843843stinkingly
storing83921123storing__
straggly13355563st_raggly
straitly1136563strai_tly
strangely1345413st_rangely
strangle98411503st_rangle
strictly1345813st_rictly
strikingly1843713strikingly
string75327563st_ring__
stringed102911873st_ringed
stringer93812943st_ringer
strings84617133st_ring_s
strongyl1243553st_rongyl
stunningly1443173stunningly
swirlingly1743413swirlingly
tangly104413913_ta__ngly
taring73932283_taring__
teasingly1346043teasingly
tingly103815963_t__ingly
trigly103810943_t_ri_gly
tryingly1535883_tryingly
unsparingly1753533unsparingly
untiringly1445003untiringly
varyingly1944683_varyingly
veeringly1645473veeringly
warningly1635513_warningly
yearningly1743383yearningly

Search took 10 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.1561145455.1
2DLD Change Limit1486411329.37615853.3
3Display Results1321320.0632095.2
 (SQL Overall)1786911329.59518623.3
 
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.