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

(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
noninflectional2071961noninflectional_
inflectional1754384___inflectional_
noninflationary2181304noninfl_ationary
connectional1646725con_n__ectional_
inflectionally2262955___inflectionally
nondirectional1763085non_directional_
nonfictional1754855no__nf_ictional_
nonfunctional1853765no__nfunctional_
noninfectious1862535noninf_ectio__us
confectionary2353776co__nf_ectionary
convectional1947046co__n_vectional_
inflection1547636___inflection___
inflections1646996___inflection__s
nonconventional20102596nonconventional_
nonelection1347206no__nelection___
nonelections1456396no__nelection__s
noninfective2054586noninf_ecti___ve
noninsecticidal2071006nonin_secticidal_
nonnational11107836non_n___ational_
nonnationals1294896non_n___ationals
nonreflecting1952416nonreflecti_n__g
omnidirectional20111116omnidirectional_
reflectional1753996___reflectional_
unidirectional1762126_unidirectional_
unintentional1363426_unin_tentional_
affectional1953897____affectional_
bidirectional18152497__bidirectional_
bifunctional19132867__bi_functional_
bisectional1554647__bi__sectional_
coinfecting1944577co_inf_ecti_n__g
conceptional1856917co__n_ceptional_
confection17411187co__nf_ection___
confectioner1964147co__nf_ection_er
confectioners2073377co__nf_ectioners
confectionery2362567co__nf_ectionery
confections18411397co__nf_ection__s
confessional17175467co__nf_essional_
confessionals18154177co__nf_essionals
conflictingly2461687co__nflicti_ngly
confliction1845237co__nfliction___
conflictions1945227co__nfliction__s
conjunctional2454167co__njunctional_
connection14410537con_n__ection___
connections15410707con_n__ection__s
connotational1554157con_n_otational_
constructional1854767con_structional_
contractional1756067co__ntractional_
conventional1757167co__n_ventional_
correctional1675327co___rrectional_
difunctional18123377__di_functional_
directional1445447__di__rectional_
disinfection1855107disinf_ection___
disinfections1954887disinf_ection__s
disinflationary2271367disinfl_ationary
genuflection1851617gen_uflection___
genuflections1951517gen_uflection__s
infection14410477___inf_ection___
infections15510237___inf_ection__s
infectiously2054087___inf_ectiously
inflationary1852747___infl_ationary
inflecting1646317___inflecti_n__g
infliction1545947___infliction___
inflictions1645447___infliction__s
insertional1147467___in_sertional_
insurrectional1662607_insurrectional_
intentional11128847___in_tentional_
interjectional23195607_interjectional_
intersectional16146257_intersectional_
nonconflicting2261927nonconflicti_n__g
nonconnection1784417nonconnection___
nonconnections1894147nonconnection__s
nondimensional1771497non_dimensional_
noneducational1762527non_educational_
nonelectrical1763487no__nelectrical_
nonelectronic1762757no__nelectron_ic
nonemotional1453787no__n_emotional_
nonfiction1546307no__nf_iction___
nonfictions1645937no__nf_iction__s
nonfunctioning207927no__nfunctioning
nonidentical1554337noni__denti_cal_
nonimplication20102857nonimplication___
nonimplications21122887nonimplication__s
noninclusion1461987nonincl_usion___
noninclusions1561797nonincl_usion__s
noninfected1752967noninf_ect____ed
noninformation1973317noninformation___
noninformations2073137noninformation__s
noninitial1056917nonin___iti__al_
nonintellectual17131547nonintellect__ual_
nonoccupational2171247nonoccupational_
nonoperational1663777non_operational_
nonprofessional2072137nonprofessional_
nonrational11109127no__n__rational_
nonsensational1463277non_sensational_
nontraditional1562637non_traditional_
nonvocational1853707no__nvocational_
postinfection20142637postinf_ection___
reinfection1645447_reinf_ection___
reinfections1745327_reinf_ection__s
solifluction1761257soli_fluction___
solifluctions18101147soli_fluction__s
unaffectionate2271247_un_affectionate
unintentionally1872747_unin_tentionally
vivisectional2162107__vivisectional_

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 Filter178691950240.360496363.9
2DLD Change Limit950241048.12611693.8
3Display Results1041040.0761368.4
 (SQL Overall)1786911048.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.