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

129 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
pardoners1220821(None) 
pardners11269191pard_ners
pardoner11189441pardoner_
gardeners1136602gardeners
hardeners1338082hardeners
padrones112711042padrone_s
parceners1337452parceners
pardner10239472pard_ner_
pardoned12189332pardone_d
pardons103817622pardon__s
parroters1156762parroters
partners102711132par_tners
abandoners1342473abandoners
adorers84411733_a_dorers
adorners9196623_a_dorners
almoners1068133_almoners
ardors74416873_ardo__rs
ardours8368883_ardo_urs
armorers10288973_armorers
atoners75013953_a_toners
baroness101210063bar_oness
baronets101410903bar_onets
burdeners1245063burdeners
carders104820353card__ers
cardons104519933cardon__s
careeners1138543careeners
carolers103314173car_olers
condoners122811513condoners
coroners104016223cor_oners
crayoners1444503crayoners
crooners103911393_crooners
darkeners1435153darkeners
darners83815773dar__ners
droners84114383_dr_oners
earners74016453ear__ners
falconers1445323falconers
gammoners1444563gammoners
gardener1037103gardener_
garners83815983gar__ners
garroters1055813garroters
handovers16136183handovers
harborers1446913harborers
hardcovers1943033hardcovers
hardener1238883hardener_
hardiness132310353hardiness
hardness122411083hard_ness
harkeners1636073harkeners
harpooners1543813harpooners
harrowers1555683harrowers
ironers74813553_ir_oners
jargoneers1842333jargoneers
jargonels1743153jargonels
jawboners21133053jawboners
ladrones92710973ladrone_s
landowners1443483landowners
larceners1135993larceners
larders83516943lard__ers
lardons83914493lardon__s
madrones112912283madrone_s
mariners103113863mar_iners
padders113312873pa_d_ders
paddlers12329153pa_ddlers
padrone102512073padrone__
panderers12229153panderers
panders103423733pand__ers
pandoors11258983pando_ors
pandores11312453pandore_s
pandours11317993pando_urs
panners93621273pa__nners
paraders113113113par_aders
paradores12259653paradore_s
paradors113411903parado__rs
paradoses122510253paradose_s
paradoxes19267293paradoxe_s
paranoeas1147523paranoeas
parcener1238473parcener_
pardine103616723pardine__
pardon94618733pardon___
pardoning1338763pardoning
parers85530743par___ers
parkers133816873par__kers
parleyers1444703parleyers
parlors9312913parlo__rs
parlours1036153parlo_urs
parodies11313693parodie_s
parolees104313983par_olees
paroles95025883par_ole_s
paronyms1546553par_onyms
parriers103612903par_riers
parrokets1543923parrokets
parroter1058203parroter_
parsers94118153par__sers
parsons93516873parson__s
partakers1536563partakers
partiers103514243par_tiers
partner92811393par_tner_
partons94620513parton__s
partyers13277763par_tyers
passovers14144753passovers
patroness1137483patroness
pawners124311073pa__wners
poisoners1146113poisoners
portioners1257413portioners
prawners1346003p_rawners
preeners102712813p_reeners
prisoners1147373prisoners
probers113514583p_r_obers
prodders1237463p_rodders
proofers13118363p_roofers
propers113619033p_r_opers
prosers94219643p_r_osers
provers123817793p_r_overs
pruners93710723p_r_uners
purloiners1242813purloiners
pyrones123113303pyr_one_s
ratooners965833ratooners
sardines92815563sardine_s
spadones1137253spa_done_s
tardiness10229913tardiness
waggoners1443183waggoners
wagoners1235473wa_goners
wantoners12116673wantoners
warders113416813ward__ers
warmongers1643633warmongers
warners103315563war__ners
warpowers1744553warpowers
warreners1236193warreners
yarders113211593yard__ers
yarners104312203yar__ners

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411297.45319943.8
3Display Results1291290.0931387.1
 (SQL Overall)1786911297.99922339.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.