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

112 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
pennoned113631(None) 
cannoned11118142cannoned
pennated11299542pennated
penned94217612pe_n_ned
pennine93712952pennine_
pennines103112042pennines
pennon8310642pennon__
pennoncel1343252pennoncel
pennons939712pennon_s
pensioned1246652pensioned
pinioned1137512pinioned
tenoned839362te_noned
annoyed1185873_annoyed
beaconed1336983beaconed
beckoned1735783beckoned
besnowed14124413besnowed
cantoned111411523cantoned
censored11197953censored
centones10313663centones
condoned122612023condoned
connoted1138863connoted
deaconed1237493deaconed
deboned113411633de_boned
denned84215633de_n_ned
denoted93512763de_noted
deponed113712873de_poned
encoded1139033_encoded
encored10412103_encored
endowed1248173_endowed
engined9119893_engined
enjoined16215723_enjoined
enjoyed1834523_enjoyed
ennobled1143833_ennobled
enrobed10279253_enrobed
hennaed1135103henn_aed
intoned8811993_intoned
kenned114411273ke_n_ned
kenneled1334003kenneled
keynoted1642783keynoted
lesioned936903lesioned
lessoned945393lessoned
mentioned1246833mentioned
mentored1138003mentored
neoned7311483__neoned
opinioned1243273opinioned
panned94123433p_an_ned
pardoned12189333pardoned
peened94318163pe__ened
peined94918843pe__ined
penanced1338163penanced
penciled1337823penciled
pended103819013pe_n_ded
pennae84314033penn_ae_
penname11328553penname_
pennames12287793pennames
pennant9312493pennan_t
pennants1037063pennants
pennate93314033pennate_
penne75423853pe_n_ne_
penner84616663pe_n_ner
pennies94218813penn_ies
penning103616493pennin_g
pennoncels1452163pennoncels
penoncel1244843penoncel
pensione1039773pensione_
pensioner1146663pensioner
pensiones11410003pensiones
pentane9415743pentane_
pentanes10316083pentanes
pentene9313793pentene_
pentenes10315633pentenes
pentode1039893pentode_
pentodes11310363pentodes
pentose9311593pentose_
pentoses10312893pentoses
peones83821043pe__ones
peptone11310763peptone_
peptones12311033peptones
perniones1148593perniones
pernod9310453perno__d
petioled1137993petioled
petronel1048143petronel
phoned124014553p__honed
pinbone1138183pinbone_
pinbones1238143pinbones
pinkened1535753pinkened
pinnated11338553pinnated
pinned94818383p_in_ned
pinniped1343853pinniped
pinones94717073p_inones
planned103810153plan_ned
poisoned1136953poisoned
prisoned1138813prisoned
proponed132412033proponed
punned93416193p_un_ned
reasoned9410733reasoned
reckoned1546953reckoned
reconned113610653reconned
redonned10297103redonned
renowned1235983renowned
rezoned173611163re_zoned
seasoned948113seasoned
tenoner739683te_noner
tensioned1045613tensioned
unboned103014223_unboned
unnoted8311363_unnoted
unzoned172310653_unzoned
venomed1336653ve_nomed
wantoned12117223wantoned
weaponed1445493weaponed
winnowed1543473winnowed
yenned10409383ye_n_ned

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.406440125.6
2DLD Change Limit1461621127.12320519.7
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.57523589.6
 
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.