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

101 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
patroness113748(None) 
baroness101210062ba_roness
padrones112711042padrone_s
paltriness1244992paltriness
patness92912282pat__ness
patronesses1346472patronesses
patronise1198442patronise
patronises1298432patronises
patrons93818102patron__s
petronels1146062petronels
pythoness1743732pythoness
airiness8412213_airiness
apartness1146053apartness
aptness9268573apt__ness
artiness81615403_artiness
atoners75013953_at_oners
atones65225773_at_one_s
bareness10912813ba_reness
baronets101410903ba_ronets
battiness11239843battiness
canoness1039393ca_noness
cattiness112310633cattiness
darkness13247343da_rkness
datedness1187753datedness
estrones8313323estrone_s
fairness1136563fair_ness
farness102912203fa_r_ness
fatalness1245773fatalness
fatness103311293fat__ness
fattiness12239373fattiness
hairiness1238013hairiness
hardness122411083ha_rdness
harness102413933ha_r_ness
ladrones92710973ladrone_s
lateness82614073lat_eness
latrines8515013latrine_s
madrones112912283madrone_s
mateyness1444473mateyness
matiness102114753mat_iness
matrons93517633matron__s
narrowness1352643narrowness
natrons73215663natron__s
nattiness9239333nattiness
packness1636933pa_ckness
padrone102512073padrone__
padronism1445493padronism
padronisms1544883padronisms
paleness10312983pa_leness
paperiness1446133paperiness
pardners11269193pa_rdners
pardoners12208213pardoners
parolees104313983pa_rolees
paroles95025883pa_role_s
paronyms1546553pa_ronyms
parrokets1543923parrokets
parroters1156763parroters
partners102711133pa_rtners
partons94620513parton__s
pastiness112312353pastiness
pastness102510503pa_stness
patchiness1744933patchiness
pathless13138043pat_hless
pathogens1545713pathogens
pathoses13412773pathose_s
patines95225763pat_ine_s
patrollers1244813patrollers
patrols93513513patro__ls
patron84018043patron___
patronage1264823patronage
patronages1374973patronages
patronal1048653patron_al
patronised1395033patronised
patronize2077193patronize
patronizes2187393patronizes
patronly1344883patron_ly
patroons102710603patro_ons
pawkiness1835443pawkiness
peartness1137773peartness
pertness10310093p_ertness
petronel1048143petrone_l
pettiness1178703pettiness
pithiness1437563pithiness
poorness1036363poor_ness
pottiness1179703pottiness
process11310403p__rocess
profess1237713p__rofess
prowess1237903p__rowess
pureness101110183p_ureness
pyrones123113303p_yrone_s
rareness81112853ra_reness
ratooners965833ratooners
spareness1139863spa_reness
starkness1335963starkness
tarriness9229243tarriness
tartiness92112053tartiness
tartness82210133ta_rtness
tattiness9239413tattiness
trones65629283__trone_s
wariness11313213wa_riness
warmness1337063wa_rmness
wateriness1348073wateriness

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411017.11020905.9
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.57923577.1
 
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.