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

267 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
dandily1227963(None) 
dandify15245671dandify
handily143610871handily
bawdily1635802bawdily
candidly1545212candidly
cannily1239262cannily
daffily1735132daffily
daily95922332da__ily
daintily1245522daintily
dandier93714572dandier
dandies94121442dandies
dandle84218092dand_le
dandy104416702dand__y
dangly114212262dan_gly
dankly14419462dan_kly
daylily1434982daylily
dingily1238102dingily
dowdily1534952dowdily
fancily1538252fancily
gaudily1236522gaudily
hardily143310272hardily
lankily1437122lankily
mangily1339752mangily
manlily1238742manlily
sandfly1435642sandfly
tardily11269582tardily
windily1437942windily
zanily18310182zan_ily
acidly125211793_acidly
aedile73716653_aedile
aerily93017013_aerily
airily93014823_airily
anally9513503_anally
angrily1137723_angrily
anil46437433_an_il_
anile54634463_an_ile
anils56326723_an_ils
anticly12410053_anticly
anvil82712603_anvil_
anvils9219713_anvils
aridly105513703_aridly
artily92814713_artily
audibly13216043_audibly
audile73315303_audile
avidly13548783_avidly
badly114918763ba_d_ly
baggily1436043baggily
baldly12479833bald_ly
balkily16266693balkily
balmily14216463balmily
banally1249223banally
bandied114414303bandied
bandies104124863bandies
banding114921413banding
bandit93821133bandi_t
bandito103710043bandito
banditry1444123banditry
bandits103814793bandits
bandy114824183band__y
beadily1378843beadily
blandly1336043bland_ly
bodily12310993_bodily
bonnily1236873bonnily
cagily12411563ca_gily
campily1638273campily
candela1089743candela
candid104517853candi_d
candida114110253candida
candids113812693candids
candied113816023candied
candies104125613candies
candle94321483cand_le
candy115119823cand__y
cattily123210853cattily
chancily1845243chancily
crankily1755623crankily
dacoity1366183dacoity
daddies103414943daddies
daddle94214283da_ddle
daddy116212563da_d_dy
daedal849083daedal_
daftly1335443da_ftly
dairy97016303da__iry
daisy95915313da__isy
dakoity1543423dakoity
dally95324743da__lly
damnably1645113damnably
damnify1643453damnify
damply14337893da_mply
dancing113611563dancing
dander811222993dand_er
danders93921183danders
dandiest103415033dandiest
dandled103313543dandled
dandler94414273dandler
dandles94218533dandles
dandling112511733dandling
dandriff1694173dandriff
dandyish1644723dandyish
dandyishly2151683dandyishly
dandyism1543943dandyism
danging103716093danging
dangle84119303dan_gle
danio6319783dan_i_o
danios7314603dan_ios
danish101513793dan_ish
darkly145411073da_rkly
datedly1236023datedly
dawdle11399503dawd_le
dayfly1633813da_yfly
dazedly2134063dazedly
deadly113811473dead_ly
densely1146713densely
densify1435293densify
density1137583density
dentil74017883dentil_
dentils84115583dentils
dewily1338343d_ewily
diddly12389573d_iddly
dindle84417223dind_le
dinkly144311083din_kly
dirtily1138583dirtily
dizzily1934843dizzily
doily95321033d__oily
doomily1336133doomily
dopily123510463d_opily
dottily1147283dottily
dozily19329103d_ozily
draftily1534413draftily
drily95816523d__rily
dumpily1566233dumpily
duskily15236743duskily
dustily113211523dustily
easily9313023ea_sily
family143311703fa_mily
fancify1834983fancify
fattily13379463fattily
fondly13299043fond_ly
funkily1736513funkily
funnily1336373funnily
gadfly1434663ga_dfly
gaily95020973ga__ily
gamily123712183ga_mily
gangly113911583gan_gly
gassily1137813gassily
gauzily2034393gauzily
gawkily1834093gawkily
giddily1335073giddily
grandly1238743grand_ly
hammily1736063hammily
handbill14115163handbill
handier113817443handier
handing123518893handing
handle104219293hand_le
handy125520873hand__y
happily1745763happily
hardly135112833hard_ly
hastily133010663hastily
hazily2179063ha_zily
headily1478623headily
jangly174310603jan_gly
jauntily1834173jauntily
jazzily2533373jazzily
kindly14358843kind_ly
kinkily1335223kinkily
lacily11612763la_cily
landfill1253883landfill
landing92819323landing
lanely93914483lan_ely
lankly13439623lan_kly
lazily1859713la_zily
madly115218133ma_d_ly
mandala10310213mandala
mandible1337543mandible
mandola1039023mandola
mandril1049353mandril_
mandrill1146613mandrill
mandrils1138493mandrils
manila84518303man_ila
manly105022953man__ly
mazily20610393ma_zily
moodily1358203moodily
muddily1435963muddily
nandin7313033nandi_n
nandina838913nandina
nandins8312003nandins
nastily103011033nastily
nattily103610323nattily
needily1166323needily
noily86120993__noily
nonoily1049543nonoily
pandied113913443pandied
pandies104224503pandies
pandit93820753pandi_t
pandits103914213pandits
pandy115021173pand__y
panoply1434713panoply
pantile93918483pantile
pawkily1934203pawkily
punily11311773pun_ily
rabidly1336253rabidly
racily11715173ra_cily
rainily10310433rainily
rancidly1444433rancidly
randier83618473randier
randies84225663randies
randomly1443793randomly
randy95022083rand__y
rankly133910453ran_kly
rapidly1336523rapidly
readily11711403readily
reedily1179613reedily
rowdily1436083rowdily
ruddily1236303ruddily
sadly94519123sa_d_ly
saltily10310543saltily
sandal73317283sandal_
sandals82715203sandals
sandier84017843sandier
sanding93520603sanding
sandpile1146773sandpile
sandy94221133sand__y
sanely93114613san_ely
sanity9316203san_ity
sappily1437163sappily
sassily1038723sassily
saucily1237913saucily
savvily1634323savvily
scantily1337583scantily
seedily1178583seedily
shadily1437723shadily
slangily1235383slangily
snakily1436913snakily
sundrily1246063sundrily
sunnily1037833sunnily
swankily1833833swankily
tackily1637503tackily
tangibly1444673tangibly
tangly104413913tan_gly
tantivy1335563tantivy
tartily103511573tartily
tastily103311643tastily
tattily10409993tattily
tawdrily1542733tawdrily
tawnily1335443tawnily
tidily102811393_tidily
tinily94014433tin_ily
tinnily1047363tinnily
trendily1256443trendily
unduly1037823_unduly
unhandily1643733unhandily
validly1435573validly
vandal103713833vandal_
vandals113211663vandals
vanity12311933van_ity
vapidly1635063vapidly
vendibly17174473vendibly
wackily1936053wackily
waddly14478723wa_ddly
wandle105316663wand_le
wanly115118023wan__ly
warily122915093wa_rily
waspily1535513waspily
wavily15219483wa_vily
waxily19218413wa_xily
weedily1476123weedily
wordily1437853wordily

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.420425454.8
2DLD Change Limit1340272676.62620227.4
3Display Results2672670.0932871.0
 (SQL Overall)1786912677.13925030.3
 
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.