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

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

104 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
convectional194704(None) 
connectional1646721connectional
conventional1757161conventional
conceptional1856912conceptional
convection17411122convection__
convections18411492convection_s
conversional1755142conversional
convocational2054472convocational
correctional1675322correctional
concessional16195393concessional
conditional1447113con_ditional
confection17411183confection__
confectionary2353773confectionary
confectioner1964143confectioner
confections18411393confection_s
confessional17175463confessional
conjunctional2454163conjunctional
connection14410533connection__
connections15410703connection_s
contractional1756063contractional
convecting18310433convecti_n_g
convention15410563convention__
conventionally2254983conventionally
conventions16410533convention_s
conversational1954163conversational
conviction1748183conviction__
convictions1848043conviction_s
nonfictional1754853nonfictional
nonvocational1853703nonvocational
unconventional1963123unconventional
affectional1953894_affectional
bisectional1554644_bisectional
coeducational1853294coeducational
cognitional1454274co_gnitional
coitional1148694co___itional
collection1448204collection__
collections1547934collection_s
collocational1753054collocational
conception16410454conception__
conceptions17410594conception_s
concertina14410614concerti_na_
concertinas15107554concerti_nas
concoction1348234concoction__
concoctions1448254concoction_s
condensational1753654condensational
conditionals1554974con_ditionals
conduction1549964conduction__
conductions1649664conduction_s
confecting18310554confecti_n_g
confectioners2073374confectioners
confectionery2362564confectionery
confessionals18154174confessionals
confusional1654244con_fusional
congestion1349044congestion__
congestions1449314congestion_s
congregational1863434congregational
congressional1653514congressional
conjectural2253474conject_ural
conjugational2353694conjugational
connecting15310384connecti_n_g
connotational1554154connotational
consecution1547314consecution__
consecutions1647054consecution_s
conservational1955344conservational
consociational1853554consociational
constructional1854764constructional
contention12412224contention__
contentions13412094contention_s
convective2049114convecti__ve
convector1648084convect_o__r
convectors1768314convect_o_rs
conventing16311544conventi_n_g
conventionalism22133154conventionalism
conventionalist20123534conventionalist
conventionality2393044conventionality
conventionalize29102734conventionalize
conventioneer18152624conventioneer
conventual1546094convent__ual
conversion1548424conversion__
conversions1648274conversion_s
converting16313134converti_n_g
convicting1847584convicti_n_g
convocation1847884convocation__
convocations1947364convocation_s
correction1448814correction__
corrections1548864correction_s
correlational15113674correlational
directional1445444_directional
functional15116674fun__ctional
inflectional1754384inflectional
insertional1147464_insertional
intentional11128844_intentional
invocational1754414_invocational
junctional19105364jun__ctional
nonconventional20102594nonconventional
nondirectional1763084nondirectional
nonemotional1453784nonemotional
nonfunctional1853764nonfunctional
nonnational11107834non_national
nonrational11109124non_rational
ovational1246854_o_v_ational
projectional2355424projectional
reflectional1753994reflectional
sectional1149424___sectional

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 Filter1786911247900.406440125.6
2DLD Change Limit1247901046.59318927.7
3Display Results1041040.0631650.8
 (SQL Overall)1786911047.06225303.2
 
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.