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

251 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
sillily1020978(None) 
silkily14236961silkily
chillily1644112chillily
filmily1535732filmily
jollily1745772jollily
milkily16216552milkily
oilily93111722oi_lily
saltily10310542saltily
sicklily1744292sicklily
sillier74017592sillier
sillies73425082sillies
silly84527622si_l_ly
slily85820032s__lily
slimily1247712slimily
sulkily14218112sulkily
surlily10310002surlily
wilily123310762wi_lily
airily93014823ai_rily
balkily16266693balkily
balmily14216463balmily
billie85019173billi_e
billies93923503billies
billing103823853billing
billion92212173billion
billowy15366903billowy
billy105525363bi_l_ly
bulkily16227123bulkily
burlily1237713burlily
civilly1535483civilly
curlily1238383curlily
daylily1434983daylily
dicliny1337673dicliny
dillies84122163dillies
dilly94923783di_l_ly
dingily1238103dingily
dirtily1138583dirtily
dizzily1934843dizzily
fallibly1644393fallibly
fierily1339023fierily
fillies103420253fillies
filling113520803filling
fillip11268953filli_p
fillips12298133fillips
filly114424903fi_l_ly
filthily1743663filthily
fishily1637643fishily
gallfly1433523gallfly
giddily1335073giddily
gillie74816943gilli_e
gillied95512313gillied
gillies84120963gillies
gilling93520383gilling
gilly94321633gi_l_ly
gluily10308293_gluily
godlily1235343godlily
guiltily1243423guiltily
gullibly1443473gullibly
hillbilly1751823hillbilly
hillier103413963hillier
hilling113821773hilling
hilly114422163hi_l_ly
holily123612953_holily
icily101211693_i_cily
ickily1535753_ickily
illite63414923_illite
illy76925333_i_l_ly
jellify2054543jellify
jillion14188933jillion
jollify2044263jollify
jollity1746143jollity
joltily1746323joltily
killick1295313killick
killie104114893killi_e
killies113318113killies
killing123118723killing
killingly1744833killingly
killjoy2142343killjoy
kinkily1335223kinkily
lily76730183___lily
livelily1444103livelily
lowlily1335353lowlily
manlily1238743manlily
mildly12318243mi_ldly
milliary1346853milliary
millier93716703millier
millilux1742933millilux
millime112511403millime
milline92519113milline
milling103223683milling
million91813143million
mirkily16266403mirkily
mistily122612343mistily
mollify1555503mollify
niftily1335753niftily
nilling83619563nilling
nippily1444713nippily
nullify1334713nullify
nullity1037363nullity
pallidly1444053pallidly
pilling103722563pilling
pillion92011703pillion
pillory12247453pillory
pillowy15316423pillowy
pithily1567033pithily
pulpily1436103pulpily
rilling84023623rilling
riskily1436413riskily
ritzily1945143ritzily
sailorly1143543sailorly
salably121610743salably
salify12311373s_alify
sallied83316953sallied
sallier73320423sallier
sallies73227813sallies
sallowly14344833sallowly
sallowy13369343sallowy
sally85129713s_al_ly
salsify1334703salsify
sappily1437163sappily
sassily1038723sassily
saucily1237913saucily
savvily1634323savvily
scarily12311703scarily
seedily1178583seedily
selling83225833selling
sexily1638853s_exily
shadily1437723shadily
shakily1736903shakily
shelly124414473shel_ly
shiftily1744553shiftily
shillala11143793shillala
shilling123315383shilling
shily115222013s__hily
shinily13268933shinily
showily1636223showily
shrilly13318563shrilly
sialic8313633siali_c
sialid7314943siali_d
sialids839723sialids
sibling10814423sibling
sickly153110483si_ckly
sidling9915423sidling
sidlingly1445083sidlingly
sightly14408273sightly
sigil63515503si_gil_
sigils73912363si_gils
signify1444853signify
silently1147483silently
silica8311243si_lica
silicify1644273silicify
silicle937753silicle
silkie103313403silki_e
silkier114411643silkier
silkies113715693silkies
silking123715593silking
silklike1135523silklike
silky125315823si_l_ky
sill45545153si_l_l_
siller64026063sill_er
sillers73822103sillers
sillibub1292673sillibub
silliest84017103silliest
sills55135993si_l_ls
siloing83215503siloing
siltier73413863siltier
silting83320483silting
silty84721633si_l_ty
silverly14284313silverly
silvery13328093silvery
silvics1235563silvics
simile83115633si_mile
simlin8311733simli_n
simlins9311843simlins
simplify1843553simplify
simply133010523si_mply
singly104015853si_ngly
sixthly2042873sixthly
sizably2136613sizably
skilling132911333skilling
skimpily1963053skimpily
slickly1635853slickly
slimly11408903s_limly
slimy105417423s__limy
slinkily1534853slinkily
slippily1544193slippily
slowly1237153s_lowly
sluicy1166483s_luicy
slyly11489533s__lyly
smelly114110363smel_ly
smirkily1753333smirkily
smokily1635373smokily
snakily1436913snakily
sniffily17154033sniffily
snippily1543573snippily
snowily1336883snowily
soapily1237963soapily
soggily1235953soggily
solely93714213s_olely
solidly1137353solidly
solubly1255283solubly
sootily101810523sootily
sorrily1039833sorrily
spicily1438653spicily
spiffily19153483spiffily
spikily1635873spikily
spilling113113943spilling
spillway1642763spillway
stagily1139053stagily
stalely1039213stalely
stalkily1534823stalkily
stellify1443883stellify
stickily1736083stickily
stillier868823stillier
stilling93415323stilling
stilly93714093stil_ly
stingily1236793stingily
stolidly1243833stolidly
stonily1049433stonily
sullenly1145693sullenly
sullied83714483sullied
sullies74122233sullies
sully84622903s_ul_ly
sultrily1146493sultrily
sunnily1037833sunnily
swilling123511933swilling
swimmily1842713swimmily
tidily102811393ti_dily
tilling83522783tilling
tillite7313563tillite
tinily94014433ti_nily
tinnily1047363tinnily
tipsily1236043tipsily
uglily1036193_uglily
vilely1239443vi_lely
vilify1536773vi_lify
villainy1444873villainy
villi86517853villi__
wildly13328123wi_ldly
willie94116453willi_e
willied114611563willied
willies103920153willies
willing113821613willing
willingly1645393willingly
willowy16276353willowy
willy115321913wi_l_ly
windily1437943windily
wirily123310783wi_rily
wispily1535653wispily
wittily1336173wittily
woollily1443123woollily
zillion16188773zillion

Search took 7 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 Limit1340272516.29621287.6
3Display Results2512510.0932698.9
 (SQL Overall)1786912516.54527301.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.