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

128 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
nonfunctional185376(None) 
conjunctional2454162conjunctional
nonfictional1754852nonf_ictional
bifunctional19132863_bifunctional
difunctional18123373_difunctional
dysfunctional2261803dysfunctional
functional15116673___functional
nonfunctioning207923nonfunctioning
nonnational11107833non__national
cofunction1745254co_function__
cofunctions1845014co_function_s
confusional1654244confu__sional
conjugational2353694conjugational
conjunction2245624conjunction__
conjunctionally2972484conjunctionally
conjunctions2345384conjunction_s
conjunctival2662244conjuncti_val
connectional1646724con_nectional
contractional1756064contractional
convectional1947044con_vectional
conventional1757164conven_tional
inflectional1754384_inflectional
junctional19105364___junctional
nondirectional1763084nondirectional
noneducational1762524noneducational
nonemotional1453784non_emotional
nonfiction1546304nonf_iction__
nonfictions1645934nonf_iction_s
noninflectional2071964noninflectional
nonnationals1294894non__nationals
nonrational11109124non__rational
nonsensational1463274nonsensational
nonvocational1853704nonvocational
affectional1953895__affectional
antinational1297485_antinational
coeducational1853295coeducational
cognitional1454275co__gnitional
combinational1984085combinational
communicational2383075communicational
compunction19115905compunction__
compunctions20145695compunction_s
computational1994575computational
conceptional1856915con_ceptional
condensational1753655condensational
conditional1447115con__ditional
conduction1549965condu_ction__
conductions1649665condu_ction_s
confection17411185conf_ection__
confectionary2353775conf_ectionary
confectioner1964145conf_ectioner
confections18411395conf_ection_s
confessional17175465conf_essional
configurational2162205configurational
confirmational21153395confirmational
confliction1845235confliction__
conflictions1945225confliction_s
conformational21153715conformational
confrontational2071595confrontational
confutation1668725confutation__
confutations1767795confutation_s
conjunctiva2552925conjuncti_va_
conjunctivae2652225conjuncti_vae
conjunctivas2662145conjuncti_vas
connotational1554155connotational
constructional1854765constructional
convocational2054475convocational
correctional1675325co_rrectional
definitional1653035_definitional
disfunction1754715disfunction__
disfunctions1854525disfunction_s
dysfunction2052255dysfunction__
dysfunctions2152135dysfunction_s
factional1478765___f_actional
fictional1477805___f_ictional
foundational1652855fo__undational
fractional1547135___fractional
frictional1546255___frictional
function1337845___function__
functionally2054975___functionally
functionary1953755___functionary
functioned1643995___functioned
functions1437745___function_s
hyperfunctional2881355hyperfunctional
injunction1945095_injunction__
injunctions2044885_injunction_s
instructional1555095instru_ctional
intentional11128845_inten_tional
intonational1256005_intonational
intuitional1155295_intu_itional
inunction1146895_in_unction__
inunctions1246755_in_unction_s
malfunction1852805malfunction__
malfunctioned2161345malfunctioned
malfunctions1952665malfunction_s
misfunction1853945misfunction__
misfunctioned2161715misfunctioned
misfunctions1953715misfunction_s
multifunctional2271505multifunctional
nonaction1149445non__action__
nonactions1248375non__action_s
nonconventional20102595nonconventional
nonelection1347205nonelection__
nonelections1456395nonelection_s
nonfactual1553545nonf_act__ual
nonfinal1147705nonf____i_nal
nonhunting1444685nonhun_ti_n_g
noninitial1056915non_initi__al
nonmunicipal1861925nonmunici_pal
nonoccupational2171245nonoccupational
nonoperational1663775nonoperational
nonpractical1854235nonpracti_cal
nontonal849745no___n_t_onal
nontraditional1562635nontraditional
nonunion845585non_un__ion__
nonunions945585non_un__ion_s
notational1048125no___tational
notional849405no_____tional
nutational1047045__n_utational
occupational1883005_occupational
populational1654415po_pulational
postulational1553915postulational
productional1794715produ_ctional
pronunciational1971625pron_unciational
reductional1454595_redu_ctional
reflectional1753995_reflectional
suctional1147685___su_ctional
unconventional1963125unconven_tional
unintentional1363425uninten_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 Limit1247901288.06315476.9
3Display Results1281280.0931376.3
 (SQL Overall)1786911288.56220870.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.