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

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

135 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
conversational195416(None) 
condensational1753652condensational
conservational1955342conservational
conversation1747802conversation__
conversations1847452conversation_s
conversional1755142convers__ional
compensational2073523compensational
confirmational21153393confirmational
conformational21153713conformational
congregational1863433congregational
convectional1947043conve__ctional
conventional1757163conve__ntional
conversazione2761913conversazion_e
conversaziones2861663conversaziones
conversazioni2761653conversazion_i
convocational2054473conv_ocational
nonsensational1463273nonsensational
conceptional1856914conce__ptional
concessional16195394conce_s_sional
condensation1546784condensation__
condensations1646274condensation_s
confessional17175464confe_s_sional
congressional1653514congres_sional
conjugational2353694con_jugational
connectional1646724conne__ctional
connotational1554154con_notational
conservation1749404conservation__
conservations1849094conservation_s
consociational1853554consociational
conspirational1853964conspirational
constructional1854764constructional
contractional1756064con_tractional
conversion1548424convers__ion__
conversions1648274convers__ion_s
correlational15113674corre_lational
generational1354824gen_er_ational
international1357674_international
nonoperational1663774nonoper_ational
nonrational11109124non__r_ational
nonvocational1853704nonv_ocational
observational1853184_observational
operational1347524_o_per_ational
unsensational1353664_unsensational
aberrational1453485__aberrational
annexational1953265_anne_xational
antirational1278495_antir_ational
coacervation1964275coacervation__
coacervations2053875coacervation_s
coeducational1853295co_educational
collocational1753055co_llocational
combinational1984085co_mbinational
compensation18126505compensation__
compensations19136185compensation_s
compositional1974055co_mpositional
compressional1954265compres_sional
computational1994575co_mputational
concertina14410635concer__ti_na_
concertinas15107565concer__ti_nas
condemnation1746045condemnation__
condemnations1845405condemnation_s
conditional1447115con___ditional
conferential1755395conferenti__al
confessionals18154175confe_s_sionals
configurational2162205configurational
confirmation1946185confirmation__
confirmations2055675confirmation_s
conformation1947325conformation__
conformations2046725conformation_s
confrontational2071595confrontational
confusional1654245con_fus__ional
congelation14410345conge_lation__
congelations1549735conge_lation_s
congestion1349045conge_s_tion__
congestions1449315conge_s_tion_s
congregation16226765congregation__
congregations17186415congregation_s
conjunctional2454165con_junctional
conjuration2049515conjur_ation__
conjurations2148495conjur_ation_s
consecration1649785consecration__
consecrations1749215consecration_s
conservationist2084025conservationist
conservatorial1972245conservatorial
consternation15106365consternation__
consternations16116045consternation_s
constitutional1663095constitutional
contestation1448665contestation__
contestations1547745contestation_s
conurbation1547465con_urbation__
conurbations1646665con_urbation_s
convection17411125conve__ction__
convections18411495conve__ction_s
convention15410565conve__ntion__
conventionally2254985conve__ntionally
conventions16410535conve__ntion_s
conversance1876325conversa___nce
conversancy2163805conversa___ncy
conversant1548215conversa___n_t
conversing16310545convers__i_n_g
converting16313135conver__ti_n_g
convocation1847885conv_ocation__
convocations1947365conv_ocation_s
cooperation15410025cooper_ation__
cooperations1659195cooper_ation_s
correctional1675325co__rrectional
covariation1646775co_variation__
covariations1745985co_variation_s
dispensational1762505dispensational
dissertational1562575dissertational
hyperrational2153935_hyperrational
informational1854345_informational
insertional1147465_inser__tional
interactional1557005_interactional
internationals1454245_internationals
intersectional16146255_intersectional
invitational1554905_inv_itational
invocational1754415_inv_ocational
malversation1752725malversation__
malversations1852565malversation_s
narrational1145445__n_arrational
negational1147155__n_e_gational
nondirectional1763085nondirectional
noneducational1762525noneducational
nonemotional1453785non_e_motional
nonnational11107835non___national
nonpersonal13114435nonpers___onal
orientational1353805_orientational
ovational1246855_o_v___ational
overemotional1861925_o_veremotional
reversional1454035_revers__ional
sensational1146385___sensational
supernational1555615_supernational
unconventional1963125unconve__ntional
variational1444785___variational
versional1245865___vers__ional

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.356501941.0
2DLD Change Limit950241356.86013851.9
3Display Results1351350.0961406.3
 (SQL Overall)1786911357.31224438.0
 
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.