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

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

125 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
indiction123981(None) 
indication13312031indication
indictions1339311indictions
induction1248981induction
addiction13146012addiction
diction102313052__diction
inaction1039622in_action
indention1049512indention
indications14310972indications
indicting1339612indicting
indictor1147462indict_or
indirection1456382indirection
inductions1348802inductions
infection14410472infection
infliction1545942infliction
injection1838652injection
intinction1247782intinction
inunction1146892inunction
vindication1746352vindication
abdication1548223abdication
abduction14125413abduction
addictions14125363addictions
addition1096893addi_tion
adduction13225163adduction
audition979173audi_tion
benediction1643323benediction
condition12411163condi_tion
conduction1549963conduction
conviction1748183conviction
dedication14311963dedication
deduction1377083deduction
depiction1437273depiction
dictions111812673__dictions
edition8310853_edi_tion
eduction1169053_eduction
eviction13228683_eviction
fiction122010733__fiction
friction1347913_friction
ideation9310493i_deation
ignition946533igni_tion
impaction1545733impaction
inactions1139323in_actions
inanition947293inanition
incaution1146583incaution
inception1348693inception
incision1047603inci_sion
incitation12312223incitation
incretion1149053incretion
indagation1246153indagation
indecision1344413indecision
indentions1149063indentions
indexation1846343indexation
indican1048243indic__an
indicating1449693indicating
indicational1545753indicational
indicative1647713indicative
indicator1249013indicator
indicia1046983indic_i_a
indicias1147413indic_ias
indicium1355293indic_ium
indict93115573indict___
indicted1249203indict_ed
indictee1149623indict_ee
indictees1246163indictees
indicter1148143indict_er
indicters1236733indicters
indictment1545223indictment
indictors1247623indictors
indicts103210723indict__s
indigestion1353753indigestion
indignation1346533indignation
indigotin1144193indigoti_n
indirections1556193indirections
indiscretion1552803indiscretion
inditing10312113indi_ting
inductile1246123inductile
inducting1338373inducting
inductive1547263inductive
inductor1146333induct_or
induration11410613induration
infarction1545793infarction
infections15510233infections
infixation2047533infixation
infixion1843683infi_xion
inflation12311093inflation
inflection1547633inflection
inflictions1645443inflictions
infraction1557453infraction
ingestion10137483ingestion
inhibition1545343inhibition
initiation10412103initiation
injections1948663injections
injunction1945093injunction
insertion9410593insertion
inspection1446663inspection
intention9412013intention
interdiction1568143interdiction
intimation12413043intimation
intinctions1347003intinctions
intuition947623intuition
inunctions1246753inunctions
invention1248333invention
invitation13410023invitation
invocation1547543invocation
iodation9310383iod_ation
iodination1159983iodination
mediation12312293mediation
medication15411173medication
nidation9410583nid_ation
nonfiction1546303nonfiction
prediction15410303prediction
radiation10313393radiation
redaction1259663redaction
reduction1259903reduction
reliction11310693reliction
rendition1058933rendi_tion
sedition939333sedi_tion
seduction1266983seduction
stiction1038823_stiction
striction1148983striction
syndication17124963syndication
unction9310663un__ction
vendition1345693vendi_tion
vindications1845683vindications
vindictive1943543vindictive

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411257.32620289.5
3Display Results1251250.0631984.1
 (SQL Overall)1786911257.81222873.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.