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

222 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
piquets183660(None) 
picquets2143731picquets
piques1739091pique_s
piquet17412351piquet_
briquets1934852briquets
coquets18399892coquets
diquats1745982diquats
fiques1837972fique_s
minuets9259852minuets
parquets1936412parquets
pickets154314182pickets
picquet2047742picquet_
piglets103311792piglets
piolets93513192piolets
pipets105714772pi_pets
pique16410172pique__
piqued1836212pique_d
roquets16398942roquets
toquets16367862toquets
acquest1837173acquest
acquests1944643acquests
acquits1857293acquits
aiglets84012913aiglets
aigrets82810533aigrets
aliquots1743643aliquots
baguets1037483baguets
banquets1935433banquets
bequest1837823bequest
bequests1944113bequests
bidets95215533bi_dets
billets94516153billets
bisques18236893bisque_s
bluets87215493_bluets
bosquets19195253bosquets
bouquets19244523bouquets
briquet1838833briquet_
caiques18248793caique_s
cinques1837333cinque_s
cirques1836463cirque_s
civets115212543ci_vets
cliques18309203clique_s
coquet174318013coquet_
croquets1955213croquets
cruets85314953_cruets
diets66026643di__ets
diluents946053diluents
dilutes82911973dilutes
dipnets10109033dipnets
diquat1639763diquat_
disquiets1964573disquiets
duets65323883__duets
epithets1345763epithets
fidgets12388763fidgets
filets94718953fi_lets
fillets103414753fillets
fique1739143fique__
gibbets12417723gibbets
giblets103210423giblets
giglets93211553giglets
gigues8129003gigue_s
gimlets10338433gimlets
inlets63915573_inlets
inquest1638603inquest
inquests1744943inquests
inquiets1745433inquiets
insets64016133_insets
islets64513083_islets
kismets13306883kismets
limpets11329783limpets
linnets739833linnets
liquate1638423liquate
liquates1737453liquates
liquefy2243013liquefy
liqueur1642923liqueur
liqueurs1742413liqueurs
liquids1735823liquids
liquors1634433liquors
loquats1645273loquats
midgets113910253midgets
millets94216843millets
minuet82621033minuet_
minutes93513443minutes
miquelets2042343miquelets
missets94516573missets
nidgets9358143nidgets
opaques1833643opaque_s
opaquest1943223opaquest
packets155114773packets
palets85122313p_alets
pallets93919303pallets
paraquets2044593paraquets
pargets105215193pargets
paroquets2043643paroquets
parquet18311583parquet_
pellets94014783pellets
pelmets11309693pelmets
penults937123penults
periques1937653perique_s
pets66248333p___ets
phuts104613503p_hu_ts
pickers153718093pickers
picket144924313picket_
picots104616443pi_cots
piculs103511753picu_ls
piecers114112253piecers
pieces104217273piece_s
piers75926333pi__ers
pies66949603pi__e_s
pieta75421753pi__eta
pietas84516503pi__etas
piety105817303pi__ety
piglet93420923piglet_
pigments1337343pigments
pignuts1035613pignuts
pigouts1037593pigouts
pigpens1235503pigpens
pikers124717393pi_kers
pikes115031033pi_ke_s
piles74742613pi_le_s
pileups11365433pileups
pileus84514943pi_leus
pilfers1238963pilfers
pilots84018873pi_lots
pilules9510623pilules
pilus75921063pilu__s
pincers113916503pincers
pinders103720473pinders
pines76048863pi_ne_s
pineta85815563pi_neta
pingers104020743pingers
piniest93121133piniest
pinites9319533pinites
pinkens13419643pinkens
pinkers134118603pinkers
pinkest132812623pinkest
pinkeys16378213pinkeys
pinners93518603pinners
pinots85920273pi_nots
pints75936223pi__nts
pinups1037413pinu_ps
piolet83225643piolet_
pious74621273piou__s
pipers104318663pi_pers
pipes96030143pi_pe_s
pipet95533323pi_pet_
pipiest113114503pipiest
pipits104713063pi_pits
piquant1848003piquant
piquing1935873piquing
pirates93020333pirates
piroques1944353piroque_s
pishers123815753pishers
pishes114722103pishe_s
pissers95014753pissers
pisses84525083pisse_s
pistes85325633piste_s
pitiers93812653pitiers
pities83828083pitie_s
pits66348743pi___ts
pivots115111903pi_vots
pixels15478533pi_xels
pixes144323173pi_xe_s
pixies154915513pixie_s
placets113911223placets
planets93914083planets
plaques18317893plaque_s
pockets154612253pockets
poets76024443p__oets
poppets10338853poppets
possets94212773possets
poults84613483p_oults
pouts75530323p_ou_ts
prequels1934833prequels
presets94216423presets
prickets16329083prickets
privets122910053privets
projets1639163projets
pullets94015163pullets
pulques1835323pulque_s
punnets9409263punnets
punts75828003p__unts
puppets10317013puppets
puts65641753p__u_ts
putts75719273p__utts
quest144121323__quest
quests153310353__quests
queys17398363__queys
quiets154014373__quiets
quits144122353__quits
racquets1944763racquets
request16311023request
requests1735743requests
riblets93412553riblets
rickets134915093rickets
rillets74216153rillets
rivets94417113ri_vets
rivulets1174753rivulets
roques154912563roque_s
roquet154415893roquet_
sequels1665703sequels
sequents1756993sequents
signets83311503signets
sippets113310183sippets
spinets94714813spi_nets
squats153712963_squats
squegs1675643_squegs
suets55126103__suets
tickets134113683tickets
tippets11339373tippets
toques154612353toque_s
toquet154414683toquet_
tuques15358373tuque_s
uniques1667443unique_s
uniquest1775603uniquest
unquiets1744313unquiets
usques15126803usque_s
violets102210003violets
wickets164010943wickets
widgets12318453widgets
wiglets113411423wiglets
willets104414323willets
zibets1737743zi_bets

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 Limit1340272226.57620381.2
3Display Results2222220.0802775.0
 (SQL Overall)1786912227.06225303.2
 
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.