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 “professionalism” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
professionalism2211271(None) 
professionalize2972182professionalize
professionals1864042professional_s_
confessionalism2272433confessionalism
processionals1754143processional_s_
professional1754963professional___
professionally2263183professional_ly
confessionalist2072524confessionalist
processional1665394processional___
processionally2163134processional_ly
professions1646634profession___s_
unprofessionals2072014unprofessional_s_
bioregionalism1991795biore_gionalism
confessionals18154175confessional_s_
personalism15137395p___ers_onalism
precessional1655125precessional___
processioning1853745procession__ing
processions1548155procession___s_
profession1546595profession_____
professorates1862355profess_orates_
progressional1663965progressional___
protectionism1984945protection__ism
provisionals1753765pro_visional_s_
recessionals1453615_recessional_s_
regionalism1455545_r__e_gionalism
unprofessional1962595unprofessional___
bioregionalisms2091666biore_gionalisms
bioregionalist17112096biore_gionalist
confessional17175466confessional___
confessionally22103516confessional_ly
conventionalism22133156conventionalism
emotionalism16185756emo___tionalism
exceptionalism27112896_exceptionalism
expressionism2463366expression__ism
factionalism1987086___factionalism
impressionism1963146impression__ism
irrationalism1555116ir__rationalism
nonprofessional2072136nonprofessional___
operationalism1864256__operationalism
passionals1244806p___assional_s_
perfectionism2253986perfection__ism
personalise1367106p___ers_onalise
personalisms1676096p___ers_onalisms
personalist1399426p___ers_onalist
possessional1463646possessional___
possessionless1471526possession_less
precessions1548556precession___s_
preprofessional2282036preprofessional___
presignaling1652856pr__e_signaling
presignals1363846pr__e_signal_s_
pretensionless1661246pretension_less
processibility2363056processi_bility
procession1448416procession_____
processioned1753976procession___ed
professing16106626professi_n____g
professorate1762956profess_ora__te
professorial1753666profess_o__rial
professorially2271886professorial_ly
professoriat1764006profess_o__riat
professoriates1961966professoriates_
professoriats1862806profess_oriats_
professors1555256profess_o___rs_
professorship23112646profess_orshi_p
professorships24112526profess_orships
profusions1545256prof_usion___s_
progressions1555556progression___s_
progressivism2162346progressi___vism
projectional2355426projectional___
projectionist2485256projection__ist
proportionality2272236proportionality
proportionals1764026proportional_s_
protectionisms2094026protection__isms
protectionist17116686protection__ist
provincialism22102436provinci__alism
provisional1655466pro_visional___
provisionally2163166pro_visional_ly
rationalism131910236_r___ationalism
recessional1354986_recessional___
regionalisms1555066_r__e_gionalisms
regionalist1257226_r__e_gionalist
secessionism1653446_secession__ism
sectionalism1657106___sectionalism
subprofessional2271596subprofessional___
traditionalism17113596tr_aditionalism
vocationalism2054416_vo_cationalism

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 Filter178691950240.360496363.9
2DLD Change Limit95024856.92013731.8
3Display Results85850.0631349.2
 (SQL Overall)178691857.34324334.9
 
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.