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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

59 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
nonfictional175485(None) 
nonfiction1546302nonfiction__
nonfictions1645932nonfiction_s
nonfunctional1853762nonfunctional
conditional1447113condi_tional
connectional1646723connectional
convectional1947043convectional
fictional1477803___fictional
nondirectional1763083nondirectional
nonemotional1453783nonemotional
nonnational11107833non_national
nonrational11109123non_rational
nonvocational1853703nonvocational
affectional1953894_affectional
cognitional1454274cogni_tional
coitional1148694co__i_tional
conceptional1856914conceptional
conditionals1554974condi_tionals
confection17411184confection__
confectionary2353774confectionary
confectioner1964144confectioner
confections18411394confection_s
confessional17175464confessional
confirmational21153394confirmational
confliction1845234confliction__
conflictions1945224confliction_s
confusional1654244conf_usional
conjunctional2454164conjunctional
contractional1756064contractional
conventional1757164conventional
conviction1748184conviction__
convictions1848054conviction_s
convocational2054474convocational
correctional1675324correctional
dictional1268614___dictional
factional1478764___factional
frictional1546254__frictional
functional15116674fun__ctional
indicational1545754_indicational
inflectional1754384_inflectional
junctional19105364jun__ctional
metafictional2071264metafictional
nonaction1149444non_action__
nonactions1248374non_action_s
noneducational1762524noneducational
nonfactual1553544nonfact__ual
nonfilial1246264nonfi_li__al
nonfinal1147704nonf___i_nal
nonfissionable1962214nonfissionable
noninflectional2071964noninflectional
nonnationals1294894non_nationals
nontonal849744non___t_onal
notational1048124no__tational
notional849404no____tional
nutritional1154784nutri_tional
officinal1743544_offic_i_nal
positional1247904po_si_tional
unconditional1663464uncondi_tional
volitional1345414vo_li_tional

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.406440125.6
2DLD Change Limit124790598.18615244.3
3Display Results59590.0301966.7
 (SQL Overall)178691598.62220725.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.