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

34 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
intermittently196196(None) 
intermittency2062322intermitten_cy
intermittent1455322intermittent__
intermittence1772873intermitten_ce
intermittences1872693intermittences
intelligently1763034intelli_gently
intermitted1476504intermitte___d
intermittencies1961704intermittencies
intermitter1366194intermitte___r
intermitters1454604intermitte__rs
intermitting1547254intermittin__g
intromittent1462914intromittent__
impenitently1953015impe_ni_tently
impermanently2262105imperm_anently
impertinently2062765imperti_nently
incompetently2263485in_competently
inconsistently1962555inconsistently
inefficiently2462475in_efficiently
inherently1646255inher____ently
insistently1454245in___sistently
interestedly1653695inter_este_dly
interestingly1753995inter_estingly
interlinearly1663145interli_nearly
intermatted1476305intermatte___d
intermatting1547175intermattin__g
intermediately2062535intermediate__ly
interment11419225interm___ent__
interments12716215interm___ent_s
interminably1956435intermi__nably
intermingle1445765intermi___ngle
intermitotic1653115intermi_t_otic
interstitially1763185interstitially
persistently1752435__persistently
unremittingly1961795unre_mittingly

Search took 7 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.343520965.0
2DLD Change Limit95024346.12615511.6
3Display Results34340.0331030.3
 (SQL Overall)178691346.50227482.5
 
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.