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

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

95 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
interdiction156814(None) 
interdictions1667491interdictions
interaction13411812inter_action
interdicting1647452interdicting
interdictive1855312interdictive
interdictor1454742interdict_or
interjection2198922interjection
intersection14610182intersection
indiction1239813in___diction
intellection1466173intellection
interactions14410463inter_actions
interception1649393interception
interdict12410213interdict___
interdicted1546223interdict_ed
interdictors1554453interdictors
interdictory1853763interdictory
interdicts1347083interdict__s
interjections2277993interjections
intermediation17105213intermediation
intermission1464653intermission
interruption1466403interruption
intersections1598963intersections
interstation12410413interstation
intervention1568383intervention
introduction1555783introduction
antifriction1773984antifriction
benediction1643324bene_diction
contradiction1854564contradiction
imperfection2154044imperfection
incardination1655034incardination
indication13312034in___dication
indictions1339314in___dictions
indirection1456384indir_ection
induction1248984in___duction
inebriation1357244in_ebriation
infarction1545794infar__ction
infection14410474infe___ction
infliction1545944in__fliction
infraction1557454in_fr_action
infuriation1448244infur_iation
injection1838654inje___ction
innervation1447444inner_vation
inscription1544954inscr_iption
insertion9410594inser___tion
instruction13137944instr_uction
insurrection14104384insurrection
integration121310494inte_gration
intellections1565394intellections
inteneration1248624inteneration
intention9412014inte___ntion
interacting14411714inter_acting
interactional1557004inter_actional
interactive1659634inter_active
interanimation16136014interanimation
intercalation1557084intercalation
interceptions1758184interceptions
intercession14226444intercession
interdiffusion21132074interdiffusion
interdigitation1763144interdigitation
interdistrict1662364interdistrict
interdominion1662634interdominion
interelectron1564134interelectron
interfusion1464984inter_fusion
interjecting2248394interjecting
interjectional23195604interjectional
interjector2055434interject_or
interlineation1455404interlineation
intermediations1894424intermediations
intermissions1594144intermissions
intermitting1547254intermitting
internucleon1451844internucleon
interpolation1558554interpolation
interposition1586054interposition
interrelation1358734interrelation
interrogation1457864interrogation
interruptions1565734interruptions
intersecting1549714intersecting
intersectional16146254intersectional
intersession12175814intersession
interunion1046254inter__union
interventions1657514interventions
intimidation1547364intimidation
intinction1247784int__inction
intoxication21156354int_oxication
introductions1655134introductions
introjection2156204introjection
intuition947624int__ui_tion
iteration9515034i_ter__ation
malediction1653114male_diction
perdition1249014__perdi_tion
prediction15410304_pre_diction
retrodiction1555654retrodiction
striction1148984_st_r_iction
valediction1752404vale_diction
winterization25137814winterization

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 Filter1786911247900.393454684.5
2DLD Change Limit124790956.51319160.1
3Display Results95950.0631507.9
 (SQL Overall)178691956.96925640.8
 
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.