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

120 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
wastingly163637(None) 
lastingly1337241lastingly
dartingly1436952dartingly
dashingly1745162dashingly
gaspingly1644812gaspingly
haltingly1645702haltingly
jestingly2045952jestingly
pantingly1537862pantingly
passingly1545782passingly
rantingly1337932rantingly
raspingly1535812raspingly
wailingly1635522wailingly
warningly1635512warningly
wasting114422842wasting__
wittingly1644802wittingly
achingly1736623_achingly
atingle848253_a_tingle
basting104227203basting__
bastings114214693basting_s
bitingly1437393_bitingly
bustlingly1643063bustlingly
calmingly1745623calmingly
carpingly1736683carpingly
cassingle1244103cassingle
casting104628343casting__
castings113614053casting_s
crashingly1964083crashingly
cuttingly1545373cuttingly
damningly1644763damningly
daringly1348573da_ringly
darlingly1436053darlingly
daubingly1644263daubingly
dauntingly1544233dauntingly
dotingly1337343_dotingly
easting84924303easting__
eastings93412953easting_s
exactingly2343483exactingly
failingly1636133failingly
fasting114522833fasting__
fastings124011943fasting_s
fawningly1944053fawningly
fittingly1645273fittingly
gallingly1435863gallingly
gapingly1536183ga_pingly
gasting95022763gasting__
graspingly1743363graspingly
gratingly1437403gratingly
gushingly1744253gushingly
hastily133010663hasti__ly
hasting114725193hasting__
hauntingly1743813hauntingly
japingly2135763ja_pingly
jarringly2045193jarringly
joltingly2044733joltingly
joshingly2343853joshingly
juttingly2044583juttingly
lasting84725243lasting__
lastings94214423lasting_s
liltingly1345443liltingly
lispingly1584813lispingly
losingly1236393los_ingly
masting104325823masting__
meltingly1546303meltingly
musingly1436433mus_ingly
naggingly1544273naggingly
nastily103011033nasti__ly
pasting103826553pasting__
posingly1436933pos_ingly
poutingly1536483poutingly
pratingly1538373pratingly
pushingly1844733pushingly
rackingly1945123rackingly
ragingly1337863ra_gingly
rattlingly1443653rattlingly
ravingly1537293ra_vingly
savingly1537313sa_vingly
shingly143210813__shingly
singly104015853__s_ingly
slantingly1445153slantingly
slashingly1743863slashingly
smashingly1943193smashingly
stingily1236793__stingily
stingy105213203__sting_y
swishingly2042903swishingly
takingly1635913ta_kingly
tastily103311643tasti__ly
tasting84624213tasting__
tauntingly1443913tauntingly
taxingly1935483ta_xingly
teasingly1346053teas_ingly
tingly103815983___tingly
trustingly1444373trustingly
varyingly1944693varyingly
vaultingly1743413vaultingly
vauntingly1743623vauntingly
wafting143911663wafting__
waisting123615213waisting__
waistings1352710763waisting_s
waiting113618953waiting__
waitings123413743waiting_s
wanting114220173wanting__
wantonly1443063wanton_ly
washing145119283washing__
washings15419273washing_s
waspily1535513waspi__ly
waspishly2042613waspishly
waveringly2043723waveringly
wearingly1636413wearingly
weepingly1844263weepingly
westing115020273westing__
westings12429803westing_s
whiningly19124263whiningly
willingly1645403willingly
windingly1745323windingly
winkingly2044343winkingly
winningly1644413winningly
wisting113519743wisting__
wooingly1534903w_ooingly
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.420425454.8
2DLD Change Limit1486411207.00021234.4
3Display Results1201200.0502400.0
 (SQL Overall)1786911207.47023921.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.