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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
conventionalist2012353(None) 
conventionalism22133151conventionalism
conventionality2393042conventionality
conventionalize29102732conventionalize
confessionalist2072523confessionalist
conventional1757163conventional___
conventionally2254983conventional_ly
confessionalism2272434confessionalism
convectional1947044convectional___
conventioneers1982394conventioneers_
conventions16410534convention___s_
antinationalist15163525_antinationalist
conceptional1856915conceptional___
conceptualist19164975concept__ualist
conditionality20113435con_ditionality
conditionals1554975con_ditional_s_
confectionaries22102335confectionaries
confessionals18154175confessional_s_
connectional1646725connectional___
contentions13412095contention___s_
contortionist15104425contortion__ist
convections18411495convection___s_
conventicles1954165conventi__cles_
convention15410565convention_____
conventioneer18152625convention__eer
conventuals1665165convent__ual_s_
conversional1755145conversional___
functionalist1865265fun__ctionalist
intentionality17113455_intentionality
nationalist111412165__n__ationalist
operationalist1664905_operationalist
sensationalist14235295sen_sationalist
unconventional1963125unconventional___
vocationalist1855105vo__cationalist
antirationalist15214426antirationalist
bioregionalist17112096biore_gionalist
centralist12511066c___ent__ralist
coalitionist1485506co_alition__ist
colonialist1376726co_lon_i__alist
commercialist21204686commerci__alist
conceptions17410596conception___s_
conceptualise19204826concept__ualise
conceptualism21134456concept__ualism
conceptualists20104076concept__ualists
concertinas15107556concerti_na__s_
concessionaire18142436concessiona_ire
concessional16195396concessional___
condensational1753656condensational___
conditional1447116con_ditional___
conditionally1954796con_ditional_ly
confectionary2353776confectiona__ry
confectioneries2292096confectioneries
confectioners2073376confection_ers_
confections18411396confection___s_
confessional17175466confessional___
confessionally22103516confessional_ly
congeniality1854616congen_i__ality
congestions1449316congestion___s_
conjunctional2454166conjunctional___
conjunctionally2972486conjunctional_ly
connections15410706connection___s_
consentingly1854666consenti_ngl__y
conservationist2084026conservation__ist
contention12412226contention_____
contentious1347016contentio___us_
contentiously1854176contentiousl__y
contentiousness1763556contentiousness
contortionists16103366contortion__ists
convection17411126convection_____
conveniences1986316conven_ien_ces_
conveniencies2074246conven_ien_cies
convenient1549056conven_ien____t
conveniently2054116conven_ientl__y
conventicle1854716conventi__cl__e
conventicler1962816conventi__cl_er
conventiclers2072096conventi__clers
conventing16311546conventi_n____g
conventual1546096convent__ual___
conventually2064896convent__ual_ly
conversational1954166conversational___
conversions1648276conversion___s_
convertibility2463276converti_bility
convertibles1954626converti__bles_
convertiplanes21112126convertiplanes_
convictions1848046conviction___s_
convocational2054476convocational___
cooperationist1864226cooperation__ist
correctional1675326correctional___
corruptionist1763036corruption__ist
creationist1379236c__reation__ist
credentialism1863826credenti__alism
educationalist1763286_educationalist
emotionalist14146876___emotionalist
essentialist1263876_essenti__alist
exceptionalism27112896_exceptionalism
functionalism2064566fun__ctionalism
functionalists1964366fun__ctionalists
intensionality17152956_intensionality
intentional11128846_intentional___
intentionally1655986_intentional_ly
inventions1348316_invention___s_
irrationalist1355816__irrationalist
nationalise111910486__n__ationalise
nationalism131910376__n__ationalism
nationalists122010336__n__ationalists
nonconventional20102596nonconventional___
nonnationals1294896non_national_s_
operationalism1864256_operationalism
operationalists1763886_operationalists
orientalist1197826_orient___alist
rationalist111812126____rationalist
regionalist1257226___re_gionalist
sectionalism1657106___sectionalism
sensationalise14254876sen_sationalise
sensationalism16264716sen_sationalism
sensationalists15244616sen_sationalists
traditionalist1593876_traditionalist
unmentionables1872006_unmentionables_
vocationalism2054416vo__cationalism
vocationalists1964086vo__cationalists

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 Filter178691950240.343520965.0
2DLD Change Limit950241207.59312514.7
3Display Results1201200.0931290.3
 (SQL Overall)1786911208.02922255.7
 
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.