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

183 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
parroty124786(None) 
carroty1248941carroty
parrot8320661parrot_
parrots9312741parrots
arrowy12288272_arrowy
carrot8423122carrot_
carrots9714622carrots
garrote8510102garrote
marrowy15236082marrowy
parity114719872pa_rity
parody12410092pa_rody
parroted1158842parroted
parroter1058202parroter
parry105323752parr__y
party106630612pa_r_ty
argosy1036423_argosy
argot67728653_argot_
argots74116033_argots
armory114211473_armory
array86317143_arr_ay
arroba898663_arroba
arrow83414883_arro_w
arrows92813483_arrows
arroyo936963_arroyo
arty77531313_a_r_ty
barony115915303ba_rony
barratry13114473barratry
barret84930483barret_
barretry13115183barretry
barrets94917103barrets
barroom1139373barroom
barrow114512763barro_w
barrows123411683barrows
carboy134914183carbo_y
carroch1437093carroch
carrom10513403carro_m
carroms11512403carroms
carrotin102210893carrotin
carry105823783carr__y
corrody13136143corrody
faggoty1542863faggoty
farrow12309973farro_w
farrows13259783farrows
ferrety13287013ferrety
furrowy16384473furrowy
gargety12388043gargety
garote7717953ga_rote
garret74426553garret_
garrets84413623garrets
garron73113493garro_n
garrons82713463garrons
garroted1056783garroted
garroter956573garroter
garrotes969363garrotes
garrotte965683garrotte
harlot94422803harlot_
harlotry1443403harlotry
harlots103413293harlots
harmony1538173harmony
harrow122610773harro_w
harrows132611033harrows
harry115322953harr__y
jargony1834493jargony
karroo10410013karro_o
karroos1139313karroos
maggoty1444013maggoty
marmot10318743marmot_
marmots11311513marmots
marron83717543marro_n
marrons93216973marrons
marrow112812603marro_w
marrows122911823marrows
marry104821693marr__y
narrate7313493narrate
narrow9269143narro_w
narrowly1442903narrowly
narrows10258843narrows
padrone102512073padrone
padroni10278613padroni
painty114714753pa_inty
panty105929303pa__nty
parboil1138323parboil
pardon94618733pardo_n
pardons103817623pardons
pardy115523953pa_r_dy
parent83230423parent_
parents93418123parents
pareo74632603pareo__
pareos87023773pareo_s
parget94529393parget_
pargets105215193pargets
pargo86723723pargo__
pargos95719043pargo_s
parkway1934553parkway
parlay113713993pa_rlay
parley116718353pa_rley
parlor8312673parlo_r
parlors9312913parlors
parlour937263parlour
parlous9414293parlous
parol74826273pa_ro_l
parole84425253pa_role
parols84722613pa_rols
paronym1437503pa_ronym
parotic112518043pa_rotic
parotid102915513pa_rotid
parous84024163pa_rous
parr65731153parr___
parral85517533parr_al
parrals94414573parrals
parred95024073parr_ed
parrel84515983parr_el
parrels94713493parrels
parried103615723parried
parrier93717653parrier
parries93925843parries
parring103222063parring
parritch1543543parritch
parroket1449203parroket
parrokets1543923parrokets
parroters1156763parroters
parroting1239153parroting
parrs75928673parr__s
parsley1247793parsley
parson83817903parso_n
parsons93516873parsons
part65967463pa_r_t_
partita9310863partita
partite9317133partite
partly116315473pa_rtly
parton84720993parto_n
partons94620513partons
partook1337313partook
parts77743373pa_r_ts
partway1535923partway
parvo107719183parvo__
parvos116614753parvo_s
pasty105725053pa__sty
patriot9314533patriot_
patriots1038053patriots
patrol83213023patro_l
patrols93513513patrols
patron84018043patro_n
patronly1344883patronly
patrons93818103patrons
patroon92811973patroon
patty104723613pa__tty
paty95234563pa___ty
paucity1435823paucity
paughty16294323paughty
payroll1245613payroll
peroxy1838243p_eroxy
perron83216623perro_n
perrons93115483perrons
perry105222713perr__y
pierrot948833pierrot_
pierrots1044963pierrots
pretty11510873p_retty
priory114110263p_riory
prosy106319253p__rosy
protyl11308213p__rotyl
proxy175011013p__roxy
purity114114913p_urity
purty105019403p_ur_ty
pyrrol1136273pyrro_l
pyrrole1246033pyrrole
pyrrols1235403pyrrols
rarity93615493ra_rity
rooty86423023__rooty
sparrow1234263sparro_w
sparrows1344803sparrows
sparry115111303sparr__y
sparsity1345463sparsity
tarot55943933ta_rot_
tarots66422993ta_rots
tarry85422513tarr__y
tarty86328183ta_r_ty
variety1337743variety
varsity1356673varsity
warranty1465043warranty
warty119323823wa_r_ty
yarrow12287933yarro_w
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 Filter1786911340270.1431249587.4
2DLD Change Limit1340271836.62320236.6
3Display Results1831830.0632904.8
 (SQL Overall)1786911836.82926166.5
 
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.