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

127 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
actinon945946(None) 
actinons10389451actinons
action84719681acti_on
actin74922552acti__n
actinal9312292actinal
acting95920982actin_g
actings104512462actings
actinia91710852actinia
actinian10209002actinian
actinic111810552actinic
actinoid1148012actinoid
actins86321102actin_s
actions94218512actions
auction93412932aucti_on
cation83925502cati_on
faction122613332facti_on
paction112713962pacti_on
taction93213022tacti_on
abutilon1043083abutilon
acetin8314693aceti__n
acetins9313173acetin_s
aching126521973achin_g
acinar8310483ac_inar
acing87429153ac_in_g
acini75718983ac_in_i
acinic104713543ac_inic
acinose938583ac_inose
acinous9310933ac_inous
acinus8311253ac_inus
aclinic11188973aclinic
acrimony1543563acrimony
actiniae101810013actiniae
actinians11167003actinians
actinias101810843actinias
actinide11199213actinide
actinism12119883actinism
actinium1297553actinium
actinoids1246303actinoids
actioner1048663actioner
active11313743acti_ve
actives12311523actives
actor71116083act__or
alation72920553alati_on
albino839933albino_
albinos937653albinos
amino75425503a_mino_
ammino1069883ammino_
amnion84812053amni_on
amotion9710473amoti_on
andiron848283andiron
anion55028813a_ni_on
anon46134853a___non
antifog1146313antifog
antigen8311123antigen
antigun847963antigun
antilog838623antilog
antiman9313883antiman
antimony1358303antimony
anting75827023antin_g
antings85015583antings
antinode9810233antinode
antinome10810443antinome
antinomy1367373antinomy
antiphon1346773antiphon
antiporn1048473antiporn
antipot9312923antipot
antisnob1044213antisnob
antiunion986383antiunion
antlion7310293antlion
arsino64113513arsino_
artisan759463artisan
auctions104012143auctions
avion84218343a_vi_on
axion1211316913a_xi_on
bastion9312473basti_on
camion103917193cami_on
cannon84514443_cannon
canon74725303_c_anon
caption113513693capti_on
casino84317553casino_
casinos93512833casinos
cations94524143cations
caution93013523cauti_on
chignon1344623_chignon
chino105823313_chino_
chinone12510153_chinone
chinos115018693_chinos
chiton112612393_chiton
cion613330913_c_i_on
citron83112983_citron
coaction12310773coacti_on
diction102313053dicti_on
exaction1738953exacti_on
factions133013063factions
fiction122010733ficti_on
fraction1359483fracti_on
inaction1039623inacti_on
kation104315683kati_on
latino64120473latino_
latinos73613803latinos
lection92614863lecti_on
lotion65716523loti_on
motion85217553moti_on
nation64322803nati_on
ninon55517383__ninon
nitinol745143nitinol
notion64516583noti_on
octagon1045243octagon
octanol944743octanol
option83612713opti_on
pactions122613503pactions
pinon76024533__pinon
potion84519573poti_on
ration64226013rati_on
reaction10612603reacti_on
retinol7469693retinol
ruction93611613ructi_on
sanction1049533sancti_on
scion72214993sc_i_on
section92515663secti_on
suction93713043sucti_on
tactions102912423tactions
tenon53320513__tenon
tigon63914443__tigon
traction10412683tracti_on
unction9310663uncti_on
vacation131911893vacati_on

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271276.83019623.3
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.31224438.0
 
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.