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

153 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
inaction103962(None) 
inactions1139321inactions
action84719682__action
coaction12310772coaction
enation73419232ena_tion
exaction1738952exaction
faction122613332_faction
fraction1359482fraction
impaction1545732impaction
inactive1348202inactive
inanition947292inanition
incaution1146582incaution
indiction1239812indiction
induction1248982induction
infarction1545792infarction
infection14410472infection
infraction1557452infraction
injection1838652injection
inunction1146892inunction
nation64322802_na_tion
nonaction1149442nonaction
paction112713962_paction
reaction10612602reaction
sanction1049532sanction
taction93213022_taction
traction10412682traction
unction9310662un_ction
actin74922553__acti_n
actinon9459463__actinon
actions94218513__actions
adaption1145643adaption
adnation9310783adna_tion
agnation9311723agna_tion
alation72920553ala_tion
auction93412933_auction
bastion9312473_bastion
bijection20134793bijection
bilection13156803bilection
bisection13136983bisection
caption113513693_caption
cation83925503_ca_tion
caution93013523_caution
citation10314363cita_tion
coactions1349743coactions
conation101420883cona_tion
diction102313053_diction
dilation92215463dila_tion
direction1289783direction
donation91513783dona_tion
eduction1169053eduction
ejection172510043ejection
elation73620453ela_tion
election102015353election
enacting11311363enacting
enactive1338513enactive
enactor938033enact_or
enations83316903ena_tions
erection102115513erection
evection131910833evection
eviction13228683eviction
exactions1838923exactions
factions133013063_factions
fiction122010733_fiction
fixation1837073fixa_tion
flection13239563flection
fractions1449103fractions
friction1347913friction
function1337843function
gnathion1243443gnathion
himation1339753hima_tion
ideation9310493ideation
ignition946533ignition
illation8311943illation
impactions1645413impactions
inanitions1046383inanitions
incautions1245973incautions
inception1348693inception
incision1047603incision
incretion1149053incretion
indagation1246153indagation
indention1049513indention
indication13312033indication
indictions1339313indictions
inductions1348803inductions
infarctions1645023infarctions
infections15510233infections
infixion1843683infixion
inflation12311093inflation
inflection1547633inflection
infliction1545943infliction
infractions1646963infractions
infusion1146523infusion
ingestion10137483ingestion
inhalation13107663inhalation
inhesion11116373inhesion
inion54620183in___ion
injections1948663injections
injunction1945093injunction
insertion9410593insertion
inspection1446663inspection
intention9412013intention
interaction13411813interaction
intinction1247783intinction
intron64215023in__tron
intuition947623intuition
inunctions1246753inunctions
invasion11115473invasion
invention1248333invention
invocation1547543invocation
iodation9310383iodation
isatin6412213isa_ti_n
junction1736203junction
kation104315683_ka_tion
lection92614863_lection
libation102411363liba_tion
ligation92313093liga_tion
lineation9310763lineation
location102113913location
lunation8311923luna_tion
nasion63914083_na_sion
natation81513933_natation
nations74720563_na_tions
natron64116023_na_tron
niacin8310223niac_i_n
nidation9410583nidation
nonactions1248373nonactions
notion64516583_n_otion
olfaction1464233olfaction
oration71617713ora_tion
ovation101510023ova_tion
pactions122613503_pactions
pinnation1138013pinnation
placation1339773placation
proaction13410103proaction
ration64226013_ra_tion
reactions11711713reactions
redaction1259663redaction
ruction93611613_ruction
ruination9311273ruina_tion
sanctions1138873sanctions
section92515663_section
sinuation9310413sinuation
station72717243sta_tion
stiction1038823stiction
suction93713043_suction
tactions102912423_tactions
tractions11511623tractions
unctions1039733un_ctions
urination9312173urina_tion
vacation131911893_vacation
venation11513503vena_tion
vocation132311983vocation
zonation171410723zona_tion

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621536.69021847.8
3Display Results1531530.0602550.0
 (SQL Overall)1786911537.15624970.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.