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

436 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
parrots931274(None) 
carrots9714621carrots
parrot8320661parrot_
parroty1247861parroty
argots74116032_argots
arrows92813482_arrows
barrets94917102barrets
barrows123411682barrows
carroms11512402carroms
carrot8423122carrot_
carroty1248942carroty
farrows13259782farrows
garrets84413622garrets
garrons82713462garrons
garrote8510102garrote
garrotes969362garrotes
harlots103413292harlots
harrows132611032harrows
karroos1139312karroos
marmots11311512marmots
marrons93216972marrons
marrows122911822marrows
narrows10258842narrows
pardons103817622pardons
parents93418122parents
pareos87023772pareo_s
pargets105215192pargets
pargos95719042pargo_s
parlors9312912parlors
parlous9414292parlous
parols84722612pa_rols
parous84024162pa_rous
parrals94414572parrals
parrels94713492parrels
parries93925842parries
parrokets1543922parrokets
parroted1158842parroted
parroter1058202parroter
parroters1156762parroters
parrs75928672parr__s
parsons93516872parsons
partons94620512partons
parts77743372pa_r_ts
parvos116614752parvo_s
patriots1038052patriots
patrols93513512patrols
patrons93818102patrons
perrons93115482perrons
pierrots1044962pierrots
pyrrols1235402pyrrols
sparrows1344802sparrows
tarots66422992ta_rots
yarrows13277852yarrows
abbots1039283_abbots
aborts84916183_aborts
across8312643_across
afrits9311903_afrits
airts55626343_air_ts
allots64019173_allots
apricots1275393apricots
aprons8316993_aprons
arbors84717883_arbors
ardors74416873_ardors
argols74514613_argols
argons75018203_argons
argot67728653_argot_
arhats9312973_arhats
armets84918353_armets
armors85017813_armors
arras55626133_arr_as
arrays95311683_arrays
arrest63722633_arrest
arrests73312683_arrests
arris56824683_arr_is
arroba898663_arroba
arrobas969213_arrobas
arrow83414883_arro_w
arrowy12288273_arrowy
arroyo936963_arroyo
arroyos1036533_arroyos
arsons63917213_arsons
arts49650263_a_r_ts
arvos86015663_arvo_s
ascots85312513_ascots
aurous64119263_aurous
ballots94116033ballots
barbets114915843barbets
barbuts11439843barbuts
barhops14288113barhops
barlows12259973barlows
barons85025383ba_rons
barrels94514363barrels
barrens94414323barrens
barres84427543barr_es
barret84930483barret_
barrios9310773barrios
barroom1139373barroom
barrooms1237893barrooms
barrow114512763barro_w
baryons121010473baryons
borrows12349253borrows
burbots1168673burbots
burros85114993burro_s
burrows12399093burrows
cahoots1238473cahoots
carats85929023ca_rats
carbons115418943carbons
carbos105122263carbo_s
carboys144711783carboys
cardons104519933cardons
carets85330773ca_rets
cargoes104415223cargoes
cargos94619183cargo_s
carhops14329703carhops
carious93320283carious
carnets93918403carnets
carobs104818103ca_robs
carols85124983ca_rols
caroms105619573ca_roms
carpets113915333carpets
carports1238943carports
carrels95117303carrels
carries94328013carries
carrions10312453carrions
carroch1437093carroch
carrom10513403carro_m
carrotin102210893carrotin
carrotins11239963carrotins
carrs75730853carr__s
carryons1337103carryons
carryouts1443443carryouts
cartons94122473cartons
carts78946293ca_r_ts
cavorts1237933cavorts
chariots1339393chariots
charros124312143charro_s
cirrous93111063cirrous
dacrons103211033dacrons
darts67635733da_r_ts
eardrops1165303eardrops
earshots1146623earshots
enroots738713enroots
ergots74512373_ergots
errors63311313_errors
faggots1234863faggots
fagots1039963fa_gots
faros85532023fa_ro_s
farrow12309973farro_w
farts88336843fa_r_ts
ferrets103111393ferrets
ferrous1049793ferrous
furrows13327793furrows
galiots82311323galiots
galoots82410793galoots
garcons102411643garcons
gargets94614573gargets
garnets84115403garnets
garote7717953ga_rote
garotes8614563ga_rotes
garret74426553garret_
garron73113493garro_n
garroted1056783garroted
garroter956573garroter
garroters1055813garroters
garrotte965683garrotte
garrottes1065483garrottes
gavots1038113ga_vots
griots74713643_griots
grots65025853__grots
hadrons113314303hadrons
harbors12412413harbors
haricots1347333haricots
harlot94422803harlot_
harries103525493harries
harrow122610773harro_w
harts88441593ha_r_ts
heriots10312063heriots
horrors1078693horrors
jabots1538883ja_bots
jargons1558203jargons
jarrahs1735453jarrahs
karats106420493ka_rats
karoos102415803ka_roos
kaross101910013ka_ross
karroo10410013karro_o
karsts106012943ka_rsts
karts97630113ka_r_ts
labrets939363labrets
ladrons83813193ladrons
lardons83914493lardons
largos74815063largo_s
lariats7615053lariats
larrups934733larrups
macrons113514893macrons
macros104017013macro_s
maggots1136563maggots
magots9312363ma_gots
markets133314033markets
marmot10318743marmot_
maroons92615553maroons
marplots1245633marplots
marrams11310123marrams
marrers93414313marrers
marries93825283marries
marron83717543marro_n
marrow112812603marro_w
marrowy15236083marrowy
marts77442233ma_r_ts
mascots113910343mascots
matrons93517633matrons
merlots92710123merlots
mirrors938623mirrors
morros83714673morro_s
morrows12318723morrows
narcos86714203narco_s
narrate7313493narrate
narrates8312763narrates
narrow9269143narro_w
natrons73215663natrons
packets155114773packets
pacts95125803pa__cts
padres95016983padr_es
padrone102512073padrone
padrones112711043padrones
padroni10278613padroni
paeons83915523pa_eons
pagods105310193pa_gods
paints85921833pa_ints
pairs75325833pair__s
pakoras1337473pakoras
paletots1047803paletots
palets85122313pa_lets
pallets93919303pallets
pallors9314363pallors
pandits103914213pandits
pantos85222743panto_s
pants76536923pa__nts
papists112110453papists
pappous1057463pappous
parades104121463parades
paradors113411903paradors
parados103816053parados
paradrops1444963paradrops
paragons11311503paragons
paramos113213513paramos
parangs104314373parangs
parapets1239763parapets
paraphs1439313paraphs
paras76143043pa_r_as
parasols1039263parasols
parboil1138323parboil
parboils1237433parboils
parcels113712663parcels
parches143720003parches
pardahs13289673pardahs
pardon94618733pardo_n
pards85634333pa_r_ds
parent83230423parent_
pareo74632603pareo__
parers85530743pa_rers
pares77164483pa_r_es
pareses94718883pareses
paresis93315093paresis
pareus85420743pa_reus
parfaits1346913parfaits
parges94529543pa_rges
parget94529393parget_
pargo86723723pargo__
pariahs123812343pariahs
parians93519733parians
paries84742513pa_ries
parietes10714543parietes
parings104219213parings
paris75145943pa_r_is
parises94827183parises
parity114719873pa_rity
parkas125018023pa_rkas
parkers133816873parkers
parks116134463pa_r_ks
parlays123910453parlays
parles86334403pa_rles
parleys125212373parleys
parlor8312673parlo_r
parlour937263parlour
parlours1036153parlours
parodos103011753parodos
parody12410093pa_rody
parol74826273pa_ro_l
parole84425253pa_role
paroles95025883paroles
parotic112518043pa_rotic
parotid102915513pa_rotid
parotids112610413pa_rotids
parquets1936413parquets
parr65731153parr___
parral85517533parr_al
parred95024073parr_ed
parrel84515983parr_el
parried103615723parried
parrier93717653parrier
parriers103612903parriers
parring103222063parring
parritch1543543parritch
parroket1449203parroket
parroting1239153parroting
parry105323753parr__y
pars67560793pa_r__s
parsecs11429923parsecs
parsers94118153parsers
parses85534703pa_rses
parson83817903parso_n
part65967463pa_r_t_
partans94418283partans
parties93230863parties
partita9310863partita
partitas10310253partitas
partite9317133partite
partlets102811513partlets
parton84720993parto_n
partook1337313partook
party106630613pa_r_ty
paruras9310533paruras
parures9512693parures
parvis116114803pa_rvis
parvo107719183parvo__
paseos88015813paseo_s
pastors94119003pastors
pasts75936503pa__sts
patents94815203patents
pathos115516693patho_s
patios85221783patio_s
patois84319363pa_tois
patriot9314533patriot_
patrol83213023patro_l
patron84018043patro_n
patroon92811973patroon
patroons102710603patroons
pats66460853pa___ts
paviors1237603paviors
pawnors12297203pawnors
payors114312643pa_yors
payouts1247303payouts
payroll1245613payroll
payrolls1344753payrolls
pedros9312183pedro_s
pereons92815003pereons
peridots1138323peridots
periods10312243periods
permits11314003permits
pernods1038483pernods
perries93226603perries
perron83216623perro_n
persons93717013persons
petrols92913083petrols
petrous92714423petrous
pharaohs1644493pharaohs
pharos11312063pharo_s
phots105418503p__hots
picots104616443p_icots
pierrot948833pierrot_
pilots84018873p_ilots
pinots85920273p_inots
pivots115111903p_ivots
plots75025673p__lots
pogroms1237643pogroms
pornos85015253porno_s
porous84419483p_orous
ports75934593p_or_ts
pots66452363p___ots
praos74923563p_rao_s
prats76333393p__rats
preops104911943p_reops
prests84021263p_rests
prints84320103p_rints
prions84317783p_rions
priors83914483p_riors
proas75028803p__roas
prods85523553p__rods
profs105120893p__rofs
progs86624153p__rogs
proms95426413p__roms
proofs114511683p_roofs
props95726883p__rops
pros65742783p__ro_s
pross76529403p__ross
prost75434103p__rost
prows106327013p__rows
purists94014073purists
purports1265783purports
purrs75320433purr__s
pyros105718293p_yro_s
pyrrol1136273pyrro_l
pyrrole1246033pyrrole
pyrroles1345453pyrroles
ramrods1036583ramrods
riots54922013__riots
roots55933673__roots
rots46454093___rots
ryots85313783__ryots
sabots8314703sa_bots
safrols1036863safrols
sarcous9312933sarcous
sargos74318273sargo_s
sarods74918573sa_rods
saros55238063sa_ro_s
sartors7314963sartors
sorrows10278403sorrows
spambots1443313spambots
sparrow1234263sparro_w
taproots1047253taproots
targets84314223targets
tarocs84615663ta_rocs
taroks106115283ta_roks
taros55640823ta_ro_s
tarot55943933ta_rot_
tarpons92612213tarpons
tarres64723043tarr_es
tarries73324263tarries
tarts57242023ta_r_ts
terrets72913583terrets
territs72714503territs
terrors73112213terrors
trots56629943__trots
turbots988023turbots
turrets73010673turrets
unroots738563unroots
uproots937143uproots
various103113103various
varlets10411573varlets
varooms1248883varooms
warrants1168503warrants
warrens103810893warrens
warriors1135363warriors
warts814840403wa_r_ts
worrits10258683worrits
yarrow12287933yarro_w

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 Filter1786911340270.1731032896.0
2DLD Change Limit1340274366.56320421.6
3Display Results4364360.1562794.9
 (SQL Overall)1786914366.89225927.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.