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

194 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
parroted115885(None) 
garroted1056791garroted
parroter1058211parroter
arrowed1148132_arrowed
carromed1338572carromed
farrowed1545302farrowed
garoted9710132ga_roted
garreted1057522garreted
garrote8510112garrote_
garroter956592garroter
garrotes969382garrotes
garrotted1164132garrotted
harrowed1556282harrowed
marrowed1445992marrowed
narrated9310332narrated
narrowed1235232narrowed
pardoned12189332pardoned
parented11912212parented
pargeted1238682pargeted
paroled104217632pa_roled
parotid102915512pa_rotid
parred95024072parr__ed
parried103615722parr_ied
parroket1449212parroket
parrot8320662parrot__
parroters1156772parroters
parrots9312742parrot_s
parroty1247862parrot_y
parted94228682pa_r_ted
aborted10310423_aborted
aerated85322383_aerated
airted74214503_air_ted
approved16115073approved
aproned10311503_aproned
arbored103811603_arbored
armored102610473_armored
arrased8149873_arrased
arrayed11117163_arrayed
arrested939163_arrested
arrived11127353_arrived
arrogated11147143_arrogated
aurated83817793_aurated
azoted16388593_a_zoted
balloted1189043balloted
barraged1297703barraged
barrater10310153barrater
barred95725803barr__ed
barreled1137853barreled
borrowed1465053borrowed
burrowed1444463burrowed
carboyed1637183carboyed
caroled103717693ca_roled
caromed123713623ca_romed
carotid102014833ca_rotid
carpeted1338953carpeted
carried103717153carr_ied
carrot8423123carrot__
carrotier1146623carrotier
carrotin102210893carrotin
carrots9714623carrot_s
carroty1248943carrot_y
carted98631443ca_r_ted
cartoned111312833cartoned
cavorted1435693cavorted
charioted1595873charioted
corroded12147513corroded
darted84620923da_r_ted
enrooted977433enrooted
faggoted1443103faggoted
fagoted1236073fa_goted
farted105121783fa_r_ted
ferreted1236333ferreted
furrowed1563853furrowed
garote7717953ga_rote_
garotes8614573ga_rotes
garotted1066193garotted
garred85217413garr__ed
garroters1055823garroters
garrotte965693garrotte
garrottes1065493garrottes
harbored1438643harbored
harried113815543harr_ied
harrower1446373harrower
jargoned1735233jargoned
jarred144613253jarr__ed
lariated91212063lariated
larruped1142873larruped
marketed1537323marketed
marooned1138563marooned
marred95421043marr__ed
married104715303marr_ied
marted94425213ma_r_ted
mirrored1145773mirrored
narrate7313493narrate_
narrater838723narrater
narrates8312763narrates
narrower1145073narrower
packeted17148283packeted
padrone102512073padrone_
padrones112711043padrones
painted104214633pa_inted
paired95017523pair__ed
palleted1139873palleted
palmated132511003palmated
palpated13249763palpated
panted95024823pa__nted
paraded114014263pa_raded
paragoned1357063paragoned
parapeted1446483parapeted
parasoled1246353parasoled
parbaked1735503parbaked
parboiled1445223parboiled
parceled1338343parceled
parched154013693pa_rched
pardoner11189443pardoner
pared86946763pa_r__ed
parged104922043pa_r_ged
pargetted1345663pargetted
parietes10714543parietes
parked134425143pa_r_ked
parlayed1435823parlayed
parled94626293pa_r_led
parleyed1436243parleyed
parodied1238343parodied
parole84425253pa_role_
parolee94119653pa_rolee
paroles95025883pa_roles
parotic112518043pa_rotic
parotids112610413pa_rotids
parotoid11410033pa_rotoid
parqueted2144223parqueted
parrel84515983parr__el
parrier93717653parr_ier
parries93925843parr_ies
parritch1543543parritch
parrokets1543923parrokets
parroting1239153parroting
parsed96323893pa_r_sed
parslied1137823parslied
partied103516553pa_rtied
partite9317133partite_
pasted94426903pa__sted
pastored1139973pastored
pated85237843pa___ted
patented1188893patented
patriated1238543patriated
patrolled1245713patrolled
patted94724683pa__tted
permuted1336713permuted
perorated12412473perorated
picoted1239213p_icoted
picrated132110113picrated
piloted10310323p_iloted
pirated102515613p_irated
pivoted1336513p_ivoted
pogromed1444813pogromed
ported94223243p_or_ted
prated94924923p__rated
printed104016373p_rinted
probed114114823p__robed
promoted13310543promoted
proofed13138723p_roofed
prorated11513713prorated
prosed94921103p__rosed
protea82214763p__rotea
protei82615313p__rotei
proteid103513673p__roteid
protend104012793p__rotend
proved125016033p__roved
purported1443463purported
purposed1335273purposed
purred94218073purr__ed
pyrrole1246033pyrrole_
pyrroles1345453pyrroles
rioted73416373__rioted
rooted75424003__rooted
serrated92513433serrated
sorrowed1264843sorrowed
sparred104512863sparr__ed
targeted1037483targeted
tarred74720283tarr__ed
tarried83914133tarr_ied
tarted74923373ta_r_ted
tartrated1096653tartrated
turreted935373turreted
unrooted9810513unrooted
uprooted1186393uprooted
variated121211393variated
varoomed1445293varoomed
wardrobed1662533wardrobed
warranted1345013warranted
warred104019853warr__ed
warted104223233wa_r_ted
worrited1235743worrited

Search took 8 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.436409841.7
2DLD Change Limit1461621947.43619656.0
3Display Results1941940.0802425.0
 (SQL Overall)1786911947.95222471.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.