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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
interception164939(None) 
interceptions1758181interceptions
intercepting1748872intercepting
interceptor15156542intercept_or
intercession14226442intercession
interjection2198922interjection
interruption1466402interruption
intersection14610182intersection
intervention1568382intervention
apperception1793463apperception
inception1348693in___ception
intellection1466163intellection
interaction13411813inter_action
intercalation1557083intercalation
intercept13410963intercept___
intercepted16157723intercept_ed
intercepter15127913intercept_er
intercepters16126393intercepters
interceptors16115733interceptors
intercepts1448633intercept__s
intercessions15225883intercessions
interdiction1568143interdiction
interjections2277993interjections
interoceptive2074453interoceptive
interoceptor16134533interocept_or
interrelation1358733interrelation
interruptions1565733interruptions
intersections1598963intersections
intersession12175813intersession
interstation12410413interstation
interventions1657513interventions
misperception2162873misperception
perception1688613__perception
altercation1347014alterc_ation
apperceptions1893034apperceptions
contraception1953754contraception
deception1448324__de_ception
exception2046854___exception
imperceptive2352944imperceptive
imperfection2154044imperfection
incarceration1753564incarceration
inceptions1448534in___ceptions
incorruption1653354incorruption
incretion1149054in_cr_e_tion
indirection1456384indir_ection
infarction1545794infarc__tion
infection14410474infe_c__tion
injection1838654inje_c__tion
innervation1447444inner_vation
inscription1544954inscr_iption
insertion9410594inser___tion
insurrection14104384insurrection
integration121310494inte_gration
intellections1565394intellections
inteneration1248624inteneration
intention9412014int___ention
interactions14410464inter_actions
intercalations1655914intercalations
interceding1568044interce_ding
intercessional1663644intercessional
intercessor1354334interce_ssor
interchain1546634interc_hai_n
interconnection1963124interconnection
intercutting1545944intercutting
interdictions1667494interdictions
interelectron1564134interelectron
interesting12411124inter_esting
interferon1346844interfe__ron
interfertile1556424interfertile
interfusion1464984inter_fusion
interjecting2248394interjecting
interjectional23195604interjectional
interjector2055434interject_or
interleukin1554454interleuki_n
interlineation1455404interlineation
intermediation17105214intermediation
intermedin1347444interme_di_n
intermission1464654intermission
interneuron1154074interne_uron
interoceptors17144034interoceptors
interpellation1665614interpellation
interpolation1558554interpolation
interposition1586054interposition
interpretation16115864interpretation
interrelations1457614interrelations
interrogation1457864interrogation
interrupting1546244interrupting
interruptive1754324interruptive
interruptor13114054interrupt_or
intersecting1549714intersecting
intersectional16146254intersectional
intersessions13195284intersessions
interspersion1564394interspersion
interunion1046254inter__union
intinction1247784intinc__tion
introjection2156204introjection
iteration9515034i_ter__ation
misperceptions2262484misperceptions
perceptions1798194__perceptions
reception13410324__re_ception
unperceptive2163074unperceptive
winterization25137814winterization

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901026.95317947.6
3Display Results1021020.0631619.0
 (SQL Overall)1786911027.40624127.9
 
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.