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

220 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
pignut931157(None) 
pignus937951pignus
pignuts1035611pignuts
pigout9314611pigout
hognut1039412hognut
peanut8318182peanut
piglet93420922piglet
pigouts1037592pigouts
pinot78737292pi_not
pint66963172pi_n_t
pinup9612882pi_nup
signet73621152signet
aiglet74224193aiglet
aigret73720023aigret
beignet101510963beignet
bight118728843big_ht
bigot84828323big_ot
binit76431583bi_nit
bint67355043bi_n_t
biont7727163bion_t
bugout9311863bugout
cobnut10311323cobnut
cygnet1237893cygnet
digest84019623digest
dight104027003dig_ht
digit73825273dig_it
diglot83014333diglot
dignity1236453dignity
dimout9414243dimout
dingus83611843dingus
dint56759053di_n_t
dipnet91317473dipnet
donut6324513_donut
dugout8310363dugout
eight94928053eig_ht
englut738453englut
epigonus1144423epigonus
fight124027093fig_ht
giant65430593gian_t
giglet83920273giglet
giglot84013133giglot
gigot74023073gig_ot
gigue71210673gig_ue
glut56331293__glut
gnat56034433__gnat
gnu45522043__gnu_
gnus56518003__gnus
gout56646003__gout
gut46753853__g_ut
hagbut1278913hagbut
hight125327233hig_ht
hint77455743hi_n_t
hognuts1134183hognuts
iglu510814783_iglu_
iglus6609933_iglus
ignite71410583_ignite
ingot61221063_ingot
input7314653_input
light94429603lig_ht
lignan75510323lignan
lignin74911193lignin
lignite81310303lignite
lingua7509913lingua
linnet6419423linnet
lint416266233li_n_t
linum7313823li_num
magnet9320663magnet
magnum1136733magnum
midgut103510053midgut
might113827083mig_ht
mignon937953mignon
mint66758063mi_n_t
minuet82621033mi_nuet
minus75223933mi_nus
minute83414293mi_nute
miscut10614813miscut
night94327853nig_ht
nut36651963___nut
paint75443693pain_t
pant66061263p_an_t
payout11714653payout
peanuts936993peanuts
pent66559073p_en_t
penult8314653p_enult
phut96925973p__hut
pian66136093pian__
pianic103714123pianic
pianist9615103pianist
piano76118713pian_o
pianos84315933pianos
pians75126963pian_s
picket144924313picket
pickup1655633pickup
picnic123410263picnic
picot95031013pi_cot
picquet2047743picquet
picul95015363pi_cul
pig65744973pig___
pigboat1247823pigboat
pigeon949413pigeon
pigged114214153pigged
piggie103210773piggie
piggin103111093piggin
piggy124011433pig_gy
piglets103311793piglets
pigment12510733pigment
pigmy13299433pig_my
pignoli1045443pignoli
pignora10306363pignora
pigpen1136583pigpen
pigs76634223pig__s
pigsney1342873pigsney
pigsty1235933pigsty
piing85218833piin_g
pilau73618523pilau_
pilaus84114133pilaus
pileum10399513pileum
pileup10437923pileup
pileus84514943pileus
pilot77435063pi_lot
pilous84717753pilous
pilus75921063pi_lus
pin57066723pi_n__
pina65842633pi_n_a
pinas75434453pi_nas
pinata83817223pi_nata
pinch125619303pi_nch
pine67755713pi_n_e
pined85935323pi_ned
pines76048863pi_nes
pineta85815563pi_neta
piney105727503pi_ney
ping75943593pi_n_g
pinged104321383pinged
pinger94324093pinger
pingo87122713pi_ngo
pingos95317673pingos
pings85830883pi_ngs
pinguid1146243pinguid
pinite8321243pi_nite
pink107039383pi_n_k
pinko115618253pi_nko
pinks115729383pi_nks
pinky145823403pi_nky
pinna75320183pi_nna
pinnae84414643pinnae
pinnal84814273pinnal
pinnas85315513pinnas
pinnate93613743pinnate
pinned94818383pinned
pinner84521503pinner
pinnula934913pinnula
pinnule936003pinnule
pinny105222063pi_nny
pinon76024533pi_non
pinots85920273pi_nots
pins65558453pi_n_s
pinta75727053pi_nta
pinto75625753pi_nto
pints75936223pi_nts
pinups1037413pi_nups
piny911838353pi_n_y
piolet83225643piolet
pion67235293pion__
pionic103515953pionic
pions75826393pion_s
pious74621273pi_ous
pipet95533323pi_pet
pipit95224873pi_pit
pique16410173pi_que
piquet17412353piquet
pirn67128373pirn__
pirns76020093pirn_s
pit56471923pi___t
piu56639543pi__u_
pivot106523873pi_vot
planet84228353planet
plant75437113plan_t
plenum1039503plenum
pliant83918823plian_t
plight123513363plig_ht
poignant1145743poignant
point75338733poin_t
pout65752553p__out
precut102016533precut
print74837463prin_t
prunus8399363prunus
punnet83518843punnet
punt65747203p_un_t
put55759073p___ut
putout8315113putout
qiviut1846613qiviut
ragout7317183ragout
regnum957163regnum
riant55833153rian_t
right94430503rig_ht
rigour7258023rigour
sagbut959753sagbut
sight94629293sig_ht
siglum936563siglum
sign55523053sign__
signa66114703sign_a
signal73711483signal
signed83413753signed
signee73617233signee
signer74015633signer
signets83311503signets
signor73510353signor
signs65516323sign_s
sinus55523853si_nus
spigot9312603spig_ot
spinet85629753spi_net
spinout9311583spinout
tight93626503tig_ht
tinct76126233ti_nct
tint46758863ti_n_t
vigour10256803vigour
walnut939433walnut
wight123725573wig_ht
wiglet105519153wiglet

Search took 6 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127162205.06322262.7
3Display Results2202200.0603666.7
 (SQL Overall)1786912205.24934042.9
 
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.