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

276 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
piquet1741235(None) 
picquet2047741picquet
pique16410171pique_
piqued1836211piqued
piques1739091piques
piquets1836601piquets
briquet1838832briquet
coquet174318012coquet
diquat1639762diquat
fique1739142fique_
fiques1837972fiques
minuet82621032minuet
parquet18311582parquet
picket144924312picket
picquets2143732picquets
piglet93420922piglet
piolet83225642piolet
pipet95533322pi_pet
piquant1848002piquant
roquet154415892roquet
toquet154414682toquet
acquest1837173acquest
acquit17610323acquit
aiglet74224193aiglet
aigret73720023aigret
aliquot1646493aliquot
baguet9316103baguet
banquet1839783banquet
bequest1837823bequest
bidet84935623bi_det
billet86029723billet
bisque17257843bisque_
bisques18236893bisques
bluet75631193_bluet
bosquet18249223bosquet
bouquet18288263bouquet
briquets1934853briquets
caique17318803caique_
caiques18248793caiques
cinque1736853cinque_
cinques1837333cinques
cirque1735853cirque_
cirques1836463cirques
civet105828733ci_vet
clique17289193clique_
cliqued19266683cliqued
cliques18309203cliques
cliquey21295693cliquey
coquets18399893coquets
croquet1859683croquet
cruet74831843_cruet
diet57357533di__et
diluent8310263diluent
dilute72911803dilute
dipnet91317473dipnet
diquats1745983diquats
disquiet1879923disquiet
duet56446263__duet
epithet12312463epithet
fidget114216483fidget
filet85540163fi_let
fillet95027083fillet
gibbet114113383gibbet
giblet93418893giblet
giglet83920273giglet
gigue71210673gigue_
gigues8129003gigues
gimlet93716663gimlet
inlet53732403_inlet
inquest1638603inquest
inquiet16311413inquiet
inset54430863_inset
islet54527553_islet
kismet123414623kismet
limpet103518633limpet
linnet6419423linnet
liquate1638423liquate
liquefy2243013liquefy
liqueur1642923liqueur
liquid1637143liquid
liquor1534203liquor
loquat1558283loquat
midget103718453midget
millet84030743millet
minuets9259853minuets
minute83414293minute
miquelet1944473miquelet
mismet103722373mismet
misset85028153misset
nidget83715643nidget
opaque1734213opaque_
opaqued1942193opaqued
opaquer1842403opaquer
opaques1833643opaques
opaquest1943223opaquest
packet144726503packet
palet74650803p_alet
pallet84232653pallet
paraquet1948783paraquet
parget94529393parget
paroquet1947283paroquet
parquets1936413parquets
pellet83326553pellet
pelmet103419243pelmet
penult8314653penult
perique1837523perique_
periques1937653periques
pet56477303p___et
phut96925973p_hu_t
pice84641093pi_ce_
picked154421313picked
picker144422173picker
pickets154314183pickets
picot95031013pi_cot
picul95015363picu_l
piculs103511753piculs
pie55457403pi__e_
piece96717993piece_
pieced113912103pieced
piecer105213083piecer
pieces104217273pieces
pied75035363pi__ed
pier66035293pi__er
pies66949603pi__es
pieta75421753pi__eta
piety105817303pi__ety
pigged114214153pigged
piglets103311793piglets
pigment12510733pigment
pignut9311573pignut
pigout9314613pigout
pigpen1136583pigpen
pike106335213pi_ke_
piked125623313pi_ked
piker115622843pi_ker
pikes115031033pi_kes
pile65649693pi_le_
pilea75123953pi_lea
piled85232993pi_led
pilei74021783pi_lei
piles74742613pi_les
pileum10399513pileum
pileup10437923pileup
pileus84514943pileus
pilfer1139163pilfer
pilled94222753pilled
pilot77435063pi_lot
pilule8411123pilule
pilules9510623pilules
pilus75921063pilu_s
pimped134913483pimped
pincer104019173pincer
pinder94523453pinder
pine67755713pi_ne_
pined85935323pi_ned
pines76048863pi_nes
pineta85815563pi_neta
piney105727503pi_ney
pinged104321383pinged
pinger94324093pinger
pinier84024693pinier
piniest93121133piniest
pinite8321243pinite
pinked134819883pinked
pinken124513283pinken
pinker125322443pinker
pinkest132812623pinkest
pinkey154314673pinkey
pinned94818383pinned
pinner84521503pinner
pinot78737293pi_not
pint66963173pi__nt
pinup9612883pinu_p
pinups1037413pinups
piolets93513193piolets
pious74621273piou_s
pipe86434433pi_pe_
piped105123163pi_ped
piper96523193pi_per
pipes96030143pi_pes
pipets105714773pi_pets
pipier104913983pipier
pipiest113114503pipiest
pipit95224873pi_pit
pipped104516543pipped
piquing1935873piquing
pirate82322883pirate
piroque1844353piroque_
piroques1944353piroques
pished124817063pished
pisher114317753pisher
pishes114722103pishes
pissed94816933pissed
pisser84416383pisser
pisses84525083pisses
piste75824603piste_
pistes85325633pistes
pit56471923pi___t
pithed124615613pithed
pitied94017253pitied
pitier84019823pitier
pities83828083pities
pitmen102510793pitmen
pitted94319593pitted
piu56639543pi_u__
pivot106523873pi_vot
pixel143911903pi_xel
pixes144323173pi_xes
pixie145415523pixie_
pixies154915513pixies
placet103923673placet
planet84228353planet
plaque17317643plaque_
plaques18317893plaques
pocket144622623pocket
poet65552903p__oet
poppet92717323poppet
posset84923253posset
poult76928873p_oult
pout65752553p_ou_t
prequel1836343prequel
preset84430983preset
pricket153616443pricket
privet113821343privet
projet15315183projet
pullet84026333pullet
pulque1736213pulque_
pulques1835323pulques
punnet83518843punnet
punt65747203p__unt
puppet93514593puppet
put55759073p__u_t
putt66937843p__utt
quest144121323__quest
quey164616473__quey
quiet144530733__quiet
quit136136513__quit
racquet1838743racquet
request16311023request
riblet84222443riblet
rillet64828853rillet
risque15227453risque_
rivet85636363ri_vet
rivulet1069723rivulet
roque144812133roque_
roques154912563roques
roquets16398943roquets
sequel1556713sequel
sequent16410323sequent
signet73621153signet
sippet103519393sippet
spinet85629753spi_net
squat143720143_squat
squeg1588033_squeg
suet46754823__suet
ticket124524853ticket
tippet103917873tippet
toque145113093toque_
toques154612353toques
toquets16367863toquets
tuque14469193tuque_
tuques15358373tuques
ubique1784883ubique_
unique1558163unique_
uniquer1675783uniquer
uniques1667443uniques
uniquest1775603uniquest
unquiet16310663unquiet
usque14137733usque_
usques15126803usques
violet92620923violet
wicket155318943wicket
widget113815263widget
wiglet105519153wiglet
willet95124833willet
zibet16419733zi_bet

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.373479064.3
2DLD Change Limit1127162764.70323966.8
3Display Results2762760.0803450.0
 (SQL Overall)1786912765.15634656.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.