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

188 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
parapets123976(None) 
parapet11317641parapet_
carpets113915332car_pets
paraders113113112paraders
parades104121462parade_s
parakeets1545102parakeets
paraments13511552paraments
parapeted1446482parapeted
paraphs1439312parap_hs
paraquets2044592paraquets
pargets105215192par_gets
parquets1936412parquets
partlets102811512partlets
sarapes94617742sarape_s
adapts9107813_adap_ts
agapes95212413_agape_s
anapest9311553_anapest
anapests1046613_anapests
arames84622573_arame_s
armets84918353_ar_mets
armlets94610063_armlets
armpits1157133_armpits
arpens84814823_ar_pens
arpents93613083_ar_pents
barbets114915843bar_bets
baronets101410903baronets
barrets94917103bar_rets
cabarets12268463cabarets
cajaputs1942663cajaputs
canapes111213083canape_s
carafes125015703carafe_s
caramels1238803caramels
carates95630613carate_s
carats85929023cara__ts
caravels1337433caravels
carcanets1347303carcanets
carets85330773car__ets
carnets93918403car_nets
carpels115315463car_pels
carpers114521253car_pers
carpet104530093car_pet_
crapes104727693_crape_s
drapers105313353_drapers
drapes95419653_drape_s
garages9314113garage_s
gargets94614573gar_gets
garnets84115403gar_nets
garrets84413623gar_rets
grapes95123123_grape_s
hanapers1346963hanapers
harpers124916203har_pers
harslets1137833harslets
karates115617473karate_s
karats106420493kara__ts
lappets11329123la_ppets
lazarets1744803lazarets
malaperts1344053malaperts
markets133314033mar_kets
martlets103310483martlets
packets155114773pa_ckets
palaces114216453palace_s
palapas11311493palap_as
palates93624933palate_s
palavers1337993palavers
palets85122313p__alets
pallets93919303pa_llets
palpates122613063palpates
pampers133615933pa_mpers
panaceas1236763panaceas
pantalets1147673pantalets
papers105125323p__apers
parables121613563parables
paraclete1356343paraclete
paracletes1446093paracletes
parade94720643parade__
paraded114014263parade_d
parader103914863parade_r
paradors113411903paradors
parados103816053para_dos
parae76335703para_e__
paragons11311503paragons
parakeet14410523parakeet
parakite14410423parakite
parakites1549543parakites
parallels1145273parallels
parament12415393parament
paramenta1368863paramenta
parameter1349123parameter
parameters1448123parameters
paramos113213513para_mos
parangs104314373para_ngs
paranoeas1147513paranoeas
paraph13311263parap__h
paraquats2044383paraquats
paraquet1948783paraquet_
paras76143043para___s
parasite10314843parasite
parasites11313153parasites
parasols1039263parasols
parbakes1638343parbake_s
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
parkades1538273parkade_s
parkers133816873par_kers
parles86334403par_le_s
parleys125212373par_leys
parolees104313983parolees
paroles95025883parole_s
paroquets2043643paroquets
parquet18311583parquet_
parrakeets1652363parrakeets
parrels94713493par_rels
parriers103612903parriers
parries93925843parrie_s
parrokets1543923parrokets
parrots9312743par_rots
parsecs11429923par_secs
parsers94118153par_sers
parses85534703par_se_s
parsleys1335083parsleys
partakers1536563partakers
partakes1449923partake_s
partiers103514243partiers
parties93230863partie_s
partlet92720363partlet_
partners102711133partners
parts77743373par___ts
partyers13277763partyers
parures9512693parure_s
paupers114311073pa_upers
pavanes123612653pavane_s
percepts14247643percepts
periapts1237273periap_ts
peripety1546193peripety
perpents122312043per_pents
phrases12711463phrase_s
pipets105714773p__ipets
pirates93020333pirate_s
pitapats1244443pitapats
placets113911223p_lacets
planets93914083p_lanets
poppets10338853p_oppets
prases84429023p_rase_s
praters94921653p_raters
prates84633163p_rate_s
prats76333393p_ra__ts
praxes156215183p_raxe_s
prayers124212853p_rayers
presets94216423p_resets
privets122910053p_rivets
projets1639163p_rojets
propels113412843p_ropels
propers113619033p_ropers
prophets1539503p_rophets
propjets1935493p_ropjets
puppets10317013p_uppets
pyropes142210193pyrope_s
ramets83517393__ramets
rapers84327183__rapers
rapes75740723__rape_s
sarape84817573sarape__
sarsnets836783sarsnets
scrapers125510533scrapers
scrapes116217663scrape_s
serapes95218103serape_s
sparklets15275843sparklets
tabarets10287233tabarets
tappets113610013ta_ppets
targets84314223tar_gets
tarpapers1344273tarpapers
tartlets8289663tartlets
trapes85024463_trape_s
varlets10411573var_lets
warpers123413583war_pers
watapes12228383watape_s

Search took 9 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.403443402.0
2DLD Change Limit1461621887.83018666.9
3Display Results1881880.0762473.7
 (SQL Overall)1786911888.30921505.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.