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

78 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
confessionalism227243(None) 
confessionalist2072521confessionalist
confessionals18154172confessional_s_
confessional17175463confessional___
confessionally22103513confessional_ly
conventionalism22133153conventionalism
professionalism22112713professionalism
concessionaire18142434concessiona_ire
concessional16195394concessional___
confessions16136634confession___s_
conventionalist20123534conventionalist
concessionaires19171945concessionaires
concessionary2072935concessiona__ry
concessioners1753065concession_ers_
concessions15128105concession___s_
confectionaries22102335confectionaries
confession15126505confession_____
confusional1654245conf_usional___
congressional1653515congressional___
congressionally2172135congressional_ly
conventionality2393045conventionality
conventionalize29102735conventionalize
conversional1755145conversional___
professionalize2972185professionalize
professionals1864045professional_s_
bioregionalism1991796biore_gionalism
cohesionless1752016co_he_sion_less
commensalism1764956commens___alism
commercialism20184186commerci__alism
commissionaire2072096commissiona_ire
compassionates2062606compassionates_
compassionating2271936compassionating
compassionless2092106compassion_less
compressional1954266compressional___
conceptional1856916conceptional___
conceptualism21134456conce__ptualism
concession14148136concession_____
concessioner1653676concession___er
concussions15125326concussion___s_
conditionality20113436con_ditionality
conditionals1554976con_ditional_s_
confectionary2353776confectiona__ry
confectioneries2292096confectioneries
confectioners2073376confection_ers_
confections18411396confection___s_
confessing1647186confessi_n____g
confessors1544836confess_o___rs_
confusions1546306conf_usion___s_
congestions1449316congestion___s_
connectional1646726connectional___
connubialism1872006con_nubi__alism
convectional1947046convectional___
conventional1757166conventional___
conventionally2254986conventional_ly
conversions1648276conversion___s_
exceptionalism27112896_exceptionalism
expressionism2463366expression__ism
factionalism1987086___factionalism
functionalism2064566fun__ctionalism
impressionism1963146impression__ism
intensionality17152956_intensionality
nationalism131910376__n__ationalism
nonfissionable1962216nonfissiona_ble
obsessional1353346_obsessional___
obsessionally1862386_obsessional_ly
operationalism1864256_operationalism
personalism15137396___pers_onalism
possessional1463646possessional___
possessionless1471526possession_less
processionals1754146processional_s_
professional1754966professional___
professionally2263186professional_ly
recessionals1453616_recessional_s_
regionalism1455546___re_gionalism
secessionism1653446_secession__ism
sectionalism1657106___sectionalism
sensationalism16264716sen_sationalism
vocationalism2054416vo__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.343520965.0
2DLD Change Limit95024786.78014015.3
3Display Results78780.0461695.7
 (SQL Overall)178691787.16924925.5
 
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.