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

480 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
jerkies18341158(None) 
jerkier18407271jerkier
jerkiest19328111jerkiest
jerkins18358251jerkins
jerries143817511jerries
aeries64737782aer_ies
berries94423552berries
birkies133712432birkies
darkies124015752darkies
derbies103016052derbies
derries83124622derries
ferlies103216692ferlies
ferries103521082ferries
herries104025072herries
jackies202912622jackies
jellies143816532jellies
jemmies18318332jemmies
jennies143511622jennies
jerids142810942jer_ids
jerked18479592jerk_ed
jerker17369042jerk_er
jerkers18287082jerkers
jerkily2134622jerkily
jerkin17258112jerki_n
jerkiness20175642jerkiness
jerking19308922jerking
jerks166514892jerk__s
jerrids15277742jerrids
jetties143613122jetties
junkies183711692junkies
juries134120632jur_ies
kerries113317912kerries
mercies113817562mercies
perkier133813122perkier
perkiest143313242perkiest
perries93226602perries
porkies133416492porkies
selkies113513352selkies
series64540972ser_ies
serries73925352serries
tekkies1035942tekkies
terries73425632terries
aerates74627493aerates
aerie54634603aer_ie_
aeried74221863aer_ied
aerier64823153aer_ier
aeriest73924053aer_iest
aerifies111313393aerifies
aerobes9311493aerobes
alkies104518093_alkies
anergies9310453anergies
aperies9423203aper_ies
armies85123693_armies
barbies114519593barbies
barkier133814483barkier
barkiest144115153barkiest
beakier134012163beakier
beakiest143313463beakiest
beanies93821093beanies
beedies10314203beedies
bekiss1236373be_kiss
belies84631053be_lies
bellies94023723bellies
bennies93917313bennies
berakes134815773berakes
berates94126873berates
berimes115216643berimes
berks115423123berk__s
berlines102315453berlines
berlins93216013berlins
bermes106023003ber_mes
berried103714043berried
bevies114017303be_vies
bikies124515163_bikies
birdies104016213birdies
birkie124110133birkie_
bookies133819403bookies
bries74942153_br_ies
burdies104117563burdies
buries84633273bur_ies
burkes124421313burk_es
burkites1436673burkites
burnies94017823burnies
byrnies12378573byrnies
caries85147623car_ies
carnies94123963carnies
carries94328013carries
cerates95428253cerates
cercis104614493cerci_s
cercises12410933cercises
ceres75540013cer__es
cerias83321983cer_ias
cerise84822043cer_ise
cerises94722253cerises
cerites94823433cerites
certes84623083cer_tes
ceruses93716233ceruses
cervices1537133cervices
cervixes2054603cervixes
cherries131812983cherries
clergies1137903clergies
cookies133719273cookies
corbies113520123corbies
corkier133114303corkier
corkiest143114793corkiest
corries94026793corries
cries75438403_cr_ies
curies84934023cur_ies
curries93723163curries
darbies104216983darbies
darkie113714013darkie_
darkles124011933darkles
dearies83526273dearies
deckles143312803deckles
decries103319803decries
defies104624053de_fies
deifies113317453deifies
deities82621923deities
dekes105224453de_k_es
dellies83622213dellies
demies94825803de_mies
denies74729643de_nies
derails84216393derails
derates84028893derates
derides93420853derides
derives114017813derives
dermis94717163dermi_s
dermises112512023dermises
dernier83011943dernier
derris73615273derri_s
derrises93012783derrises
dexies145018343de_xies
dickies143416343dickies
dinkies123716033dinkies
dirties83119383dirties
dories75232363dor_ies
dorkier122810023dorkier
dorkiest133111253dorkiest
dries64733673_dr_ies
duckies143613813duckies
durries83817353durries
easies64126633_easies
eddies83313163_eddies
eerie55228533eer_ie_
eerier64320023eer_ier
eeriest73620673eer_iest
ekes86726603_e_k_es
emeries91620023emer_ies
energies9310783energies
enskies1138573enskies
envies9314053_envies
erases64425403_erases
ermines9416673_ermines
ernes55224813_er_nes
erodes74819883_erodes
eroses65327053_eroses
erses55826803_er_ses
ervils948773_ervils
espies83716803_espies
eurokies1246313eurokies
eyries93816813_eyries
faeries104118993faer_ies
farcies125317883farcies
fellies104119743fellies
feres86038183fer__es
ferias95020393fer_ias
ferities111416713ferities
ferlie92814053ferlie_
fermis114313503fermi_s
fernier103110823fernier
ferniest1132214153ferniest
ferried113411523ferried
ferrites112312833ferrites
ferules103112723ferules
firkins1437663firkins
folkies143612253folkies
forkier144311593forkier
forkiest153812303forkiest
forties104323863forties
fries85535603_fr_ies
furies95126373fur_ies
gawkies15429123gawkies
geckoes14325793geckoes
geekier12286393geekier
geekiest13257863geekiest
genies75324943ge_nies
gerbils1037303gerbils
germier10309543germier
germiest11249913germiest
gherkins1643993gherkins
girlies83013703girlies
gurries83515953gurries
hackies163418243hackies
hankies143617763hankies
hardies114923233hardies
harpies123818313harpies
harries103525493harries
hawkies173311243hawkies
hearties11315413hearties
heavies132713873heavies
heckles163711383heckles
heinies102514543heinies
henries102718283henries
herbier1239593herbier
herbiest1339993herbiest
herdics13249523herdics
heredes11313133heredes
heres86245903her__es
heresies11312693heresies
hermits12312143hermits
hernias10310773hernias
heroes94923823her_oes
heroics122912003heroics
heroines112916573heroines
heroins103518013heroins
heroizes202610983heroizes
herpes115517323her_pes
herried113514453herried
hertzes1938303hertzes
hickies163614743hickies
honkies143015143honkies
hookies144017443hookies
hunkies143214503hunkies
hurdies114015663hurdies
hurlies103315333hurlies
hurries103919653hurries
huskies143212083huskies
jaggies163311083jaggies
jakes165023643j_ak_es
jammies183611293jammies
japeries17311463japer_ies
jees115938543je___es
jefes155613673je__fes
jellied15419223jellied
jemmied19294483jemmied
jerboas1636163jerboas
jereed144012063jer_eed
jereeds15326383jereeds
jerid132316423jer_i_d
jerk154920133jerk___
jerky196712423jerk__y
jerreed1535203jerreed
jerreeds1653263jerreeds
jerrid14259143jerri_d
jersey1636333jer_sey
jerseys1733243jerseys
jesses135215953je_sses
jesuits1436323jesuits
jetes124922843je__tes
jettied15366973jettied
jettier14358693jettier
jettiest15359593jettiest
jezails2334163jezails
jiffies20327473jiffies
jimmies18328783jimmies
jokes165423333j_ok_es
jokier17618753j_okier
jokiest18379193j_okiest
jollies143516273jollies
jukes165319103j_uk_es
junkie17339603junkie_
junkier18339493junkier
junkiest192610173junkiest
juried144212443jur_ied
jutties143814003jutties
kebbies1537253kebbies
keckles12318763keckles
kellies113516853kellies
kelpies13289903kelpies
kermes124616123ker_mes
kermis124012393kermi_s
kermises14248313kermises
kernes104717523ker_nes
kernites1269113kernites
kerrias11289513kerrias
kewpies16246923kewpies
kyries133411373kyr_ies
larkier113711523larkier
larkiest123713313larkiest
leakier114010993leakier
leakiest123212793leakiest
lefties10312073lefties
levies93919863le_vies
lezzies1536203lezzies
lories64933043lor_ies
lorries74518343lorries
luckies133313683luckies
marries93825283marries
mealies92821933mealies
meanies93620743meanies
meinies92516073meinies
merces105720743mer_ces
merches144013763merches
merdes94518603mer_des
meres75143573mer__es
mergees104411233mergees
merges94122483mer_ges
merises93421423merises
merits8320873mer_its
merks114722403merk__s
merles85322763mer_les
merlins93015813merlins
merrier92612303merrier
merriest10311473merriest
mirkier13319053mirkier
mirkiest142910253mirkiest
murkier133110273murkier
murkiest143210263murkiest
murries94118673murries
muskies133614673muskies
neckties1445903neckties
neddies92710703neddies
nellies73418723nellies
nerdier83110353nerdier
nerdiest92511163nerdiest
nereides938503nereides
nereids838743nereids
nereis6315343nerei_s
nerves94216193ner_ves
nervier10298833nervier
nerviest11188833nerviest
nervines112310463nervines
newbies12147423newbies
newies91014073ne_wies
newsies101310383newsies
nookies113414963nookies
orgies72316093_orgies
overlies112417043overlies
paries84742513par_ies
parries93925843parries
parties93230863parties
peakier134411443peakier
peakiest143512993peakiest
peavies122213403peavies
peckier153910523peckier
peckiest162711393peckiest
peeries93623023peeries
pekes114623563pe_k_es
pekins121812233pe_kins
pekoes124410423pe_koes
pennies94218813pennies
peonies93620153peonies
perches143717953perches
perdie94718513perdie_
perdues103511333perdues
peres76246643per__es
perils84121853per_ils
peris75537073per_i_s
perked134617683perk_ed
perkily1637803perkily
perkiness15209163perkiness
perking143716463perking
perkish16258823perkish
perks115325803perk__s
perlites10316353perlites
permits11314003permits
perses85428063per_ses
perukes133210113perukes
peruses94018163peruses
peskier13319113peskier
peskiest142610163peskiest
pinkies133818263pinkies
pokies125921333_pokies
porgies103017003porgies
porkier133712343porkier
porkiest143513713porkiest
porkpies1636193porkpies
premies113823063premies
prexies163415003prexies
pries74339533_pr_ies
punkies134216803punkies
queries16315873quer_ies
readies83324713readies
redries83721713redries
reekier113111123reekier
reekiest122711313reekiest
reflies104418533reflies
refries104419733refries
reifies104218283reifies
relies65036423re_lies
replies94521043replies
reraise7316313reraise
reraises8415643reraises
rerigs74014793rer_igs
rerise64325633rer_ise
rerises73525883rerises
reties65436193re_ties
retries74129073retries
rookies113917103rookies
sarkier113413313sarkier
sarkiest123615063sarkiest
scries85226823scr_ies
selkie102811693selkie_
serails73318363serails
serais64326133serai_s
serapes95218103serapes
sereins73716113sereins
serenes73222903serenes
seres55448893ser__es
serges74225963ser_ges
serifs94017053ser_ifs
serines74229543serines
serins64029673ser_ins
serried82513963serried
serves94423653ser_ves
services1338573services
sherries111812893sherries
shrikes144412393shrikes
sickies133717503sickies
silkies113715693silkies
skerries12168673skerries
skies95026833__skies
sorties74126403sorties
strikes114719093strikes
sulkies114315763sulkies
talkies113415733talkies
tardies84225863tardies
tarries73324263tarries
techies12513603techies
teddies92711283teddies
tekkie934203tekkie_
tellies73820503tellies
tennies73017973tennies
terais64023513terai_s
terbias9310743terbias
terces83921413ter_ces
tergites9310543tergites
termites10313693termites
ternes65422903ter_nes
terrier73414963terrier
terriers84210823terriers
terrines82117553terrines
territs72714503territs
tories65435883tor_ies
tries55742813_tr_ies
trikes105419493_trikes
varies94330873var_ies
veeries102916893veeries
veggies1237553veggies
vegies104314273ve_gies
verbids13259203verbids
verbiles1338923verbiles
verdins112812333verdins
verges104320173ver_ges
verier94620963ver_ier
veriest103719133ver_iest
verifies141313483verifies
verites103822263verites
verities111418043verities
vermes115019143ver_mes
vermis114214963vermi_s
vernier102711273vernier
verniers11227843verniers
vernixes1836053vernixes
verses94223763ver_ses
versines112213823versines
verstes104014283verstes
vertices13612283vertices
verves124617883ver_ves
wearies103020223wearies
wedgies123910203wedgies
weeklies1534913weeklies
weenies102915093weenies
weepies122811743weepies
weirdies12255783weirdies
welkins1437173welkins
wellies103719073wellies
weskits1434743weskits
wherries14179023wherries
worries104117133worries
wries85827743_wr_ies
xeroses143612823xeroses
xeroxes13246443xeroxes
xeruses143010753xeruses
yearlies1137603yearlies
yerked14509373yerk_ed
yerking15368813yerking
yerks125416563yerk__s
zerks185113823zerk__s
zeroes154314343zer_oes

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.1561145455.1
2DLD Change Limit1340274807.53317792.0
3Display Results4804800.1702823.5
 (SQL Overall)1786914807.85922737.1
 
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.