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

174 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
jerkily213462(None) 
perkily1637811perkily
aerily93017012aer_ily
eerily92913562eer_ily
jerkier18407272jerkier
jerkies183411582jerkies
jerkin17258112jerki_n
jerking19308922jerking
jerkingly2444272jerkingly
jerkins18358252jerkins
jerky196712422jerk__y
jokily20306532j_okily
leakily1436472leakily
merrily1238632merrily
mirkily16266402mirkily
murkily16287112murkily
nervily1336862nervily
peskily1635082peskily
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
jazzily2533373jazzily
jellify2054543jellify
jelly154218253je__lly
jerid132316423jer_i_d
jerids142810943jer_ids
jerk154920133jerk___
jerked18479593jerk_ed
jerker17369043jerk_er
jerkers18287083jerkers
jerkiest19328113jerkiest
jerks166514893jerk__s
jerrid14259143jerri_d
jerrids15277743jerrids
jerries143817513jerries
jerry155016183jer__ry
jersey1636333jer_sey
jezail2234643jezail_
jezails2334163jezails
jollily1745773jollily
joltily1746323joltily
juicily1935493juicily
jumpily2174983jumpily
jurally1736963jurally
kinkily1335223kinkily
lankily1437123lankily
leerily1037633leerily
luckily16297083luckily
meatily12311093meatily
meekly1535193meek_ly
merely111312593mer_ely
messily12298813messily
milkily16216553milkily
muckily18277743muckily
murkly15368303murk_ly
muskily16289043muskily
needily1166323needily
overkill1535533overkill
overwily1736663overwily
pawkily1934203pawkily
peppily1335133peppily
perfidy1635273perfidy
peril75425953per_il_
perils84121853per_ils
perkier133813123perkier
perking143716463perking
perkish16258823perkish
perky145319483perk__y
pertly115312553per_tly
pettily1238173pettily
pockily1846233pockily
pokily15309063_pokily
pursily1238213pursily
quakily2336693quakily
quirkily2442593quirkily
readily11711403readily
reedily1179613reedily
riskily1436413riskily
roily86121113__roily
seedily1178583seedily
serail64222673serail_
serails73318363serails
servile10310643servile
sexily1638853se_xily
shakily1736903shakily
silkily14236963silkily
smirkily1753333smirkily
smokily1635373smokily
snakily1436913snakily
snarkily1534583snarkily
sneakily1544423sneakily
sorrily1039833sorrily
sparkily1735023sparkily
spikily1635873spikily
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 Limit1340271746.95319276.1
3Display Results1741740.0602900.0
 (SQL Overall)1786911747.41924085.6
 
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.