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

135 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
lastingly133723(None) 
wastingly1636361wastingly
dartingly1436942dartingly
dashingly1745162dashingly
gaspingly1644812gaspingly
haltingly1645692haltingly
jestingly2045952jestingly
lasting84725242lasting__
lastings94214422lasting_s
liltingly1345432liltingly
lispingly1584812lispingly
losingly1236392los_ingly
pantingly1537852pantingly
passingly1545782passingly
rantingly1337922rantingly
raspingly1535812raspingly
slantingly1445142slantingly
slashingly1743862slashingly
achingly1736613_achingly
alarmingly1643243alarmingly
atingle848253_a_tingle
basting104227203basting__
bastings114214693basting_s
bitingly1437383_bitingly
blasting114013433blasting__
blastings12347913blasting_s
blazingly2444473bla_zingly
blushingly1942973blushingly
bustlingly1643063bustlingly
calmingly1745613calmingly
carpingly1736673carpingly
cassingle1244103cassingle
casting104628343casting__
castings113614053casting_s
clankingly2043303clankingly
crashingly1964083crashingly
cuttingly1545363cuttingly
damningly1644763damningly
daringly1348573da_ringly
darlingly1436043darlingly
daubingly1644263daubingly
dauntingly1544223dauntingly
dotingly1337343_dotingly
easting84924303easting__
eastings93412953easting_s
exactingly2343473exactingly
failingly1636123failingly
fasting114522833fasting__
fastings124011943fasting_s
fawningly1944053fawningly
fittingly1645263fittingly
flaggingly1942823flaggingly
flamingly1845023fla_mingly
flaringly1646253fla_ringly
flauntingly1842183flauntingly
fleetingly1743583fleetingly
gallingly1435853gallingly
gapingly1536183ga_pingly
gasting95022763gasting__
glancingly1742873glancingly
glaringly1445823gla_ringly
gloatingly1543553gloatingly
graspingly1743363graspingly
gratingly1437393gratingly
gushingly1744253gushingly
hastily133010663hasti__ly
hasting114725193hasting__
hauntingly1743803hauntingly
japingly2135763ja_pingly
jarringly2045193jarringly
joltingly2044723joltingly
joshingly2343853joshingly
juttingly2044583juttingly
lashing114422893lashing__
lashings124412253lashing_s
lasing74727983las_ing__
lastly93310873last___ly
latently1146353la_tently
latinity1138813la_tinity
laughingly1842703laughingly
leeringly1345963leeringly
limitingly1643493limitingly
limpingly1794573limpingly
listing84020593listing__
listings93310043listing_s
livingly1535633l_ivingly
lollingly1345343lollingly
longingly1445333longingly
lovingly1535703l_ovingly
lumpingly1784663lumpingly
luringly1237323l_uringly
lurkingly1744573lurkingly
lustily103611243lusti__ly
lusting83619323lusting__
lyingly14115263l__yingly
masting104325823masting__
meltingly1546293meltingly
musingly1436433mus_ingly
naggingly1544273naggingly
nastily103011033nasti__ly
pasting103826553pasting__
placatingly1952323placatingly
plasticly1644763plasti_cly
pleasingly1644163pleas_ingly
posingly1436933pos_ingly
poutingly1536483poutingly
pratingly1538363pratingly
pushingly1844733pushingly
rackingly1945113rackingly
ragingly1337863ra_gingly
rattlingly1443643rattlingly
ravingly1537293ra_vingly
savingly1537313sa_vingly
shingly143210813__shingly
singly104015853__s_ingly
smashingly1943193smashingly
stingily1236793__stingily
stingy105213203__sting_y
takingly1635913ta_kingly
tastily103311643tasti__ly
tasting84624213tasting__
tauntingly1443903tauntingly
taxingly1935483ta_xingly
teasingly1346053teas_ingly
tingly103815973___tingly
trustingly1444373trustingly
varyingly1944683varyingly
vaultingly1743403vaultingly
vauntingly1743613vauntingly
wailingly1635513wailingly
warningly1635513warningly
wasting114422843wasting__
wittingly1644793wittingly
yappingly2043793yappingly
yawningly1943483yawningly

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.403443402.0
2DLD Change Limit1486411357.06321045.0
3Display Results1351350.0632142.9
 (SQL Overall)1786911357.52923733.7
 
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.