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

106 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
professes143787(None) 
processes13310231processes
professed1545241professed
prowesses1437191prowesses
precesses13310462precesses
presses93523152pr__esses
prioresses1245702prioresses
processed1446802processed
processer1346892processer
processers1446002processers
profess1237712profe_s_s
professor1445032professor
professors1555252professors
progresses1347492progresses
prolepses13126192prolepses
prosses94019512pro__sses
proteases112110832proteases
proteoses112211012proteoses
proteuses11238992proteuses
baronesses1238913baronesses
confesses1438623confesses
cresses94219813cr__esses
crosses94220793cro__sses
dresses83716173dr__esses
drosses84513823dro__sses
drynesses1335363drynesses
fesses94820253___fesses
grosses84517683gro__sses
ironnesses1047833ironnesses
lionesses939433lionesses
loesses7310033_lo_esses
oyesses1037333__oyesses
patnesses111611793patnesses
patronesses1346473patronesses
peeresses1138473peeresses
pertnesses12310313pertnesses
phoresies1447993phoresies
poesies93217403p_o_esies
poetesses1137233poetesses
poornesses1236803poornesses
portresses1247313portresses
posses85128803p_o__sses
possesses1046323possesses
preblesses1445103preblesses
precessed1437523precessed
premisses13288763premisses
pressed103317313pr__essed
presser93717623pr__esser
pressers103215023pr__essers
pretenses112210593pretenses
primnesses1497803primnesses
princesses14206263princesses
prisses94816713pr__isses
process11310403proce_s_s
processor1346233processor
processors1446433processors
proclises1339543proclises
procuresses1543813procuresses
proettes10312763pro_ettes
profanes132311573prof_anes
professedly2091933professedly
professing16106623professing
profession1546593profession
professions1646633professions
profiles133211233prof_iles
profuse1237153prof_use_
progenies12314123progenies
prognoses1247533prognoses
progressed1445353progressed
prolapses13145573prolapses
prolepsis13125063prolepsis
promisees13246863promisees
promises122916763pro_mises
proneness11310443proneness
pronenesses1379263pronenesses
propenes122816513prope_nes
propense122410103propense_
prophases16411063prophases
prophesies17107893prophesies
proposes122515973pro_poses
proptoses1349873proptoses
proses84733473pro___ses
prosinesses13310853prosinesses
prossies101515223pro_ssies
protases102115033pro_tases
protease10209893protease_
protegees1275393protegees
proteges1149923prote_ges
proteides12238783proteides
proteomes13248653proteomes
proteose10229413proteose_
protested12159113protested
protester111510483protester
protesters12169383protesters
protests10310493prote_sts
protheses1449073protheses
proudnesses1447503proudnesses
provisoes1446653provisoes
prowess1237903prowe_s_s
purenesses12810743purenesses
recesses10312323_recesses
reprocesses1545153reprocesses
sprynesses1544973sprynesses
tresses73719543tr__esses
unprofessed1752213unprofessed
wrynesses1534843wrynesses

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.420425454.8
2DLD Change Limit1486411067.70319296.5
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.16921874.3
 
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.