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

159 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
nonvocational185370(None) 
convocational2054471convocational
invocational1754412_invocational
avocational1645183__avocational
collocational1753053collocational
connotational1554153connotational
consociational1853553consociational
convectional1947043convec_tional
convocation1847883convocation__
convocations1947363convocation_s
noneducational1762523noneducational
nonfictional1754853nonfic_tional
nonnational11107833non__national
nonrational11109123non__rational
prevocational2054013prevocational
vocational1546953___vocational
coeducational1853294coeducational
conformational21153714conformational
conjugational2353694conjugational
connectional1646724connec_tional
contractional1756064contractional
conventional1757164conv_entional
conversational1954164conversational
indicational1545754_indicational
innovational1553834_innovational
intonational1256004_intonational
invitational1554904_invitational
invocation1547544_invocation__
invocations1647064_invocation_s
involutional1553574_involutional
locational1246594___locational
navigational1653294n_avigational
nonemotional1453784non_emotional
nonfunctional1853764nonfunctional
nonnationals1294894non__nationals
nonoccupational2171244nonoccupational
nonoperational1663774nonoperational
nonsensational1463274nonsensational
notational1048124__n_otational
ovational1246854_o_v__ational
advocation1645745_advocation__
advocations1755415_advocation_s
annexational1953265_annexational
antinational1297485_antinational
antirational1278495_antirational
associational1552935_associational
avocation14168995__avocation__
avocationally21113695__avocationally
avocations15168685__avocation_s
binational1246375bin___ational
collocation1547175collocation__
collocations1646405collocation_s
combinational1984085combinational
compositional1974055compositional
computational1994575computational
conceptional1856915con_ceptional
concoction1348235concoc_tion__
concoctions1448255concoc_tion_s
condensational1753655condensational
conditional1447115con__ditional
condonation1448855condonation__
condonations1548005condonation_s
confirmational21153395confirmational
confrontational2071595confrontational
congregational1863435congregational
conjunctional2454165conjunctional
connotation1347985connotation__
connotations1447285connotation_s
conservational1955345conservational
consociation1648195consociation__
consociations1747515consociation_s
consolation13410985consolation__
consolations1449745consolation_s
conspirational1853965conspirational
convection17411125convec_tion__
convections18411495convec_tion_s
conversional1755145conv_ersional
conviction1748185convic_tion__
convictions1848045convic_tion_s
convolution1645125convolution__
convolutions1745195convolution_s
correctional1675325correc_tional
correlational15113675correlational
devotional1444675_devo__tional
educational1444875__educational
evocation142010295__evocation__
evocations15259875__evocation_s
explorational2252555explorational
foundational1652855fo_undational
functional15116675fun__c_tional
generational1354825gen_erational
gravitational1762555gravitational
informational1854345_informational
inhalational1553045_inhalational
invitationals1652745_invitationals
invocating1646335_invocati_n_g
irrotational1254025_irrotational
junctional19105365jun__c_tional
levitational1553635_levitational
monoclonal1453645mon_oc__lonal
motivational1753915mo_tivational
narrational1145445__narrational
national8311535__n___ational
negational1147155__n_egational
nonaction1149445non_ac_tion__
nonactions1248375non_ac_tion_s
nonagonal1055275non___a_gonal
nonbehavioral2171015nonbehavioral
noncapital1465505non__capi_tal
nonconventional20102595nonconventional
nondirectional1763085nondirectional
noneducation1554355noneducation__
nonfiction1546305nonfic_tion__
nonfictions1645935nonfic_tion_s
nonhormonal1652535nonho__rmonal
nonoptimal1453835non_o_pti_mal
nonpolitical1654575nonpoliti_cal
nonpractical1854235nonpracti_cal
nonrotating1246305nonrotati_n_g
nonseasonal1153525non_sea_sonal
nonsocial1148205nonsoc__i__al
nonsolution1154745nonsolution__
nonsolutions1254175nonsolution_s
nonspatial1255625non_spati__al
nonstationary1672135non_stationary
nontonal849745non____t_onal
nontraditional1562635nontraditional
nonvocal1346125nonvoc_____al
nonvolatile1453175nonvolati__le
nonvoting1346905nonvo__ti_n_g
notional849405__n_o__tional
novation111710015no_v__ation__
novations12139005no_v__ation_s
novocaine1442805no_voca_i_n_e
novocaines1552585no_voca_i_nes
nutational1047045__n_utational
occasional1453375_o__ccasional
occupational1883005_occupational
operational1347525_o_perational
oppositional1683845_oppositional
perorational1446395_perorational
populational1654415po_pulational
postulational1553915postulational
probational1547085__probational
pronunciational1971625pronunciational
provocation1847355provocation__
provocations1956875provocation_s
revocation15410815_revocation__
revocations16410315_revocation_s
rotational1048095___rotational
salvational1443715salv__ational
sensational1146385sen__sational
sonication12411185son_ication__
sonications1349955son_ication_s
unconventional1963125unconv_entional
vocation132311985___vocation__
vocationally20125005___vocationally
vocations141911425___vocation_s
volitional1345415___volitional

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901598.00015598.8
3Display Results1591590.1101445.5
 (SQL Overall)1786911598.50021022.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.