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

150 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
parroter105821(None) 
garroter956591garroter
parroted1158851parroted
parroters1156771parroters
barrater10310152barrater
carrotier1146622carrotier
garrote8510112garrote_
garroted1056792garroted
garroters1055822garroters
garrotes969382garrotes
harrower1446372harrower
narrater838722narrater
narrower1145072narrower
pardoner11189442pardoner
parrier93717652parr_ier
parroket1449212parroket
parrot8320662parrot__
parrots9312742parrot_s
parroty1247862parrot_y
aborter939933_aborter
adroiter946193_adroiter
approver15105303approver
arbiter939933_arbiter
armorer9259913_armorer
arrayer10136703_arrayer
arrester839253_arrester
arriver10117793_arriver
arrowed1148133_arrowed
balloter1078893balloter
barraters1138043barraters
barrator1048403barrator
barrener1038343barrener
barretor1046713barretor
barrier94017753barr_ier
barrister1145733barrister
barter85525383ba_r_ter
borrower1384843borrower
burrower1374273burrower
caroler93816753ca_roler
carrier93619583carr_ier
carromed1338573carromed
carrot8423123carrot__
carrotin102210893carrotin
carrots9714623carrot_s
carroty1248943carrot_y
carryover1742733carryover
carter84932273ca_r_ter
cavorter1335783cavorter
darter75320363da_r_ter
fagoter1135883fa_goter
farrier103514893farr_ier
farrowed1545303farrowed
ferreter1136543ferreter
furrower1464043furrower
garote7717953ga_rote_
garoted9710133ga_roted
garotes8614573ga_rotes
garotter965953garotter
garreted1057523garreted
garrotte965693garrotte
garrotted1164133garrotted
garrottes1065493garrottes
garter74420513ga_r_ter
harborer1348063harborer
harrier104417763harr_ier
harrowed1556283harrowed
harrowers1555693harrowers
larruper1042753larruper
marketer1437383marketer
marrer83716673marr__er
marrier93817523marr_ier
marrowed1445993marrowed
narrate7313493narrate_
narrated9310333narrated
narraters946703narraters
narrates8312763narrates
narrator847563narrator
narrowed1235233narrowed
padrone102512073padrone_
padrones112711043padrones
painter93814563pa_inter
palter84423263pa__lter
parader103914863pa_rader
parameter1349123parameter
parcener1238473parcener
pardner10239473pa_rdner
pardoned12189333pardoned
pardoners12208213pardoners
parented11912213parented
parer75839903pa_r__er
pargeted1238683pargeted
parietes10714543parietes
parker124121373pa_r_ker
parleyer1335633parleyer
parlor8312673parlo__r
parlour937263parlo_ur
parole84425253pa_role_
paroled104217633pa_roled
parolee94119653pa_rolee
paroles95025883pa_roles
parotic112518043pa_rotic
parotid102915513pa_rotid
parred95024073parr__ed
parrel84515983parr__el
parried103615723parr_ied
parriers103612903parr_iers
parries93925843parr_ies
parritch1543543parritch
parrokets1543923parrokets
parroting1239153parroting
parser84822373pa_r_ser
partaker1436873partaker
parted94228683pa_r_ted
partier93520713pa_rtier
partite9317133partite_
partner92811393pa_rtner
partyer12337873pa_rtyer
passover13135533passover
paster85734373pa__ster
pater74740723pa___ter
patroller1145743patroller
patter84628263pa__tter
pearter9412743pear_ter
peripter1278753peripter
perter84422283p_er_ter
porter84224413p_or_ter
prater84825353p__rater
prester93519623p_rester
printer93917303p_rinter
prober104516073p__rober
promoter12311453promoter
proofer12149103p_roofer
proper104319953p__roper
proser84223463p__roser
protea82214763p__rotea
protei82615313p__rotei
prover113819723p__rover
prower114218123p__rower
pyrrole1246033pyrrole_
pyrroles1345453pyrroles
rioter64817283__rioter
rooter64926033__rooter
sorrower1165053sorrower
sparrier10329143sparr_ier
tarrier74323173tarr_ier
tarter64023563ta_r_ter
uprooter1085243uprooter
warpower1645053warpower
warranter1245203warranter
warrener1136923warrener

Search took 9 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.420425454.8
2DLD Change Limit1461621507.75018859.6
3Display Results1501500.0632381.0
 (SQL Overall)1786911508.23321704.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.