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

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

68 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
processionally216313(None) 
professionally2263181professionally
processional1665392processiona_l_
processionals1754142processiona_ls
precessional1655123precessiona_l_
professional1754963professiona_l_
professionals1864043professiona_ls
provisionally2163163pro_visionally
successionally2161443successionally
confessionally22103514confessionally
erosionally1454664ero___sionally
obsessionally1862384_obsessionally
occasionally1952754__occasionally
probationally2054094pro_bationally
procession1448414procession____
processioned1753974procession__ed
processioning1853744procession_ing
processions1548154procession___s
professionalism22112714professionalism
professionalize2972184professionalize
professorially2271884professorially
progressional1663964progressiona_l_
proportionally2163494proportionally
recessional1354984_recessiona_l_
recessionals1453614_recessiona_ls
recessionary1753064_recessiona_ry
accessional15103605_accessiona_l_
avocationally21113695avoc_ationally
collisionally1862115_collisionally
concessional16195395concessiona_l_
concessionary2072935concessiona_ry
congressionally2172135congressionally
dimensionally1962355_dimensionally
exceptionally2753525_exceptionally
extensionally2362885_extensionally
fractionally2055295frac__tionally
frictionally2054925fric__tionally
intensionally1654395_intensionally
locationally17124715_loc_ationally
personally1546945p___ers_onally
positionally1754925p_o_sitionally
possessional1463645possessiona_l_
precession1448825precession____
precessions1548555precession___s
prepositionally2262515prepositionally
pressingly1646005pr__essi_n_gly
procedurally2081925proce__durally
processable1753045process___able
processibility2363055processibility
processible1754005processi___ble
processing15108185processi_n___g
profession1546595profession____
professions1646635profession___s
projectional2355425projectiona_l_
proleptically2256005prolepti_cally
pronominally1954165pro_nomi_nally
proportionably2362565proportionably
prosaically1847845pro__sai_cally
proverbially2252125proverbi__ally
provisional1655465pro_visiona_l_
provisionals1753765pro_visiona_ls
provisionary2073245pro_visiona_ry
regionally1445535_r__e_gionally
successional1672745successiona_l_
torsionally1453875_to__rsionally
unprofessional1962595unprofessiona_l_
unprofessionals2072015unprofessiona_ls
vocationally20125005_voc_ationally

Search took 7 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.390458182.1
2DLD Change Limit95024686.34314980.9
3Display Results68680.0461478.3
 (SQL Overall)178691686.77926359.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.