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

263 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
parapet1131764(None) 
parapets1239771parapets
carpet104530092car_pet
parade94720642parade_
paraded114014262paraded
parader103914862parader
parades104121472parades
parae76335712para_e_
parakeet14410522parakeet
parament12415402parament
parapeted1446482parapeted
paraph13311262parap_h
paraphs1439312paraphs
paraquet1948792paraquet
parget94529392par_get
parquet18311582parquet
partlet92720362partlet
sarape84817572sarape_
sarapes94617752sarapes
adapt81218553_adap_t
agape85614843_agape_
agapes95212413_agapes
anapest9311563_anapest
arame75026633_arame_
arames84622573_arames
armet76739463_ar_met
armlet84118193_armlet
armpit10811093_armpit
arpen74418043_ar_pen
arpent84822093_ar_pent
barbet104427883bar_bet
baronet91022213baronet
barret84930493bar_ret
cabaret112519043cabaret
cajaput1844963cajaput
canape10913523canape_
canapes111213083canapes
carafe115416163carafe_
carafes125015713carafes
caramel11310253caramel
carapax1835793carapax
carat75048803cara__t
carate84734003carate_
carates95630613carates
caravel1238213caravel
carcanet12316353carcanet
caret75360563car__et
carnet84732873car_net
carped115923763car_ped
carpel105418473car_pel
carper104923633car_per
carpets113915333car_pets
crape96128443_crape_
craped116120533_craped
crapes104727693_crapes
drape85319633_drape_
draped105314363_draped
draper94315693_draper
drapes95419653_drapes
drapey125010583_drapey
enrapt8313013enrap_t
garage8314513garage_
garaged1039253garaged
garages9314113garages
garget84327273gar_get
garnet73928413gar_net
garret74426563gar_ret
grape84824663_grape_
grapes95123123_grapes
grapey126012303_grapey
hanaper1237133hanaper
hardset113415833hardset
harped124418403har_ped
harper115018403har_per
harslet10315653harslet
karat96837613kara__t
karate105320933karate_
karates115617473karates
lappet103817733la_ppet
lazaret16411783lazaret
malapert1249793malapert
market123226043mar_ket
martlet93419153martlet
packet144726503pa_cket
palace104516923palace_
palaced124110783palaced
palaces114216463palaces
palapa10310673palap_a
palapas11311493palapas
palate84226793palate_
palates93624943palates
palaver1238753palaver
palet74650803p__alet
pallet84232653pa_llet
palpate113213923palpate
palped114513643pa_lped
pamper124316663pa_mper
panacea1137793panacea
pantalet10415903pantalet
paper95128663p__aper
para65242183para___
parable111819783parable
parables121613573parables
paraclete1356353paraclete
paraders113113123paraders
parador103311413parador
parados103816053parados
paradox17358173paradox
paragon10311023paragon
parakeets1545113parakeets
parakite14410423parakite
parallel1047483parallel
paramenta1368873paramenta
paraments13511563paraments
parameter1349123parameter
paramo102614653para_mo
paramos113213513paramos
parang93715513para_ng
parangs104314383parangs
paranoea1048583paranoea
paraquat1947623paraquat
paraquets2044603paraquets
paras76143053para__s
parashot13410143parashot
parasite10314843parasite
parasol939553parasol
parbake1538353parbake_
parbaked1735503parbaked
parbakes1638343parbakes
parcel103915473par_cel
parched154013693parched
parches143720003parches
pardee93922023par_dee
pardie96021443pardie_
pardner10239473pardner
pare66760843par__e_
pared86946763par__ed
parent83230423par_ent
pareo74632603par__eo
parer75839903par__er
pares77164483par__es
pareses94718883pareses
pareu74928743par__eu
pareve114613013pareve_
parfait12312053parfait
parge85831853par_ge_
parged104922043par_ged
parges94529543par_ges
pargets105215193par_gets
paries84742523par_ies
parises94827193parises
parkade1437583parkade_
parkades1538273parkades
parked134425143par_ked
parker124121373par_ker
parlante1039693parlante
parlayed1435823parlayed
parle75836163par_le_
parled94626293par_led
parles86334413par_les
parley116718363par_ley
parole84425253parole_
paroled104217633paroled
parolee94119653parolee
paroles95025893paroles
paroquet1947283paroquet
parquets1936423parquets
parrakeet1545603parrakeet
parred95024073par_red
parrel84515983par_rel
parried103615723parried
parrier93717653parrier
parries93925853parries
parroket1449213parroket
parrot8320663par_rot
parse75236993par_se_
parsec105914483par_sec
parsed96323893par_sed
parser84822373par_ser
parses85534703par_ses
parsley1247803parsley
part65967463par___t
partake1339643partake_
partaken1445553partaken
partaker1436873partaker
partakes1449923partakes
parted94228683par_ted
partied103516553partied
partier93520713partier
parties93230873parties
partite9317133partite
partlets102811523partlets
partner92811393partner
partyer12337873partyer
parure8312523parure_
parures9512693parures
parve109824853par_ve_
pauper103511943pa_uper
pavane114113443pavane_
pavanes123612663pavanes
percept133112523percept
periapt11313413periap_t
peripety1546193peripety
perpent112318813per_pent
perspex1834183perspex
phrase11109903phrase_
phrased1387383phrased
phrases12711463phrases
pipet95533323p__ipet
pirate82322883pirate_
pirated102515613pirated
pirates93020333pirates
pitapat1149163pitapat
placet103923673p_lacet
planet84228353p_lanet
poppet92717323p_oppet
prase76128753p_rase_
prases84429023p_rases
prat65952043p_ra__t
prate75135983p_rate_
prated94924923p_rated
prater84825353p_rater
prates84633163p_rates
praxes156215183p_raxes
prayed124815433p_rayed
prayer114815293p_rayer
preset84430983p_reset
privet113821343p_rivet
projet15315183p_rojet
propel103714063p_ropel
proper104319953p_roper
prophet14316033p_rophet
propjet1839913p_ropjet
puppet93514593p_uppet
pyrope132810533pyrope_
pyropes142210193pyropes
ramet75743143__ramet
rape65041633__rape_
raped85334623__raped
raper74932753__raper
rapes75740723__rapes
rapt67245313__rap_t
sarsnet7314813sarsnet
scrape105917573scrape_
scraped124313143scraped
scraper114513423scraper
scrapes116217663scrapes
serape84818413serape_
serapes95218103serapes
sparklet143110593sparklet
tabaret92717313tabaret
tappet103820113ta_ppet
target75028913tar_get
tarpaper1244603tarpaper
tartlet72218483tartlet
trapes85024463_trapes
trapt76433393_trap_t
varlet9423503var_let
warped124816413war_ped
warper114015583war_per
watape11208483watape_
watapes12228383watapes
wrapt105123183_wrap_t

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 Filter1786911340270.686260482.5
2DLD Change Limit1340272638.80015230.3
3Display Results2632630.1062481.1
 (SQL Overall)1786912639.59218629.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.