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

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

97 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
intentions1041140(None) 
indentions1149061indentions
intensions1048401intensions
intention9412011intention_
inventions1348311inventions
attentions1045982attentions
contentions13412092contentions
detentions11148802detentions
distentions12178842distentions
inattentions1252602inattentions
inceptions1448532inceptions
indention1049512indention_
infections15510232infections
ingestions1197592ingestions
injections1948662injections
insertions10410342insertions
intension948492intension_
intentional11128842intentional
intinctions1347002intinctions
intonations1149522intonations
intuitions1047292intuitions
invention1248332invention_
retentions101611112retentions
abstentions1364363abstentions
attention946103attention_
catenations1348363catenations
contention12412223contention_
contentious1347013contentious
conventions16410533conventions
detections131410043detections
detention10169543detention_
dissentions12168043dissentions
distensions12146273distensions
distention11158873distention_
extensions1746133extensions
ideations1039903i_deations
inactions1139323in_actions
inanitions1046383inanitions
inattention1152723inattention_
incautions1245973incautions
incenting12912063incenti_ng
incentives1578043incentives
inception1348693inception_
incretions1248653incretions
indentations1347883indentations
indenting11911263indenti_ng
indentors10278313indent_ors
indexations1946023indexations
indictions1339313indictions
inductions1348803inductions
infection14410473infection_
infectious1545603infectious
inflations13310323inflations
inflections1646993inflections
ingenious1046013ingen_ious
ingestion10137483ingestion_
inhesions12116123inhe_sions
initiations11410723initiations
injection1838653injection_
injunctions2044883injunctions
insentient1049423insentient
insertion9410593insertion_
inspections1546423inspections
integrations13129473integrations
intending1139983intendi_ng
intenerations1347463intenerations
intensional11146563intensional
intensives1347393intensives
intentness1047363intentness
intents72115703intent___s
interactions14410463interactions
interiors9513563inte_riors
interjoins1747953interjoins
interties9320333interti_es
intertills1048223intertills
interventions1657513interventions
intestine9411853intesti_ne
intestines10410253intestines
intimations13411883intimations
intinction1247783intinction_
intonation10410263intonation_
intrusions1046333intrusions
intubations1346833intubations
intuition947623intuition_
inunctions1246753inunctions
inventing13109973inventi_ng
inventors12288253invent_ors
inversions1347003inversions
invertins12911023inverti_ns
iterations10413823i_terations
lineations1039543lin_eations
mentions10312893__mentions
nitrations10312033nitrations
reinventions1554213reinventions
retention91611483retention_
sententious11104183sententious
tensions8310223__tensions

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 Filter1786911406030.406440125.6
2DLD Change Limit140603975.62624991.6
3Display Results97970.0462108.7
 (SQL Overall)178691976.07829399.6
 
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.