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

282 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
pinweed134693(None) 
pigweed1465091pigweed
pinweeds1454141pinweeds
bindweed1543792bindweed
indeed83913562_indeed
linseed838202linseed
pigweeds1553142pigweeds
pinched153812452pinched
pined85935322pin__ed
pinged104321382pin_ged
pinhead13347072pinhead
pinked134819882pin_ked
pinkened1535752pinkened
pinned94818382pin_ned
pinwheel1642522pinwheel
pondweed1543102pondweed
sinewed1137052sinewed
aniseed839403aniseed
anteed75616113_anteed
bindweeds1642863bindweeds
binged105920823bin_ged
binned94414543bin_ned
burweed1347823burweed
cinched153910863cinched
cindered1239793cindered
congeed113212313congeed
cudweed1444213cudweed
daneweed1344053daneweed
dindled104412723dindled
dined76431993din__ed
dinged95221783din_ged
dinked124818353din_ked
dinned84317613din_ned
dinted84419843din_ted
dyeweed1543203dyeweed
fined94930503fin__ed
fingered13128333fingered
finked144214623fin_ked
finned104114603fin_ned
fireweed1545353fireweed
gingered11127743gingered
ginned83813983gin_ned
gumweed1433943gumweed
hindered1339453hindered
hinged114618913hin_ged
hinnied11348103hinnied
hinted104318323hin_ted
hogweed1534443hogweed
inbred93010393_inbred
inbreed10267643_inbreed
inched124514483_inched
indexed16347363_indexed
indued83411653_indued
inhered11313163_inhered
inked104218523_in_ked
inned64118423_in_ned
intend72310373_intend
inured73114813_inured
inward10310333_inward
inweaved1534193_inweaved
inwind10268403_inwind
ironweed1244053ironweed
jingled164111063jingled
jinked184013143jin_ked
jinnee13411573jinnee_
jinxed21346083jin_xed
jointweed2041583jointweed
kindled133410543kindled
kindred13316953kindred
kinged124215283kin_ged
kinked104014753kin_ked
kneed104612053_kn_eed
lined64934643lin__ed
lingered10129643lingered
linked114518213lin_ked
linseeds944733linseeds
linted74021823lin_ted
mayweed1634163mayweed
midweek1743273midweek
milkweed1843353milkweed
minced114114913min_ced
minded103817833min_ded
mined85333353min__ed
mingled113612733mingled
minored10310103minored
minted94220583min_ted
minuend1035383minuend
minuted10329503minuted
misdeed113211053misdeed
misfeed13389683misfeed
need54934153__n_eed
oilseed835783oilseed
oinked114213283oin_ked
opined95113853opin__ed
pained95622853pain__ed
painted104214633pain_ted
pandered121812573pandered
pandied113913443pandied
paned85437183pan__ed
paneled10612573paneled
panged104722333pan_ged
panned94123433pan_ned
panted95024823pan_ted
paveed12438893p_aveed
pawed115725613p_aw_ed
pawned124513283p_awned
pawnee113115403pawnee_
pawnees12298173pawnees
peed76239183p___eed
peewee11311963peewee_
peewees1236803peewees
peined94918843pein__ed
pended103819013pen_ded
penned94217613pen_ned
pensee8417313pensee_
pensees9311203pensees
pewee10319973p_ewee_
pewees11311393p_ewees
piaffed1693753piaffed
picked154421313pi_cked
pickeer153710113pickeer
picketed17167383picketed
pickled164011883pickled
picoted1239213picoted
piddled123311253piddled
pieced113912103pi_eced
pied75035363pi___ed
pierced12347593pierced
piffled16366403piffled
pigged114214153pi_gged
piked125623313pi__ked
piled85232993pi__led
pilfered1435853pilfered
pilled94222753pi_lled
piloted10310323piloted
pimped134913483pi_mped
pimpled14289183pimpled
pincer104019173pin_cer
pincers113916503pincers
pincher143812713pincher
pinches144117933pinches
pinder94523453pin_der
pinders103720473pinders
pine67755713pin__e_
pineal84817683pin_eal
pinene82915643pin_ene
pinenes93416673pinenes
pinery115214293pin_ery
pines76048863pin__es
pineta85815563pin_eta
pinewood1445403pinewood
piney105727503pin__ey
pinfold1336233pinfold
pinger94324093pin_ger
pingers104020743pingers
pingoes105116523pingoes
pinguid1146233pinguid
pinheaded1644223pinheaded
pinheads14336243pinheads
pinier84024693pin_ier
piniest93121133piniest
pinioned1137513pinioned
pinite8321243pinite_
pinites9319533pinites
pinken124513283pin_ken
pinkens13419643pinkens
pinker125322443pin_ker
pinkers134118603pinkers
pinkest132812623pinkest
pinkey154314673pin_key
pinkeye16326493pinkeye
pinkeyes17335973pinkeyes
pinkeys16378213pinkeys
pinkie124414273pinkie_
pinkies133818263pinkies
pinkoes135512313pinkoes
pinnae84414643pinnae_
pinnated11338553pinnated
pinner84521503pin_ner
pinners93518603pinners
pinnies93318443pinnies
pinniped1343853pinniped
pinole83218783pinole_
pinoles93418703pinoles
pinones94717073pinones
pintle83818263pintle_
pintles94118723pintles
pintoes95117713pintoes
pinwale1257843pinwale
pinwales1367963pinwales
pinwheeled1951273pinwheeled
pinwheels1742313pinwheels
pinwork16107243pinwork
pinworm1467173pinworm
pioneer936893pioneer
pioneered1253733pioneered
piped105123163pi__ped
pipped104516543pi_pped
piqued1836213pi_qued
pirated102515613pirated
pished124817063pi_shed
pissed94816933pi_ssed
pitched153512923pitched
pithead13419593pithead
pithed124615613pi_thed
pitied94017253pi_tied
pitted94319593pi_tted
pivoted1336513pivoted
plinked143910893plin_ked
plowed124213203plow_ed
poinded11358973poin_ded
pointed103813983poin_ted
pokeweed1842943pokeweed
ponced114314813pon_ced
ponded105218773pon_ded
pondered126411293pondered
pondweeds1642183pondweeds
ponged105619353pon_ged
pongee94920193pongee_
pongees104212543pongees
ponied94920703pon_ied
powered132911643p_owered
prawned1346743prawned
preed85128113p__reed
prinked143412163prin_ked
printed104016373prin_ted
proceed12310543proceed
prowled13309903prowled
punched153512173punched
pungled114210083pungled
punned93416193pun_ned
punted94618713pun_ted
pureed95017803p_ureed
ragweed1235073ragweed
renewed11309993renewed
richweed17163583richweed
rinded84418983rin_ded
ringed84623843rin_ged
rinsed75016353rin_sed
rosinweed1341713rosinweed
seaweed11108813seaweed
silkweed1643223silkweed
singed85422293sin_ged
singled93914683singled
sinned73818413sin_ned
sintered92213903sintered
spindled12287643spindled
spined95423943spin__ed
stinkweed1762483stinkweed
tarweed1137343tarweed
tincted1037273tincted
tined65434533tin__ed
tineid74412013tin_eid
tinged84220793tin_ged
tingled93712793tingled
tinkered1387683tinkered
tinkled123910473tinkled
tinned74317533tin_ned
tinseled935763tinseled
tinted74419533tin_ted
tweed94915093__tweed
unwed94114873_unw_ed
viewed1345993view_ed
vined95626153vin__ed
viseed105310983vi_seed
waxweed2132923waxweed
weed85637513___weed
weeweed1435183weeweed
winced124415343win_ced
winched163110593winched
winded114918213win_ded
windled123713483windled
wined94434183win__ed
winged114620833win_ged
winked144018603win_ked
winkled15299593winkled
winned104017013win_ned
wintered122111573wintered
wintled11339843wintled
zinced18419413zin_ced
zincked2334233zincked
zinged174414623zin_ged

Search took 9 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 Limit1340272828.61015566.4
3Display Results2822820.1102563.6
 (SQL Overall)1786912828.87620131.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.