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

81 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
nonterminating177312(None) 
contaminating1854903cont_aminating
exterminating2373853_exterminating
terminating1447333___terminating
consternating1654974conster__nating
contemplating2054124conte_mplating
germinating1546164___germinating
inseminating1554554_inse_minating
intermingling1763044_intermingling
intermitting1547254_intermi_tting
nominating1349494no____minating
nonirritating1472514non_irritating
nonterminal1355304nontermina___l
nonterminals1453634nontermina__ls
alternating1245715_alter__nating
codetermination2062125codetermination
conglutinating1862415conglutinating
contamination1766955cont_amination
contaminations1886105cont_aminations
contaminative2054375cont_aminative
contemning1577065conte_m_n__ing
contenting13313325conte___n_ting
contributing1754305cont_r_ibuting
coordinating1653905co__ordinating
countermanding2053745counterman_ding
counterpointing2063035counterpoin_ting
countersinking2163485countersin_king
counterstating1755195counter_stating
deaminating1547975___deaminating
decontaminating2162755decont_aminating
denominating1645685den__ominating
determination1657645_determination
determinations1766885_determinations
determinative1954075_determinative
determining1545295_determin__ing
disseminating1754055disse_minating
dominating1449395do____minating
extermination2275745_extermination
exterminations2365125_exterminations
extermining2154045_extermin__ing
geminating1447755___ge_minating
glycerinating2061455glycer_inating
incriminating1854165_incriminating
indetermination1863135indetermination
indoctrinating1862045indoct_r_inating
intercalating1656505_intercalating
interdicting1647455_interdi_cting
interknitting1853285_interknitting
interlining1249135_interlin__ing
interlinking1755055_interlin_king
intermatting1547175_interm_atting
intermediating1853985_intermediating
intermixing2146615_intermi__xing
interplanting1655345_interplanting
interpolating1657795_interpolating
interrelating1457295_interrelating
interrogating1556665_interrogating
intimidating1654745_int_imidating
masterminding1961165mastermin_ding
noncirculating1961755noncirculating
nondemanding1752465nonde_man_ding
nonderivative2063505nonder_ivative
nondrinking1753415non_dr_in_king
nonintimidating1971465nonintimidating
nonoperating1555405nonoper___ating
nonrioting1146755non__r_i_oting
nonrotating1246305non__r_otating
nonthinking1953515nont__hin_king
overmanaging1953735_o_vermanaging
overmining1649115_o_vermin__ing
pontificating2153755pont_ificating
potentiating1554285po_tenti_ating
pretermination1854775pretermination
preterminations1954295preterminations
pretermitting1852555pretermi_tting
recontaminating2062755recont_aminating
renominating1546415ren__ominating
termination131311165___termination
terminations14149755___terminations
terminative1656135___terminative
undermining1546365_undermin__ing

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.1061685764.2
2DLD Change Limit95024817.80012182.6
3Display Results81810.0601350.0
 (SQL Overall)178691817.96622431.7
 
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.