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 “perkily” 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
perkily163781(None) 
jerkily2134621jerkily
peskily1635081peskily
aerily93017012aer_ily
eerily92913562eer_ily
leakily1436472leakily
merrily1238632merrily
mirkily16266402mirkily
murkily16287112murkily
nervily1336862nervily
pawkily1934202pawkily
peppily1335132peppily
perfidy1635272perfidy
peril75425952per_il_
perils84121852per_ils
perkier133813122perkier
perking143716462perking
perkish16258822perkish
perky145319482perk__y
pertly115312552per_tly
pettily1238172pettily
pockily1846232pockily
pokily15309062p_okily
pursily1238212pursily
sparkily1735022sparkily
verily122616052ver_ily
aerify122810113aer_ify
airily93014823air_ily
artily92814713_artily
balkily16266693balkily
beadily1378843beadily
beamily1477393beamily
beefily1535613beefily
bulkily16227123bulkily
burlily1237713burlily
certify1546243certify
cheekily2053473cheekily
clerkly1643573clerk_ly
cockily1838493cockily
cornily12410853cornily
creakily1735393creakily
curlily1238383curlily
darkly145411073dark_ly
derail74218813derail_
derails84216393derails
dewily1338343de_wily
dirtily1138583dirtily
drily95816523_dr_ily
duskily15236743duskily
easily9313023_easily
edgily1136063_edgily
ervil8310303_ervil_
ervils948773_ervils
feckly18335963feck_ly
ferity122813343fer_ity
ferly115517353fer__ly
fertile10311733fertile
fervidly1863323fervidly
fierily1339023fier_ily
flakily1736293flakily
flukily1735213flukily
freakily1835003freakily
funkily1736513funkily
furrily1337613furrily
gawkily1834093gawkily
gemmily1534603gemmily
gerbil938343gerbil_
gerbils1037303gerbils
gorily10612503gor_ily
hardily143310273hardily
headily1478623headily
heartily1436563heartily
heavily1665903heavily
heftily1635763heftily
hokily16409093_hokily
hornily1338283hornily
horsily1338843horsily
huskily17236333huskily
ickily1535753_ickily
jerkier18407273jerkier
jerkies183411583jerkies
jerkin17258113jerki_n
jerking19308923jerking
jerkingly2444273jerkingly
jerkins18358253jerkins
jerky196712423jerk__y
jokily20306533_jokily
kinkily1335223kinkily
lankily1437123lankily
leerily1037633leerily
luckily16297083luckily
meatily12311093meatily
meekly1535193meek_ly
merely111312593mer_ely
messily12298813messily
milkily16216553milkily
muckily18277743muckily
murkly15368303murk_ly
muskily16289043muskily
needily1166323needily
operably1557093operably
overkill1535533overkill
overwily1736663overwily
packly17228333pack_ly
parity114719873par_ity
parking143423043parking
parkway1934553parkway
partly116315473par_tly
peakier134411443peakier
peaking144317693peaking
peakish16268873peakish
peaky145718153peak__y
pearly116414843pe_arly
peartly1267453peartly
pebbly1545083pe_bbly
peckier153910523peckier
pecking164017783pecking
peckish18227293peckish
peckishly2342673peckishly
pecky165515093peck__y
peeking144414953peeking
pekin111514423pe_ki_n
pekins121812233pe_kins
penally121111773penally
pencil103712973pencil_
pencils113011773pencils
penile82219603pe_nile
pensil83013333pensil_
pensile92713543pensile
pensils92811593pensils
percale11314093percale
perdie94718513perdi_e
perdy115417333per__dy
pereia85217983perei_a
pereion9312053pereion
perfumy1763933perfumy
pergola1067623pergola
peri65636973per_i__
periled10316323per_iled
perilla9311233perilla
period9314983per_iod
peris75537073per_i_s
perish114619063per_ish
periti8319953per_iti
perjury19244253perjury
perk106232843perk___
perked134617693perk_ed
perkiest143313243perkiest
perks115325803perk__s
perlite9317323perlite
permian112612283permian
perming123416093perming
permit10321683permi_t
permits11314003permits
pernio8513143perni_o
peroxy1838253per_oxy
perries93226603perries
perry105222713per__ry
persalt9315413persalt
persist9315853persist
perspiry1543783perspiry
peskier13319113peskier
pesky145911563pesk__y
petrify1536573petrify
phonily1537103phonily
pily96132733p___ily
pinkly155012243pink_ly
pithily1567033pithily
pluckily1963413pluckily
podgily1435213podgily
porkier133712343porkier
porkies133416493porkies
porking143515813porking
porky145019333pork__y
portly114713403por_tly
prebill1138803prebill
prefile123413183prefile
prepill1147583prepill
preppily1444593preppily
prettily1337283prettily
pricily142710283pricily
pricy124814563p_r_icy
prill74117943p_r_ill
primly13439623p_rimly
privily15207623privily
privy13439833p_r_ivy
prosily12611633prosily
pudgily1434903pudgily
puerile9310093puer_ile
puffily1834843puffily
pulpily1436103pulpily
punily11311773p_unily
purely114013633pur_ely
purify14399153pur_ify
purity114114913pur_ity
purply13369053pur_ply
pushily15247983pushily
quakily2336693quakily
quirkily2442593quirkily
readily11711403readily
reedily1179613reedily
riskily1436413riskily
roily86121113__roily
seedily1178583seedily
serail64222673serail_
serails73318363serails
servile10310643servile
sexily1638853se_xily
shakily1736903shakily
silkily14236963silkily
smirkily1753333smirkily
smokily1635373smokily
snakily1436913snakily
snarkily1534583snarkily
sneakily1544423sneakily
sorrily1039833sorrily
sparkly16348133spark_ly
speedily1465183speedily
spikily1635873spikily
spookily1744173spookily
sportily1337733sportily
spunkily1733773spunkily
sulkily14218113sulkily
surlily10310003surlily
tackily1637503tackily
tardily11269583tardily
tartily103511573tartily
tearily10311153tearily
techily1537123techily
termly1138433ter_mly
terribly1344923terribly
terrify1336353terrify
tersely1038113tersely
testily102910803testily
verbify1834993verbify
verbile1249863verbile
verify153110163ver_ify
verity123714853ver_ity
versify1636333versify
wackily1936053wackily
warily122915093war_ily
weakly1636483weak_ly
wearily1338783wearily
weedily1476123weedily
weekly1635313week_ly
weevily1694643weevily
wergild1234043wergild
wirily123310783wir_ily
wordily1437853wordily
yerking15368813yerking
zestily19167563zestily

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.406440125.6
2DLD Change Limit1340272516.55020462.1
3Display Results2512510.0932698.9
 (SQL Overall)1786912517.04925349.8
 
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.