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

152 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
parquets193641(None) 
paraquets2044591paraquets
paroquets2043641paroquets
parquet18311581parquet_
banquets1935432banquets
barques18259642barque_s
marquees19206242marquees
marques182610862marque_s
marquess19204952marquess
parapets1239762parapets
paraquats2044382paraquats
paraquet1948782paraquet_
pargets105215192par_gets
paroquet1947282paroquet_
parqueted2144222parqueted
parquetry2352912parquetry
partlets102811512partlets
picquets2143732picquets
piquets1836602p_iquets
racquets1944762racquets
acquest1837173_acquest
acquests1944643_acquests
acquits1857293_acquits
arbutes939703_arbutes
arguers8489033_arguers
argues74516413_argue_s
armets84918353_ar_mets
armlets94610063_armlets
arquebus1942263_arquebus
baguets1037483ba_guets
banquet1839783banquet_
barbets114915843bar_bets
barbuts11439843barbu_ts
barguest1137163barguest
barguests1243483barguests
baronets101410903baronets
baroques1934863baroque_s
barque17239553barque__
barquette2064903barquette
barquettes2174753barquettes
barrets94917103bar_rets
basques18248673basque_s
bosquets19195253bosquets
bouquets19244523bouquets
briquets1934853briquets
caiques18248793caique_s
calques182710193calque_s
carburets1345203carburets
carets85330773car__ets
carnets93918403car_nets
carpets113915333car_pets
casques18278983casque_s
cirques1836463cirque_s
coquets18399893_coquets
croquets1955213croquets
cruets85314953_cr_uets
gargets94614573gar_gets
garnets84115403gar_nets
garrets84413623gar_rets
harquebus2351533harquebus
harslets1137833harslets
lacquers19125033lacquers
lacqueys22132693lacqueys
languets987243languets
markets133314033mar_kets
marque172410503marque__
marquee18218583marque_e
marquetry2362613marquetry
marquis18247063marqu_is
martlets103310483martlets
masquers19195703masquers
masques18239363masque_s
opaques1833643opa_que_s
opaquest1943223opa_quest
packets155114773pa_ckets
palets85122313pa__lets
pallets93919303pa_llets
paraders113113113paraders
parades104121463parade_s
parakeets1545103parakeets
paraments13511553paraments
parapet11317643parapet_
paraquat1947613paraquat_
parcels113712663par_cels
parches143720003parche_s
pardners11269193pardners
parents93418123par_ents
pareos87023773par__eos
parers85530743par__ers
pares77164483par__e_s
pareses94718883parese_s
pareus85420743par__eus
parfaits1346913parfaits
parges94529543par_ge_s
parget94529393par_get_
paries84742513par_ie_s
parietes10714543par_ietes
parises94827183parise_s
parkers133816873par_kers
parles86334403par_le_s
parleys125212373par_leys
parolees104313983parolees
paroles95025883parole_s
parous84024163parou__s
parqueting2243633parqueting
parquetries2254123parquetries
parrels94713493par_rels
parriers103612903parriers
parries93925843parrie_s
parrokets1543923parrokets
parrots9312743par_rots
parsecs11429923par_secs
parsers94118153par_sers
parses85534703par_se_s
parsleys1335083parsleys
partiers103514243partiers
parties93230863partie_s
partlet92720363partlet_
partners102711133partners
parts77743373par___ts
partyers13277763partyers
paruras9310533par_uras
parures9512693par_ures
pasquils1943123pasquils
payouts1247303payou_ts
perdues103511333perdue_s
periques1937653perique_s
permutes1238713permutes
picquet2047743picquet_
piques1739093p_ique_s
piquet17412353p_iquet_
piroques1944353piroque_s
plaques18317893plaque_s
prequels1934833prequels
presets94216423p_resets
privets122910053p_rivets
projets1639163p_rojets
pulques1835323pulque_s
pursuers10376523pursuers
pursues94111373pursue_s
pursuits1045043pursuits
racquet1838743racquet_
roquets16398943_roquets
sacques18106863sacque_s
sarsnets836783sarsnets
sparklets15275843sparklets
targets84314223tar_gets
tartlets8289663tartlets
toquets16367863_toquets
torquers17204303torquers
torques16217513torque_s
varlets10411573var_lets

Search took 10 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621528.59617003.5
3Display Results1521520.0602533.3
 (SQL Overall)1786911529.07619688.3
 
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.