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

133 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
indirection145638(None) 
indirections1556191indirections
codirection1644742codirection
direction1289782__direction
indiction1239812indi__ction
indigestion1353752indigestion
misdirection1754162misdirection
redirection1446052redirection
codirections1744703codirections
directions1379643__directions
incretion1149053in_cre_tion
indention1049513ind__ention
indication13312033indi_cation
indictions1339313indi__ctions
indigestions1453643indigestions
indignation1346533indignation
indirect1147523indirect___
indirectly1653403indirect_ly
indiscretion1552803indiscre_tion
induction1248983ind__uction
induration11410613indur_ation
infarction1545793infar_ction
infection14410473in__fection
inflection1547633in_flection
infraction1557453in_fraction
injection1838653in__jection
inspection1446663in_spection
instruction13137943instruction
insurrection14104383insurrection
interaction13411813interaction
interjection2198923interjection
intersection14610183intersection
intinction1247783inti_nction
misdirections1854233misdirections
redirections1546173redirections
addiction13146014addi__ction
advection1545554_ad_vection
antifriction1773984antifriction
antirejection2283214antirejection
bidirectional18152494bidirectional
bijection20134794__bijection
bilection13156804__bilection
bisection13136984__bisection
codirecting1743644codirecting
codirector1553274codirect_or
correction1448814_correction
defection151610644__defection
dejection19178664__dejection
detection121310414__detection
diction102313054__di__ction
digestion1146574__digestion
directing1338824__directing
directional1445444__directional
directive1557774__directive
director1147784__direct_or
dissection13158614__dissection
erection102115514___erection
ideation9310494i_d__eation
imperfection2154044imperfection
imprecation1746544i_mprecation
inaction1039624in___action
inattention1152724inattention
incarnation1347464incarnation
inception1348694in__ception
incineration1446294incineration
incitation12312224inci_tation
incretions1248654in_cre_tions
incurvation1646984incurvation
indagation1246154ind_agation
indecision1344414ind__ecision
indentation1248374indentation
indentions1149064ind__entions
indexation1846344ind_exation
indications14310974indi_cations
indicting1339614indi__cting
indictor1147464indi__ct_or
indignations1446044indignations
indigotin1144194indi_goti_n
indirectness1552914indirectness
indiscretions1652584indiscre_tions
inductions1348804ind__uctions
indurations1249584indur_ations
inebriation1357244inebriation
infarctions1645024infar_ctions
infections15510234in__fections
infixation2047534infi_xation
inflections1646994in_flections
infliction1545944in_fliction
information16147714information
infractions1646964in_fractions
infuriation1448244infuriation
ingestion10137484in__gestion
ingression1145514in_gression
inhibition1545344inhi_bition
initiation10412104in_itiation
injections1948664in__jections
injunction1945094in_junction
innervation1447444innervation
inscription1544954inscription
insertion9410594in__sertion
insinuation11137264insinuation
inspections1546424in_spections
inspiration1348374inspir_ation
instructions14137814instructions
insurrections15104144insurrections
intellection1466164intellection
intention9412014in__tention
interactions14410464interactions
interception1649394interception
interdiction1568144interdiction
interjections2277994interjections
intersections1598964intersections
intervention1568384intervention
intimation12413044inti_mation
intinctions1347004inti_nctions
introjection2156204introjection
inunction1146894in__unction
invention1248334in__vention
invitation13410024invi_tation
iodination1159984iodi_nation
midsection1544434mid_section
misdirecting1853244misdirecting
nidification1847454nidification
nondirectional1763084nondirectional
nondirective1854684nondirective
predilection1754104predilection
redigestion1384154redigestion
redirecting1545614redirecting
trisection1245984_trisection
undirected1445024undirect_ed
unidirectional1762124unidirectional
vindication1746354vindi_cation
vivisection1952704vivisection

Search took 9 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191338.29617938.6
3Display Results1331330.0801662.5
 (SQL Overall)1786911338.79920308.1
 
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.