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

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

72 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
noninteractive197302(None) 
noninteracting1762662noninteracting
counteractive2055953co_unteractive
interactive1659633___interactive
noninfective2054573noninfe__ctive
contractive1849514co__nt_ractive
noninductive1854184nonin__ductive
nonintersecting1871544nonintersecting
nonintrusive1562374nonint_r_usive
nonintuitive1563614nonint__uitive
nonnarrative1553834non_narra_tive
nonnegative1555164non_n_ega_tive
nonoperative1756264non_opera_tive
nonreactive1645934no__nre_active
nonretractile1562374nonret_ractile
nonretroactive1962034nonretroactive
alliterative1553875alli_tera_tive
concentrative2056205concent_ra_tive
confederative2253755confedera_tive
connective1749245con_n_e__ctive
constrictive1956615con_st_rictive
constructive1957425con_st_ructive
contractile1547335co__nt_ractile
contrastive1647295co__nt_rastive
counteracting1856285co_unteracting
counteraction1755385co_unteraction
disintegrative1962025disintegra_tive
distractive1746765__dist_ractive
integrative1547125___integra_tive
interacting14411715___interacting
interaction13411815___interaction
interactively2155175___interactively
interdictive1855315___interdictive
iterative12410715___i_tera_tive
nominative1597685nomin___a_tive
nonactive1448965no__n___active
nonassertive1553455nonasser__tive
noncoercive1854375non_coer_c_ive
nonconservative2372835nonconservative
nonconstructive2293445nonconstructive
noncooperative21113455noncoopera_tive
noncreative1648225non_cre_a_tive
nondeductive1953735no__ndeductive
nondestructive2072725nondestructive
nondirective1854655no__ndirective
nondistinctive2071915nondist_inctive
noneffective2363575noneffe__ctive
nonelective1666825no__n_elective
nonfigurative2062825nonfigura_tive
nonimitative1784535noni_mita_tive
nonintegrated1562715nonintegra_t_ed
nonintercourse167915nonintercourse
noninterest1155415noninterest___
nonintervention1871495nonintervention
noninvasive1772455nonin__va_sive
nonliterate1156185nonlitera_t__e
nonnative1248345non_n___a_tive
nonnormative1754855non_n_ormative
nonnutritive1563145non_nutr_itive
nonobjective2663525nonobje__ctive
nonradioactive2071405nonradioactive
nonrelative1456825no__nrela_tive
nonrestrictive1972585nonrestrictive
nonselective1755395no__nselective
obliterative1753055_oblitera_tive
overactive1847265_o___veractive
redintegrative1962185redintegra_tive
reintegrative17103255_reintegra_tive
reiterative1447535_rei_tera_tive
unattractive1752425_un_attractive
underactive1745955___underactive
uninstructive1862945_uninstructive

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.1101624463.6
2DLD Change Limit95024726.93613700.1
3Display Results72720.0461565.2
 (SQL Overall)178691727.09225196.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.