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

506 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
piglets10331179(None) 
aiglets84012911aiglets
giglets93211551giglets
piglet93420921piglet_
piolets93513191piolets
wiglets113411421wiglets
aglets73915682_aglets
aiglet74224192aiglet_
aigrets82810532aigrets
billets94516152billets
diglots9299502diglots
eaglets84111662eaglets
filets94718952fi_lets
fillets103414752fillets
giblets103210422giblets
giglet83920272giglet_
giglots9367862giglots
gimlets10338432gimlets
goglets9379782goglets
guglets9369692guglets
inlets63915572_inlets
islets64513082_islets
kinglets13318582kinglets
millets94216842millets
palets85122312p_alets
pallets93919302pallets
pegless1038052pegless
pellets94014782pellets
pickets154314182pickets
pigments1337342pigments
pignuts1035612pignuts
pigouts1037592pigouts
pigpens1235502pigpens
piles74742612pi_le_s
pileus84514942pi_leus
pilots84018872pi_lots
piolet83225642piolet_
pipets105714772pi_pets
piquets1836602piquets
pullets94015162pullets
reglets83512982reglets
riblets93412552riblets
rillets74216152rillets
ringlets92910232ringlets
signets83311502signets
singlets93611472singlets
sniglets9276812sniglets
violets102210002violets
wigless11359672wigless
wiglet105519152wiglet_
willets104414322willets
winglets12299592winglets
aglet65534143_aglet_
aidless83612073aidless
aigret73720023aigret_
aimless93610813aimless
airless73712043airless
aisles64721143aisle_s
amulets939923amulets
anglers84014823anglers
angles74426703angle_s
anklets114310413anklets
applets115710063applets
argles75218483argle_s
armlets94610063armlets
auklets11298573auklets
baguets1037483baguets
ballets93719513ballets
begets96215523beg_ets
beignets11155373beignets
bibles104617643bible_s
bibless11439173bibless
bidets95215533bi_dets
biggest1138143biggest
biggety1434433biggety
bights124417963big_hts
bigness1038193bigness
bigots95015133big_ots
biles75542143bi_le_s
bilges94915633bilge_s
billers94720833billers
billet86029723billet_
birlers93813003birlers
birles84920643birle_s
blets75324943__blets
bogles95020833bogle_s
buglers105115323buglers
bugles94822443bugle_s
bullets93516393bullets
cablets114216343cablets
callets93821703callets
camlets114314623camlets
caplets114914523caplets
chalets122813473chalets
cigarets1145473cigarets
circlets1235663circlets
civets115212543ci_vets
collets93517903collets
culets85518513_culets
cullets94015613cullets
cutlets94113653cutlets
cygnets1333813cygnets
dialects11126003dialects
dialers83614303dialers
diets66026643di__ets
digest84019623dig_est
digests93610613digests
diggers104413393diggers
dights114016963dig_hts
digits84114533dig_its
diglot83014333diglot_
digress938323digress
dingles93818323dingle_s
dipnets10109033dipnets
doglegs1034783doglegs
driblets11266093driblets
eagles73819163eagle_s
eaglet73722583eaglet_
eggless935663eggless
egrets72712243_egrets
eights103618983eig_hts
engluts834533engluts
epaulets1043733epaulets
epithets1345763epithets
eyelets1057523eyelets
fidgets12388763fidgets
fights133816553fig_hts
figments1446943figments
filers94623723fi_lers
files85441273fi_le_s
filet85540163fi_let_
fillers104320213fillers
filles94224523fille_s
fillet95027083fillet_
finless102810783finless
fogless1138193fogless
froglets1235263froglets
fugles104715783fugle_s
gallets83517403gallets
gelts65924613__gelts
gets55442483__g_ets
gibbets12417723gibbets
giblet93418893giblet_
gigglers11297403gigglers
giggles103312933giggle_s
giglot84013133giglot_
gigots83911953gig_ots
gigues8129003gigue_s
gillers84216903gillers
gillnets934733gillnets
gilts64924263gi_l_ts
gimlet93716663gimlet_
gleds75417893__gleds
glees65027593__glees
gleets75315053__gleets
glens66519853__glens
gleys96514853__gleys
gluts66120133__gluts
goblets103210183goblets
goglet84618583goglet_
guglet84018223guglet_
gullets84013713gullets
gurglets10355543gurglets
hamlets123211403hamlets
haslets102510863haslets
higglers13297233higglers
higgles123911803higgle_s
highest1439563highest
hights133716893hig_hts
hillers103718733hillers
hilts86924413hi_l_ts
hipless12399923hipless
hitless103211193hitless
hoggets12498323hoggets
howlets13329223howlets
idlers74012813_idlers
idles66720123_idle_s
idlest74014863_idlest
igloos738033_igloos
iglus6609933_igl_us
ileus54616893_i_leus
illest63615723_illest
ingles74420873ingle_s
inlet53732403_inlet_
insets64016133_insets
isles54220563_isle_s
islet54527553_islet_
jagless1537103jagless
jiggers164010183jiggers
jiggles164111433jiggle_s
jilts124717413ji_l_ts
jinglers16408763jinglers
jingles153816383jingle_s
keglers12277773keglers
killers114215583killers
kilts95122183ki_l_ts
kingless13288693kingless
kinglet123114043kinglet_
kinless113310273kinless
kismets13306883kismets
legless838013legless
lets47147943___lets
lidless8309273lidless
ligates82318383ligates
ligers75022043lig_ers
lights104519913lig_hts
ligules82210923ligule_s
lilts55822803li_l_ts
limpets11329783limpets
linnets739833linnets
lipless9259553lipless
lisles63416283lisle_s
loggets9378913loggets
maglevs1334693maglevs
magnets10311143magnets
mallets93318493mallets
midgets113910253midgets
midlegs1156323midlegs
miggles113512033miggle_s
mights123516253mig_hts
milers84625163mi_lers
miles74645073mi_le_s
millers93621343millers
milles84526563mille_s
millet84030743millet_
milts75430713mi_l_ts
minglers113011293minglers
mingles103719003mingle_s
minuets9259853minuets
missets94516573missets
mullets93614783mullets
neglects1144383neglects
nidgets9358143nidgets
niggers93111323niggers
nigglers10307253nigglers
niggles93512203niggle_s
nighest11310693nighest
nights104117723nig_hts
nuggets936383nuggets
nutlets74111253nutlets
oglers74313183_oglers
ogles65223183_ogle_s
oilers64721193oi_lers
omelets938333omelets
outlets73616363outlets
owlets93110393_owlets
packets155114773packets
padles95221123padle_s
pagers94423253pag_ers
pages85235073pag_e_s
painless10108343painless
paisleys1333343paisleys
pales75753803p_ale_s
palest83926223p_alest
palet74650803p_alet_
pallet84232653pallet_
pargets105215193pargets
parles86334403parle_s
parleys125212373parleys
partlets102811513partlets
pedlers103013273pedlers
peelers93615593peelers
peles75738083p_ele_s
pellet83326553pellet_
pelmets11309693pelmets
pelts76128813p_el_ts
pets66248333p___ets
pickers153718093pickers
picket144924313picket_
pickles153215443pickle_s
picots104616443pi_cots
picquets2143733picquets
piddlers12359593piddlers
piddles114314273piddle_s
piecers114112253piecers
pieces104217273piece_s
piers75926333pi__ers
pies66949603pi__e_s
pieta75421753pi__eta
pietas84516503pi__etas
piety105817303pi__ety
piffles15368763piffle_s
pigboats1344523pigboats
pigeon949413pig_eon
pigeons1039183pigeons
pigged114214153pigge_d
piggery14266193piggery
piggies113813483piggies
piggiest12259663piggiest
piggins113010473piggins
piglike14157313piglike
pigment12510733pigment
pigmies122610993pigmies
pignus937953pig_nus
pignut9311573pignut_
pigout9314613pigout_
pigpen1136583pigpe_n
pigs76634223pig___s
pigsneys1442003pigsneys
pigsty1235933pig_sty
pigweed1465093pigweed
pigweeds1553143pigweeds
pikers124717393pi_kers
pikes115031033pi_ke_s
pilafs113511023pi_lafs
pilaus84114133pi_laus
pilaws11399433pi_laws
pile65649693pi_le__
pilea75123953pi_le_a
pileate93815923pi_leate
piled85232993pi_le_d
pilei74021783pi_le_i
pileless1088623pileless
pileous9510523pi_leous
pileum10399513pi_leum
pileup10437923pi_leup
pileups11365433pi_leups
pilfers1238963pilfers
pilis75825203pi_l_is
pillars9313493pillars
pilled94222753pille_d
pillows122610123pillows
pills74130973pi_l_ls
pilot77435063pi_lot_
pilous84717753pi_lous
pilules9510623pilule_s
pilus75921063pi_l_us
pimples133012423pimple_s
pincers113916503pincers
pinders103720473pinders
pines76048863pi_ne_s
pineta85815563pi_neta
pingers104020743pingers
pingoes105116523pingoe_s
piniest93121133piniest
pinites9319533pinites
pinkens13419643pinkens
pinkers134118603pinkers
pinkest132812623pinkest
pinkeys16378213pinkeys
pinners93518603pinners
pinoles93418703pinole_s
pinots85920273pi_nots
pintles94118723pintle_s
pints75936223pi__nts
pipeless12107663pipeless
pipers104318663pi_pers
pipes96030143pi_pe_s
pipet95533323pi_pet_
pipiest113114503pipiest
pipits104713063pi_pits
piques1739093pique_s
piquet17412353piquet_
pirates93020333pirates
pishers123815753pishers
pishes114722103pishe_s
pissers95014753pissers
pisses84525083pisse_s
pistes85325633piste_s
pithless13117023pithless
pitiers93812653pitiers
pities83828083pitie_s
pitiless10127333pitiless
pits66348743pi___ts
pivots115111903pi_vots
pixels15478533pi_xels
pixes144323173pi_xe_s
pixies154915513pixie_s
pizzles17329273pizzle_s
placets113911223placets
planets93914083planets
plats75531373p__lats
playlets1334903playlets
pleas75627033p__leas
pleats85218593p__leats
plebs95814583p__lebs
plews105415353p__lews
plights13299313plig_hts
plots75025673p__lots
plugless1133863plugless
pockets154612253pockets
poets76024443p__oets
pogeys124110353pog_eys
pogies94123543pogie_s
poleis86018353p_oleis
polers84225643p_olers
poles75351003p_ole_s
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
poolers94217423poolers
poppets10338853poppets
possets94212773possets
poults84613483poul_ts
prelects1299723prelects
presets94216423presets
prickets16329083prickets
privets122910053privets
projets1639163projets
prolegs10379993prolegs
proles84627203prole_s
pugrees10218523pugrees
pulers83820283p_ulers
pules74538813p_ule_s
pullers93618483pullers
pullet84026333pullet_
pulleys12399143pulleys
pungles104013713pungle_s
punnets9409263punnets
puppets10317013puppets
pusleys12286233pusleys
quillets17256823quillets
reflets103513153reflets
reglet73724233reglet_
regrets83212923regrets
relets64025673_relets
ribless93410343ribless
riblet84222443riblet_
rickets134915093rickets
ridleys11145783ridleys
riflers103512193riflers
rifles94217703rifle_s
riggers93613843riggers
rights104019333rig_hts
riles55343643ri_le_s
rilles64725503rille_s
rillet64828853rillet_
rimless9369363rimless
ringlet82818173ringlet_
ripplets12316733ripplets
rivets94417113ri_vets
rivulets1174753rivulets
runlets73310773runlets
sallets73719653sallets
samlets93813553samlets
sidlers83414233sidlers
sidles74721153sidle_s
sighers113712183sighers
sighless1276553sighless
sights103818013sig_hts
siglos7311473sigl_os
signees83510803signees
signers84714443signers
signet73621153signet_
silents73514493si_lents
sillers73822103sillers
silts55330823si_l_ts
singles83520433single_s
singlet84120113singlet_
sinless73014213sinless
sippets113310183sippets
skillets12226823skillets
sniglet83612413sniglet_
spielers10319653spielers
spigots1037793spig_ots
spikelets1553393spikelets
spiles84227913spi_le_s
spillers103311703spillers
spinets94714813spi_nets
spinless10238703spinless
springlets1344023springlets
stylets10369213stylets
sublets92616703sublets
tablets94714383tablets
tickets134113683tickets
tieless72512563tieless
tigers75616513tig_ers
tights104015853tig_hts
tiglons837343tiglons
tigress836093tigress
tilers63523503ti_lers
tiles55542103ti_le_s
tillers73418743tillers
tilts55325613ti_l_ts
tinglers93710593tinglers
tingles83818323tingle_s
tipless92610063tipless
tippets11339373tippets
titles63719923title_s
toilets74112913toilets
tonlets73212503tonlets
triolets83410143triolets
triplets103510263triplets
tugless837383tugless
twigless1293663twigless
valets93715623_valets
varlets10411573varlets
veinlets11144833veinlets
vilest9416843vi_lest
violet92620923violet_
wallets103914833wallets
wickets164010943wickets
widgets12318453widgets
wigglers13257213wigglers
wiggles123312463wiggle_s
wights133315783wig_hts
wiles85437873wi_le_s
willers103517913willers
willet95124833willet_
wilts85023503wi_l_ts
wingless122910023wingless
winglet113115983winglet_
winless103212283winless
witless103310983witless
zibets1737743zi_bets
zipless18276303zipless

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 Limit1340275067.06318975.9
3Display Results5065060.1862720.4
 (SQL Overall)1786915067.65523343.0
 
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.