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

121 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
actinia9171085(None) 
actiniae101810011actiniae
actinian10209001actinian
actinias101810841actinias
actinic111810551actinic
acapnia1145912acapnia
accidia1246992accidia
acini75718982ac_ini_
acinic104713542ac_inic
aclinic11188972aclinic
actin74922552actin__
actinal9312292actinal
acting95920982actin_g
actings104512462actings
actinians11167002actinians
actinide11199212actinide
actinism12119882actinism
actinium1297552actinium
actinoid1148012actinoid
actinon9459462actinon
actins86321102actin_s
atonia63816512a_tonia
vaccinia1543362vaccinia
acacia10311353ac_acia
acapnias1255683acapnias
accidias1346333accidias
accidie1247733accidie
acedia9310393ac_edia
acequia1844133acequia
acetin8314693acetin__
acetins9313173acetin_s
acetonic1238733acetonic
achenial1348283achenial
aching126521973achin_g
acholia1239973acholia
acidic113612133ac_idic
acinar8310483ac_inar
acing87429153ac_in_g
acinus8311253ac_inus
acrasia9310033acrasia
acromia1139963acromia
acronic112814693acronic
acta69524803act___a
actinides12188323actinides
actinisms1398883actinisms
actiniums1395843actiniums
actinoids1246303actinoids
actinons10389453actinons
action84719683acti_on
actioner1048663actioner
actions94218513actions
active11313743acti_ve
actives12311523actives
activism15117083activism
activist13109483activist
activity1647583activity
activize2246613activize
aecidia1047283aecidia
albinic1136853albinic
albizia1864093albizia
aminic104413513a_minic
ammonia1148693ammonia
amnia75918643a__mnia
angina7413133angin_a
anhinga11104823anhinga
antenna746383antenna
antiair7310313antiair
antibias10312083antibias
anting75827023antin_g
antings85015583antings
aphonia122711883aphonia
apteria9312913apteria
ascidia1046683ascidia
astasia7310933astasia
asteria7316183asteria
asthenia1167713asthenia
astigmia1143363astigmia
ataxia13179593a_taxia
atonias73315993a_tonias
atonic83420473a_tonic
atria56022343a_t_ria
auxinic1644713auxinic
bacteria1248983bacteria
baptisia1245013baptisia
bauhinia1343293bauhinia
camisia112810243camisia
cantina93417253cantin_a
carina84325323carin_a
casini84615863casini_
catena8312483caten_a
cationic12310013cationic
catnip1097973cat_nip
china105022483_chin_a
cilia73016763_c_ilia
clinic104312793_clinic
clivia1177233_clivia
cotinga10348023cotinga
crania82418433_crania
diactinic1443443diactinic
echini114710433echini_
ectopia1147693ectopia
inia45024703___inia
kachina1637663kachin_a
katcina1345153katcin_a
lactonic1248043lactonic
latina65621143latin_a
martini93613873martini_
martinis103311613martinis
pastina93914593pastin_a
patina86022193patin_a
petunia966803petunia
retina65023383retin_a
tachinid1446243tachinid
tactician1345673tactician
tenia55324483__tenia
tibia7312403__tibia
tinea54923163__tinea
titania738293titania
vaccina1435303vaccin_a
vaccinial1643133vaccinial
vaccinias1643283vaccinias

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.406440125.6
2DLD Change Limit1340271216.70319995.1
3Display Results1211210.0304033.3
 (SQL Overall)1786911217.13925030.3
 
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.