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

268 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
shinily1326893(None) 
shingly143210811shingly
phonily1537102phonily
rainily10310432rainily
saintly1039342saintly
shadily1437722shadily
shakily1736902shakily
shiftily1744552shiftily
shily115222012sh__ily
shindy13449322shin_dy
shingle117711282shingle
shinier104113142shinier
shining113816522shining
shiningly16155222shiningly
shinney13368292shinney
shinny124810782shin_ny
shiny115122142shin__y
showily1636222showily
singly104015852s_ingly
slimily1247712slimily
slinkily1534852slinkily
spicily1438652spicily
spikily1635872spikily
spindly13257382spindly
stingily1236792stingily
stonily1049432stonily
sunnily1037832sunnily
thinly1238672thin_ly
tinily94014432_tinily
achingly1736623achingly
airily93014823_airily
aminity12310513aminity
blindly1335743blindly
bonnily1236873bonnily
brainily1337313brainily
cannily1239263cannily
chancily1845243chancily
charily15310283charily
chicly16429203chi_cly
chiefly1834103chiefly
childly1644803childly
chillily1644113chillily
chilly144113223chi_lly
chimbly1974593chimbly
chinchy20335513chinchy
chining133316843chining
chinky185610543chin_ky
chintzy24364223chintzy
chirpily1843773chirpily
chunkily2043083chunkily
cornily12410853cornily
crinkly16387523crinkly
daintily1245523daintily
dashingly1745163dashingly
dingily1238103_dingily
dinkly144311083_dinkly
faintly1337083faintly
finely123011563_finely
flintily1434893flintily
funnily1336373funnily
gainly1049323gain_ly
grimily1336523grimily
gushingly1744253gushingly
handily143610873_handily
hazily2179063_hazily
highly1636823_highly
hilly114422163_hi_lly
hinky155618753_hin_ky
hinny115616673_hin_ny
hiply134113613_hi_ply
hokily16409093_hokily
holily123612953_holily
homily144712333_homily
hornily1338283hornily
icily101211693__icily
inly75622213__in_ly
jingly174111933_jingly
jointly1735483jointly
joshingly2343853joshingly
juicily1935493juicily
kindly14358843_kindly
kingly143511303_kingly
kinkily1335223_kinkily
loonily1037073loonily
lyingly14115263lyingly
mainly11411493main_ly
minify1439253_minify
moonily1248943moonily
noisily1038403noisily
oilily93111723_oilily
pinkly155012243_pinkly
pricily142710283pricily
privily15207623privily
punily11311773_punily
pushingly1844733pushingly
rhinal9510193rhinal_
saining83621393saining
salinity1138893salinity
saltily10310543saltily
sanely93114613s_anely
sanity9316203s_anity
sappily1437163sappily
sassily1038723sassily
saucily1237913saucily
savingly1537313savingly
savvily1634323savvily
scantily1337583scantily
scantly12419553scantly
scarily12311703scarily
seedily1178583seedily
seining84020773seining
senile63420213s_enile
sexily1638853s_exily
shabbily1873903shabbily
shadfly1733783shadfly
shaggily1643773shaggily
shaly114322863sh__aly
shandy134710033shan_dy
shanny124110093shan_ny
shantey134210043shantey
shanty124715123shan_ty
shapely1536893shapely
sharply15406833sharply
sheerly13337703sheerly
sheila969843sh_eila
shelly124414473sh_elly
shiel811023773shi_el_
shield106212973shi_eld
shiels95418923shi_els
shifty15409263shi_fty
shill85325333sh__ill
shills94519613shi_lls
shimmy16306413shi_mmy
shin75634313shin___
shindies122610503shindies
shindig12244243shindig
shindigs13284203shindigs
shindys14314133shindys
shine85533093shin__e
shined104620783shin_ed
shiner93820873shin_er
shiners104015943shiners
shines95028913shin_es
shingled13358323shingled
shingler12268633shingler
shingles123111113shingles
shiniest113212503shiniest
shinned114310913shinned
shinnery14305673shinnery
shinneys14275093shinneys
shinnied12345823shinnied
shinnies113010913shinnies
shinning123211023shinning
shins85131043shin__s
shipway1844213shipway
shirty124312563shi_rty
shitty124110063shi_tty
shivery16317023shivery
shiviti1344863shiviti
shoaly124010773sh_oaly
shoddily1643573shoddily
shoofly1634353shoofly
shortly13387573shortly
shrill94712303sh_rill
shrilly13318563shrilly
shrining122610853shrining
shyly144811573sh__yly
sickly153110483s_ickly
sigil63515503s_igil_
sigils73912363s_igils
signify1444853signify
silkily14236963silkily
sillily10209783sillily
silly84527623s_i_lly
simile83115633s_imile
simply133010523s_imply
sinewy12667513s_inewy
single74520603s_ingle
skimpily1963053skimpily
skinny13456613skin_ny
slangily1235383slangily
slantly10399323slantly
slickly1635853slickly
slily85820033s__lily
slimly11408903sli_mly
slinky13399103slin_ky
slippily1544193slippily
smirkily1753333smirkily
smokily1635373smokily
snakily1436913snakily
snidely1136813snidely
sniffily17154033sniffily
sniffly16265643sniffly
snippily1543573snippily
snowily1336883snowily
soapily1237963soapily
soggily1235953soggily
sonly85718053s_on_ly
sootily101810523sootily
sorrily1039833sorrily
soundly1136683soundly
spangly1336473spangly
spiffily19153483spiffily
spinal84915313spinal_
spinally1338023spinally
spinals93911863spinals
spindle103210093spindle
spinel85317333spinel_
spinels94512443spinels
spinier93715163spinier
spinney12438923spinney
spinny114510183spin_ny
spinula9257903spinula
spinule9299993spinule
spiny104921303spin__y
spongily1444903spongily
spoonily1335233spoonily
springily1545583springily
spunkily1733773spunkily
stagily1139053stagily
stickily1736083stickily
stiffly16235173stiffly
stilly93714093sti_lly
stingy105213203stin_gy
stinky134611073stin_ky
stringily1346003stringily
sulkily14218113sulkily
supinely1376293supinely
surlily10310003surlily
swankily1833833swankily
swiftly1633733swiftly
swimmily1842713swimmily
swindle11389183swindle
swingby16343893swingby
swingle113510563swingle
swingy13489873swin_gy
swinish1347203swinish
swinishly1843383swinishly
swinney13365973swinney
swirly12439253swi_rly
swithly1634443swithly
tawnily1335443tawnily
thickly19415573thickly
thirdly1444633thirdly
thistly1395963thistly
thornily1444163thornily
tidily102811393_tidily
tingly103815983_tingly
tinkly134811153_tinkly
tinnily1047363tinnily
trinity10310843trinity
twinkly1733913twinkly
vainly1258503vain_ly
vinify1536923_vinify
vyingly1794153vyingly
whiney155012643whin_ey
whinier134110633whinier
whining143311673whining
whiningly19124253whiningly
whinny15587493whin_ny
whiny144915573whin__y
whirly15448863whi_rly
whitely16346473whitely
wilily123310763_wilily
windily1437943_windily
wirily123310783_wirily
wrinkly17295753wrinkly
zanily18310183_zanily

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.516346300.4
2DLD Change Limit1340272686.84319586.0
3Display Results2682680.0932881.7
 (SQL Overall)1786912687.45223978.9
 
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.