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

191 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
pignuts103561(None) 
pignus937951pignu_s
pignut9311571pignut_
pigouts1037591pigouts
hognuts1134182hognuts
peanuts936992peanuts
piglets103311792piglets
pigout9314612pigout_
pinots85920272pi_nots
pints75936222pi_n_ts
pinups1037412pi_nups
signets83311502signets
aiglets84012913aiglets
aigrets82810533aigrets
beignets11155373beignets
bights124417963big_hts
bigness1038193bigness
bigots95015133big_ots
binits85716673bi_nits
bints76130183bi_n_ts
bionts8612393bion_ts
bugouts1036193bugouts
cobnuts1135353cobnuts
cygnets1333813cygnets
digests93610613digests
dights114016963dig_hts
digits84114533dig_its
diglots9299503diglots
dignity1236463dignity
dimouts1037893dimouts
dingus83611843dingu_s
dints67431313di_n_ts
dipnets10109033dipnets
donuts7410583_donuts
dugouts935043dugouts
eights103618983eig_hts
engluts834533engluts
epigonus1144423epigonu_s
fights133816553fig_hts
giants74713503gian_ts
giglets93211553giglets
giglots9367863giglots
gigots83911953gig_ots
gigues8129003gig_ues
gluts66120133__gluts
gnats65217713__gnats
gnus56518003__gnu_s
gouts64826173__gouts
guts56637253__g_uts
hagbuts1354933hagbuts
hights133716893hig_hts
hints87330623hi_n_ts
hognut1039413hognut_
iglus6609933_iglu_s
ignite71410583_ignite
ignites81310583_ignites
ingots7912063_ingots
inputs837703_inputs
lights104519913lig_hts
lignans8398853lignans
lignins84010493lignins
lignite81310303lignite
lignites9129613lignites
linnets739833linnets
lints57137193li_n_ts
linums838283li_nums
magnets10311143magnets
magnums1234683magnums
midguts11296013midguts
mights123516253mig_hts
mignons1037863mignons
mints76834043mi_n_ts
minuets9259853mi_nuets
minus75223933mi_nu_s
minute83414293mi_nute
minutes93513443mi_nutes
miscuts1139183miscuts
nights104117723nig_hts
nuts45032673___nuts
paints85921833pain_ts
pants76536923p_an_ts
payouts1247303payouts
peanut8318183peanut_
penults937123p_enults
phuts104613503p__huts
pianist9615103pianist
pianists1049013pianists
pianos84315933pian_os
pians75126963pian__s
pickets154314183pickets
pickups1754253pickups
picnics13297343picnics
picots104616443pi_cots
picquets2143733picquets
piculs103511753pi_culs
pigboats1344523pigboats
pigeons1039183pigeons
piggies113813483piggies
piggins113010473piggins
piglet93420923piglet_
pigments1337343pigments
pigmies122610993pigmies
pignoli1045443pignoli
pignolis1146053pignolis
pignora10306363pignora
pigpens1235503pigpens
pigs76634223pig___s
pigsneys1442003pigsneys
pigsty1235933pig_sty
pilaus84114133pilau_s
pileups11365433pileups
pileus84514943pileu_s
pilots84018873pi_lots
pilous84717753pilou_s
pilus75921063pi_lu_s
pinas75434453pi_n_as
pinata83817223pi_nata
pinatas93711503pi_natas
pines76048863pi_n_es
pineta85815563pi_neta
pingers104020743pingers
pingoes105116523pingoes
pingos95317673pi_ngos
pings85830883pi_n_gs
pinguid1146243pinguid
pinite8321243pi_nite
pinites9319533pi_nites
pinkos125313873pi_nkos
pinks115729383pi_n_ks
pinnas85315513pi_nnas
pinnate93613743pinnate
pinners93518603pinners
pinnies93318443pinnies
pinnula934923pinnula
pinnule936003pinnule
pinnules1036463pinnules
pinons86019943pi_nons
pinot78737293pi_not_
pins65558453pi_n__s
pint66963173pi_n_t_
pinta75727053pi_n_ta
pintas85021393pi_ntas
pinto75625753pi_n_to
pintos86021293pi_ntos
pinup9612883pi_nu_p
piolets93513193piolets
pions75826393pion__s
pious74621273pi_ou_s
pipets105714773pi_pets
pipits104713063pi_pits
piques1739093pi_ques
piquets1836603piquets
pirns76020093pirn__s
pits66348743pi___ts
pivots115111903pi_vots
planets93914083planets
plants84921803plan_ts
plenums1136533plenums
plights13299313plig_hts
points85618533poin_ts
pouts75530323p__outs
precuts111710473precuts
prints84320103prin_ts
prunus8399363prunu_s
punnets9409263punnets
punts75828003p_un_ts
putouts937083putouts
puts65641753p___uts
qiviuts1942893qiviuts
ragouts838543ragouts
rights104019333rig_hts
rigours8207003rigours
sagbuts1065223sagbuts
sights103818013sig_hts
signals8359163signals
signees83510803signees
signers84714443signers
signet73621153signet_
signors83410913signors
signs65516323sign__s
sinus55523853si_nu_s
spigots1037793spig_ots
spinets94714813spi_nets
spinouts1036023spinouts
tights104015853tig_hts
tincts84510803ti_ncts
tints56030923ti_n_ts
vigours11285483vigours
walnuts1033843walnuts
wights133315783wig_hts
wiglets113411423wiglets

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.390458182.1
2DLD Change Limit1340271917.06318975.9
3Display Results1911910.0762513.2
 (SQL Overall)1786911917.52923733.7
 
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.