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

269 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
shadily143772(None) 
shadfly1733781shadfly
shakily1736901shakily
beadily1378842beadily
charily15310282charily
handily143610872_handily
hardily143310272_hardily
hazily2179062_hazily
headily1478622headily
readily11711402readily
sadly94519122s_ad_ly
scarily12311702scarily
seedily1178582seedily
shabbily1873902shabbily
shadier113111152shadier
shading123115562shading
shadowily1982022shadowily
shadowy1744722shadowy
shady125416512shad__y
shaggily1643772shaggily
shaly114322862sha__ly
shapely1536892shapely
sharply15406832sharply
shily115222012sh__ily
shinily13268932shinily
shoddily1643562shoddily
showily1636212showily
snakily1436912snakily
soapily1237962soapily
stagily1139052stagily
staidly1136682staidly
steadily1236212steadily
badly114918763_bad_ly
bawdily1635803bawdily
beamily1477393beamily
bodily12310993_bodily
cagily12411563_cagily
chally144314293cha_lly
chancily1845243chancily
charity15311023charity
chattily1634603chattily
crazily2136923crazily
daily95922333_da_ily
dandily12279633dandily
deadly113811473dead_ly
dowdily1534953dowdily
easily9313023_easily
family143311703_family
flakily1736293flakily
foamily1546543foamily
gadfly1434663_gadfly
gaily95020973_ga_ily
gamily123712183_gamily
gaudily1236523gaudily
ghastly14354563ghastly
giddily1335073giddily
gladly11497933glad_ly
glazily2035383glazily
habile11515203_habile
hackly18298733_hackly
hadal95518123_hadal_
hading113922943_hading
hadith13312063_hadith
hail74839063_ha_il_
hails85231643_ha_ils
hairy115316833_ha_iry
hammily1736063_hammily
haply135915063_ha_ply
happily1745763_happily
hardly135112833_hardly
hastily133010663_hastily
heavily1665903heavily
hoarily1338973hoarily
hokily16409093_hokily
holily123612953_holily
homily144712333_homily
khadi1367603khadi__
khadis1446913khadi_s
lacily11612763_lacily
lazily1859713_lazily
leakily1436473leakily
madly115218133_mad_ly
mazily20610393_mazily
meatily12311093meatily
moodily1358203moodily
muddily1435963muddily
needily1166323needily
phonily1537103phonily
quakily2336693quakily
racily11715173_racily
reedily1179603reedily
rowdily1436083rowdily
ruddily1236303ruddily
saddle83915493s_addle
sadi55834643s_adi__
sadis64930853s_adi_s
sadism94113493s_adism
sadist74221353s_adist
safely12249393s_afely
sagely102811383s_agely
sail45447163s_a_il_
sails55738103s_a_ils
salify12311373s_alify
sally85129713s_a_lly
saltily10310543saltily
sandfly1435643sandfly
sanely93114613s_anely
sanity9316203s_anity
sappily1437163sappily
sassily1038723sassily
satiny93817983s_atiny
saucily1237913saucily
savvily1634323savvily
sawfly1535133s_awfly
scabbily1763943scabbily
scaly104718723sca__ly
scantily1337583scantily
scantly12419553scantly
scarify1537443scarify
sedile73517233s_edile
sexily1638853s_exily
shabby1635803sha_bby
shackle16409543shackle
shad86230913shad___
shadblow1742313shadblow
shade95125583shad__e
shaded114518873shad_ed
shader104218763shad_er
shaders115915553shaders
shades105924533shad_es
shadiest121711273shadiest
shadings13327433shadings
shadoof1446133shadoof
shadow1337253shad_ow
shadows1437193shadows
shads95124483shad__s
shaduf1337063shad_uf
shadufs1433673shadufs
shaggy14478043sha_ggy
shaird10288703sha_ird
shairn9269063sha_irn
shakier143411153shakier
shaking153317253shaking
shaky154616843sha__ky
shale85332833sha__le
shaley123714993sha_ley
shalier103116423shalier
shall85024053sha__ll
shalt85534483sha__lt
shamably18165793shamably
shamble14149263shamble
shaming133016743shaming
shammy16388503sha_mmy
shamoy14379913sha_moy
shandies122714103shandies
shandy134710033sha_ndy
shanny124110093sha_nny
shantey134210033shantey
shanty124715113sha_nty
shaping133116183shaping
sharia93116723shari_a
shariah132210533shariah
sharias102516003sharias
sharif122917113shari_f
sharifs13279903sharifs
sharing113723243sharing
sharny124711833sha_rny
sharpy145211033sha_rpy
shaslik1444503shaslik
shaul85418103sha_ul_
shauls94913113sha_uls
shavie124312413shavi_e
shavies134213203shavies
shaving143414333shaving
shawing143514883shawing
shawl116217573sha_wl_
shawls125411973sha_wls
shay107133343sha___y
sheerly13337703sheerly
sheila969843sh_eila
shelly124414463sh_elly
shiftily1744543shiftily
shill85325333sh__ill
shingly143210803shingly
shiny115122143sh__iny
shoaly124010763sh_oaly
shoddy1434533shod_dy
shoofly1634343shoofly
shortly13387563shortly
shrill94712303sh_rill
shrilly13318553shrilly
shyly144811573sh__yly
silkily14236963silkily
sillily10209783sillily
slackly1635263slackly
slangily1235383slangily
slantly10399323slantly
sleazily2044103sleazily
slily85820033s__lily
slimily1247713slimily
smarmily1543523smarmily
smartly12497433smartly
smokily1635373smokily
smudgily1543123smudgily
snail57020203sna_il_
snails64816653sna_ils
snappily1544323snappily
snarkily1534583snarkily
snarly93815003sna_rly
sneakily1544423sneakily
snidely1136803snidely
snowily1336883snowily
soggily1235953soggily
solidly1137353solidly
sootily101810513sootily
sordidly1344663sordidly
sorrily1039823sorrily
spadille1145183spadille
spading113114383spading
spadix1636103spadi_x
spail74921553spa_il_
spails84817823spa_ils
spangly1336473spangly
sparely123410663sparely
sparkily1735013sparkily
sparkly16348123sparkly
speedily1465173speedily
spicily1438653spicily
spikily1635873spikily
stabile9312063stabile
stably113314123sta_bly
staddle9288093staddle
stadia7312143stadi_a
stadias8411113stadias
stadium1038073stadium
stalely1039213stalely
stalkily1534823stalkily
starkly14277033starkly
stately10310223stately
steamily1335803steamily
stodgily1343903stodgily
stonily1049433stonily
studly10397693stud_ly
sturdily1245073sturdily
suably112814533sua_bly
suavely1376483suavely
suavity1336313suavity
sulkily14218113sulkily
sundrily1246053sundrily
sunnily1037833sunnily
surlily1039993surlily
swaddle12276743swaddle
swail86217163swa_il_
swails94913123swa_ils
swankily1833833swankily
sweatily1435473sweatily
tardily11269583tardily
tearily10311153tearily
tidily102811393_tidily
unhandily1643733unhandily
waddly14478723_waddly
warily122915093_warily
wavily15219483_wavily
waxily19218413_waxily
wearily1338783wearily
weedily1476123weedily
windily1437943windily
wordily1437853wordily
zanily18310183_zanily

Search took 9 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.1561145455.1
2DLD Change Limit1340272698.17016404.8
3Display Results2692690.0932892.5
 (SQL Overall)1786912698.41921224.7
 
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.