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

504 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
parrot832066(None) 
carrot8423121carrot
parrots9312741parrots
parroty1247861parroty
argot67728652_argot
arrow83414882_arrow
barret84930482barret
barrow114512762barrow
carrom10513402carrom
carrots9714622carrots
carroty1248942carroty
farrow12309972farrow
garret74426562garret
garron73113492garron
garrote8510102garrote
harlot94422802harlot
harrow122610772harrow
karroo10410012karroo
marmot10318742marmot
marron83717542marron
marrow112812602marrow
narrow9269142narrow
pardon94618732pardon
parent83230422parent
pareo74632602pareo_
pareos87023772pareos
parget94529392parget
pargo86723722pargo_
pargos95719042pargos
parlor8312672parlor
parol74826272pa_rol
parr65731152parr__
parral85517532parral
parred95024072parred
parrel84515982parrel
parroket1449202parroket
parroted1158842parroted
parroter1058202parroter
parrs75928672parr_s
parry105323752parr_y
parson83817902parson
part65967462pa_r_t
parton84720992parton
parvo107719182parvo_
parvos116614752parvos
patriot9314532patriot
patrol83213022patrol
patron84018042patron
perron83216622perron
pierrot948832pierrot
pyrrol1136272pyrrol
sparrow1234262sparrow
tarot55943932ta_rot
yarrow12287932yarrow
aarrgh10786303aarrgh
abbot9318453_abbot
abort76133583_abort
adroit7518793_adroit
aero45435343_aero_
afoot8420113_afoot
afrit8323173_afrit
agorot7415003agorot
airt45757783_air_t
allot54933873_allot
amort75832203_amort
apart74330673apar_t
aport75432173apor_t
apricot111010183apricot
apron7318833_apron
arbor74818113_arbor
arco68331543_arco_
ardor64617863_ardor
argol65317263_argol
argon65520593_argon
argots74116033_argots
arhat8327093_arhat
armet76739453_armet
armor75118053_armor
arrant6623253_arrant
arras55626133_arras
array86317143_array
arrest63722633_arrest
arris56824683_arris
arroba898663_arroba
arrows92813483_arrows
arrowy12288273_arrowy
arroyo936963_arroyo
arson55118833_arson
art38679143_a_r_t
arvo76023433_arvo_
arvos86015663_arvos
ascot76522513_ascot
ballot84624093ballot
barbet104427883barbet
barbut104617003barbut
barest85327693barest
barhop13319643barhop
barlow112911423barlow
baron78131243ba_ron
barre75929543barr_e
barred95725793barred
barrel84517873barrel
barren85317613barren
barres84427543barres
barrets94917103barrets
barrio8312573barrio
barrios9310773barrios
barroom1139373barroom
barrows123411683barrows
baryon111211613baryon
borrow114310723borrow
burbot10815653burbot
burro75018493burro_
burros85114993burros
burrow114610803burrow
cahoot11416473cahoot
cannot83616773cannot
carat75048793ca_rat
carbo94923843carbo_
carbon104919043carbon
carbos105122263carbos
carboy134914183carboy
cardon94120853cardon
caret75360563ca_ret
cargo85322073cargo_
cargos94619183cargos
carhop133610763carhop
carnet84732873carnet
carob95325223ca_rob
carol75128613ca_rol
carom95025563ca_rom
carpet104530093carpet
carport11316033carport
carr65434703carr__
carrel84718633carrel
carrion9312673carrion
carroch1437093carroch
carroms11512403carroms
carrotin102210893carrotin
carrs75730853carr_s
carry105823783carr_y
carryon1237033carryon
carryout1346793carryout
cart66570343ca_r_t
carton84522663carton
cartop104213563cartop
cavort11316173cavort
chariot12316213chariot
charro114212953charro_
charros124312143charros
dacron94310693dacron
dart55857873da_r_t
eardrop1065223eardrop
earshot10410833earshot
enroot6615993enroot
ergot65422893_ergot
error53712233_error
faggot1139053faggot
fagot9323403fa_got
faro76136923fa_ro_
faros85532023fa_ros
farrows13259783farrows
fart76860563fa_r_t
ferret93021173ferret
forgot104318133forgot
forrit91916623forrit
furrow12427743furrow
galiot72322593galiot
galoot72719163galoot
garcon92912483garcon
garget84327273garget
garnet73928413garnet
garote7717953ga_rote
garred85217413garred
garrets84413623garrets
garrons82713463garrons
garroted1056783garroted
garroter956573garroter
garrotes969363garrotes
garrotte965683garrotte
gavot9321123ga_vot
griot65328413_griot
grot55942053__grot
hadron102913753hadron
hallot95426783hallot
harbor11410723harbor
haricot12311963haricot
harlots103413293harlots
harrows132611033harrows
harry115322953harr_y
hart76865773ha_r_t
heriot9422343heriot
horror988723horror
jabot14321513ja_bot
jargon1448823jargon
jarrah1636683jarrah
jarred144613253jarred
karat96837593ka_rat
karoo92519583ka_roo
karoos102415803karoos
karroos1139313karroos
karst97228993ka_rst
kart86750803ka_r_t
labret8320223labret
ladron73413323ladron
lardon74415063lardon
largo65319783largo_
largos74815063largos
lariat6629043lariat
larrup835713larrup
lirot5430033_lirot
macro94718173macro_
macron103615673macron
macros104017013macros
maggot10311713maggot
magot8326393ma_got
market123226043market
marmots11311513marmots
maroon83118203maroon
marplot1149673marplot
marram10313883marram
marred95421043marred
marrer83716673marrer
marrons93216973marrons
marrows122911823marrows
marrowy15236083marrowy
marry104821693marr_y
mart66865983ma_r_t
mascot104016073mascot
matron83918313matron
matzot17710983matzot
merlot83217613merlot
mirror848003mirror
morro73216953morro_
morros83714673morros
morrow113510093morrow
narco76718243narco_
narcos86714203narcos
narrate7313493narrate
narrows10258843narrows
natron64116023natron
packet144726503packet
pact86648723pa__ct
padre86018163padr_e
padres95016983padres
padri85815173padr_i
padrone102512073padrone
padroni10278613padroni
paeon74819493pa_eon
pagod95013683pa_god
paint75443693pa_int
pair66031513pair__
paired95017523paired
pairs75325833pair_s
pakora1247283pakora
palest83926223palest
palet74650803pa_let
paletot9413713paletot
pallet84232653pallet
pallor8313673pallor
pandit93820753pandit
pant66061263pa__nt
panto76129413panto_
pantos85222743pantos
papist102618753papist
par57467023pa_r__
para65242173pa_r_a
parade94720643parade
parador103311413parador
parados103816053parados
paradox17358173paradox
paradrop1344603paradrop
parae76335703pa_rae
paragon10311023paragon
paramo102614643paramo
paramos113213513paramos
parang93715513parang
parapet11317643parapet
paraph13311263paraph
paras76143043pa_ras
parashot13410143parashot
parasol939553parasol
parboil1138323parboil
parcel103915473parcel
parch125123003pa_rch
pard76441323pa_r_d
pardah123412823pardah
pardee93922023pardee
pardi85723953pa_rdi
pardie96021443pardie
pardons103817623pardons
pards85634333pa_rds
pardy115523953pa_rdy
pare66760843pa_r_e
pared86946763pa_red
parents93418123parents
parer75839903pa_rer
parerga1035173parerga
parergon1144393parergon
parers85530743parers
pares77164483pa_res
pareu74928743pa_reu
pareus85420743pareus
pareve114613013pareve
parfait12312053parfait
parge85831853pa_rge
parged104922043parged
parges94529543parges
pargets105215193pargets
pariah114320583pariah
parian83223963parian
paries84742513paries
paring94236493paring
paris75145943pa_ris
parish115022353parish
parity114719873parity
park105237493pa_r_k
parka115120883pa_rka
parkas125018023parkas
parked134425143parked
parker124121373parker
parks116134463pa_rks
parlay113713993parlay
parle75836163pa_rle
parled94626293parled
parles86334403parles
parley116718363parley
parlors9312913parlors
parlour937263parlour
parlous9414293parlous
parodoi10267723parodoi
parodos103011753parodos
parody12410093parody
parole84425253parole
parols84722613parols
parotic112518043pa_rotic
parotid102915513pa_rotid
parous84024163parous
parquet18311583parquet
parrals94414573parrals
parrels94713493parrels
parried103615723parried
parrier93717653parrier
parries93925843parries
parring103222063parring
parritch1543543parritch
parrokets1543923parrokets
parroters1156763parroters
parroting1239153parroting
pars67560793pa_r_s
parse75236993pa_rse
parsec105914483parsec
parsed96323893parsed
parser84822373parser
parses85534703parses
parsons93516873parsons
partan83820563partan
parted94228683parted
partita9310863partita
partite9317133partite
partlet92720363partlet
partly116315473partly
partons94620513partons
partook1337313partook
parts77743373pa_rts
party106630613pa_rty
parura8310583parura
paruras9310533paruras
parure8312523parure
parures9512693parures
parve109824853pa_rve
parvis116114803parvis
paseo77022513paseo_
paseos88015813paseos
past65959013pa__st
pastor84817483pastor
pat58089463pa___t
patent84524923patent
pathos115516693pathos
patio74426353patio_
patios85221783patios
patriots1038053patriots
patrols93513513patrols
patrons93818103patrons
patroon92811973patroon
pavior1138533pavior
pawnor11357243pawnor
payor105413843pa_yor
payors114312643payors
payout11714653payout
payroll1245613payroll
peart76440753pear_t
pedro8313153pedro_
pedros9312183pedros
pereon83517453pereon
peridot10514243peridot
period9314983period
permit10321683permit
pernod9310453pernod
perrons93115483perrons
perry105222713perr_y
person83517873person
pert66759323p_er_t
petrol82714063petrol
pharaoh1545033pharaoh
pharos11312063pharos
phot95534363p__hot
picot95031013p_icot
pierrots1044963pierrots
pilot77435063p_ilot
pinot78737293p_inot
pirog83913673p_irog
pivot106523873p_ivot
plot66141233p__lot
pogrom1138593pogrom
porno75120653porno_
pornos85015253pornos
porrect1159743porrect
port66059633p_or_t
pot58078433p___ot
prao66229023p_rao_
praos74923563p_raos
prat65952043p__rat
preop94715873p_reop
preriot9316413preriot
prest75736353p_rest
print74837463p_rint
prion75119993p_rion
prior74316173p_rior
pro55837263p__ro_
proa66229963p__roa
prod76129503p__rod
prof96134663p__rof
prog75729003p__rog
prom87631703p__rom
proof105221533p_roof
prop85932813p__rop
pros65742783p__ros
prost75434103p_rost
prow97030383p__row
prutot8311823prutot
purest84021933purest
purist85525053purist
purport1159393purport
purr64925813purr__
purred94218073purred
purrs75320433purr_s
pyro96019393p_yro_
pyros105718293p_yros
pyrrole1246033pyrrole
pyrrols1235403pyrrols
ramrod936833ramrod
rarest65725483rarest
riot45947213__riot
root45655923__root
rot37282953___rot
ryot75528563__ryot
sabot7931783sa_bot
safrol937283safrol
sargo65424413sargo_
sargos74318273sargos
sarod65325873sa_rod
saros55238063sa_ros
sartor6313883sartor
sorrow9339443sorrow
spambot1345913spambot
sparest94616433sparest
sparred104512863sparred
sparrows1344803sparrows
sparry115111303sparr_y
taproot9412673taproot
tardo65321103tardo_
target75028903target
taro46846913ta_ro_
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarots66422993ta_rots
tarpon82812803tarpon
tarre55825633tarr_e
tarred74720283tarred
tarres64723043tarres
tarry85422513tarr_y
tart47566183ta_r_t
terret63425623terret
territ63421373territ
terror63811733terror
torot56139943_torot
trot46351313__trot
turbot8914263turbot
turret63121853turret
unroot6315553unroot
uproot8314123uproot
vagrom1235943vagrom
varlet9423503varlet
varoom11411413varoom
warrant10614243warrant
warred104019843warred
warren95012853warren
warrior1045363warrior
wart77866083wa_r_t
worrit92313313worrit
yarest95018913yarest
yarrows13277853yarrows

Search took 7 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.440406115.9
2DLD Change Limit1127165045.93618988.5
3Display Results5045040.1563230.8
 (SQL Overall)1786915046.53227356.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.