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

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

74 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
unprofessionals2072011unprofessionals_
unprofessional1962592unprofessional__
professionals1864043__professionals_
nonprofessional2072134nonprofessional__
processionals1754144__processionals_
professional1754964__professional__
professionalism22112714__professionalism
professionally2263184__professionally
subprofessional2271594subprofessional__
preprofessional2282035preprofessional__
processional1665395__processional__
processionally2163135__processionally
professionalize2972185__professionalize
professions1646635__profession__s_
confessionals18154176__confessionals_
expressional2164216expr__essional__
precessional1655126__precessional__
processions1548156__procession__s_
profession1546596__profession____
progressional1663966__progressional__
provisionals1753766__pro_visionals_
recessionals1453616___recessionals_
compressional1954267compr__essional__
confessional17175467__confessional__
confessionalism2272437__confessionalism
confessionalist2072527__confessionalist
confessionally22103517__confessionally
congressional1653517congr__essional__
congressionally2172137congr__essionally
depressions1447317depr__ession__s_
digressional1453177digr__essional__
expressionism2463367expr__ession_ism
expressionist2264047expr__ession_ist
expressionless2361927expr__essionless
expressions2086367expr__ession__s_
impressionable2062377impr__essionable
impressionism1963147impr__ession_ism
impressionist1763987impr__ession_ist
impressions1546827impr__ession__s_
ingressions1245497ingr__ession__s_
intercessional1663647intercessional__
introgressions1572857introgression__s_
intromissions15142797intromission__s_
introversions1663697introversion__s_
nonprofessorial20111197nonprofessorial__
oppressions1545727oppr__ession__s_
passionals1244807__p___assionals_
possessional1463647__possessional__
precessions1548557__precession__s_
presignals1363847__pr__e_signals_
procession1448417__procession____
processioned1753977__procession__ed
processioning1853747__procession_ing
professing16106627__professi_n___g
professorate1762957__profess_ora_te
professorates1862357__profess_orates
professorial1753667__professorial__
professorially2271887__professorially
professoriats1862807__professoriats_
professors1555257__profess_o__rs_
profusions1545257__prof_usion__s_
progressions1555557__progression__s_
projectional2355427__projectional__
proportionals1764027__proportionals_
provisional1655467__pro_visional__
provisionally2163167__pro_visionally
recessional1354987___recessional__
repressionist1555327repr__ession_ist
repressions1348967repr__ession__s_
retrocessions15114357retrocession__s_
suppressions1674047suppr__ession__s_
unidimensional1771307unidimensional__
unprofessed1752217unprofess_____ed
unpromisingly2161457unpro_misi_ngl_y

Search took 10 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.373479064.3
2DLD Change Limit95024748.92310649.3
3Display Results74740.0631174.6
 (SQL Overall)178691749.35919093.0
 
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.