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

214 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
wackily193605(None) 
tackily1637501tackily
balkily16266692balkily
cockily1838492cockily
gawkily1834092gawkily
hackly18298732hack_ly
ickily1535752_ickily
lacily11612762lac_ily
lankily1437122lankily
luckily16297082luckily
muckily18277742muckily
packly17228332pack_ly
pawkily1934202pawkily
pockily1846232pockily
racily11715172rac_ily
swankily1833832swankily
tackify1934492tackify
wackier16369732wackier
wacky174714932wack__y
warily122915092wa_rily
waspily1535512waspily
wavily15219482wa_vily
waxily19218412wa_xily
acidly125211793_acidly
acidy117214903_ac_idy
acridly13396533_acridly
acuity1139373_acuity
aerily93017013_aerily
airily93014823_airily
artily92814713_artily
backfill1965063backfill
backing165523443backing
backlit15911903backlit
baggily1436043baggily
balmily14216463balmily
bawdily1635803bawdily
blackfly2243013blackfly
blackly1835253black_ly
bulkily16227123bulkily
cackle143416923cack_le
cagily12411563ca_gily
campily1638273campily
cannily1239263cannily
cattily123210853cattily
crackly18397703crack_ly
crankily1755623crankily
dacoity1366183dacoity
daffily1735143daffily
daily95922333da__ily
dandily12279633dandily
dankly14419463dank_ly
darkly145411073dark_ly
daylily1434983daylily
duskily15236753duskily
easily9313023ea_sily
facile112514883fac_ile
family143311703fa_mily
fancily1538253fancily
fattily13379463fattily
feckly18335963feck_ly
fickly18318533fick_ly
flakily1736293flakily
flukily1735213flukily
funkily1736513funkily
gaily95020973ga__ily
gamily123712183ga_mily
gassily1137813gassily
gaudily1236523gaudily
gauzily2034393gauzily
hackie154615623hacki_e
hackies163418243hackies
hacking173720613hacking
hackle154916813hack_le
hackney1935123hackney
hammily1736063hammily
handily143610873handily
happily1745763happily
hardily143310273hardily
hastily133010663hastily
hazily2179063ha_zily
hokily16409093_hokily
huskily17236333huskily
icily101211693_ic_ily
itchily1574493itchily
jackal1937613jackal_
jackals2036893jackals
jackies202912623jackies
jacking214515263jacking
jacky215412343jack__y
jazzily2533373jazzily
jerkily2134623jerkily
jokily20306533_jokily
kinkily1335223kinkily
lackey154813353lack_ey
lacking143821543lacking
lankly13439623lank_ly
lazily1859713la_zily
leakily1436473leakily
mackle143716433mack_le
mangily1339753mangily
manlily1238743manlily
mazily20610393ma_zily
milkily16216553milkily
mirkily16266403mirkily
murkily16287113murkily
muskily16289043muskily
nastily103011033nastily
nattily103610323nattily
pacify1667473pac_ify
packing164420723packing
patchily1885813patchily
perkily1637813perkily
peskily1635083peskily
pluckily1963413pluckily
pokily15309063_pokily
quakily2336693quakily
rackety16499113rackety
racking144323663racking
rackingly1945123rackingly
rackle123917293rack_le
rainily10310433rainily
rankly133910453rank_ly
riskily1436413riskily
sacking144122703sacking
saltily10310543saltily
sappily1437163sappily
sassily1038723sassily
saucily1237913saucily
savvily1634323savvily
scarily12311703scarily
shakily1736903shakily
sicklily1744293sicklily
sickly153110483sick_ly
silkily14236963silkily
slackly1635263slack_ly
smokily1635373smokily
snakily1436913snakily
snarkily1534583snarkily
sparkily1735023sparkily
spikily1635873spikily
stalkily1534823stalkily
stickily1736083stickily
stockily1735443stockily
sulkily14218113sulkily
tacitly1236223tacitly
tackey154613083tack_ey
tackier133712523tackier
tacking144421483tacking
tackle123815733tack_le
tacky145617443tack__y
tactile9310613tactile
tardily11269583tardily
tartily103511573tartily
tastily103311643tastily
tattily10409993tattily
tawnily1335443tawnily
techily1537123techily
trickily1736233trickily
vacuity1545763vacuity
vakil1259793va_kil_
vakils1337593va_kils
wabbly16348363wa_bbly
wack135330913wack___
wacke145918623wack__e
wacker154920123wack_er
wackes154717713wack_es
wackest164710863wackest
wackiest172610273wackiest
wacko145514383wack__o
wackos155210993wack_os
wacks146626283wack__s
waddly14478723wa_ddly
waffly18305433wa_ffly
waggly14347293wa_ggly
wail75238823wa__il_
wails86631483wa__ils
wakiki1233463wa_kiki
waking144821383wa_king
walking154013303walking
walkway2043373walkway
wally114625093wa__lly
waly105830903wa___ly
wambly16388663wa_mbly
wanking154216783wanking
wanly115118023wa__nly
warking153519573warking
warmly14228073wa_rmly
waterily1438793waterily
wauking153410013wauking
waxbill1943133waxbill
waybill1543723waybill
weakly1636483weak_ly
wearily1338783wearily
weedily1476123weedily
weekly1635313week_ly
weevily1694643weevily
whackier2044673whackier
whacking21377483whacking
whacky21556493whack__y
wickedly2142793wickedly
wicking173414773wicking
wickiup18172673wickiup
wilily123310763w_ilily
wily106428823w___ily
windily1437943windily
wirily123310783w_irily
wispily1535653wispily
wittily1336173wittily
woozily2234383woozily
wordily1437853wordily
wracking18349963wracking
wrathily1744773wrathily
yacking174315683yacking
zanily18310183za_nily

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272146.69020033.9
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.16924925.5
 
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.