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

227 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
actinal931229(None) 
achiral12109182achiral
acinar8310482ac_inar
actin74922552actin__
actinally1448232actinally
acting95920982actin_g
actings104512462actings
actinia91710852actinia
actiniae101810012actiniae
actinian10209002actinian
actinias101810842actinias
actinic111810552actinic
actinon9459462actinon
actins86321102actin_s
actual8311022act_ual
affinal1336442affinal
albinal937812albinal
anginal8310162anginal
atonal6514022a_tonal
carinal94318232carinal
clinal8311552_clinal
factional1478762factional
matinal9312602matinal
retinal75318352retinal
tactical1248842tactical
vaccinal1544902vaccinal
acaudal1045783acaudal
accrual1144553accrual
accusal11136003accusal
acetal84314903ac_etal
acetin8314693acetin__
acetins9313173acetin_s
achenial1348283achenial
aching126521973achin_g
achingly1736613achingly
acing87429153ac_in_g
acini75718983ac_in_i
acinic104713543ac_inic
acinus8311253ac_inus
aclinic11188973aclinic
acritical1348133acritical
acta69524803act__a_
actinians11167003actinians
actinide11199213actinide
actinism12119883actinism
actinium1297553actinium
actinoid1148013actinoid
actinons10389453actinons
action84719683acti_on
actionable14116213actionable
actionably17105513actionably
actioner1048663actioner
actions94218513actions
activate13510373activate
active11313743acti_ve
actively1647063actively
actives12311523actives
admiral1046363admiral
adrenal838263adrenal
aecial84817313aeci_al
aerial64625713aeri_al
aestival1145483aestival
affixal2043763affixal
agonal7410053a_gonal
ammonal1137023ammonal
anal48037523a___nal
anconal939423anconal
angina7413133angina_
anginas8310953anginas
animal85016253a_nimal
annal56520763a__nnal
antennal856353antennal
antiar6317173anti_ar
anticar9312663anticar
antifat10314253antifat
antigay1148223antigay
antijam1648283antijam
antimale10312463antimale
antiman9313883antiman
anting75827023antin_g
antings85015583antings
antinodal1046323antinodal
antisag838043antisag
antitax1447853antitax
antiwar1037963antiwar
antral65719413ant_ral
apical10913903a_pical
apsidal1046703apsidal
apteral9311523apteral
archival1645783archival
arrival1037563arrival
arsenal739383arsenal
artal55525473art__al
artisan759463artisan
artisanal983823artisanal
ascetical1346273ascetical
asternal858323asternal
astral66919283ast_ral
atabal839743a_tabal
atingle848253a_tingle
atrial65418943a_trial
audial7312993audi_al
autumnal1042393autumnal
axial124515193a_xi_al
axonal1347653a_xonal
azonal1568273a_zonal
basinal9310033basinal
binal75323823__binal
cacuminal1553473cacuminal
canal75428043_c_anal
cantina93417253cantina_
cantinas102713773cantinas
cantonal1038903cantonal
capital112311523capital
cardinal1139563cardinal
carina84325323carina_
carinae94318583carinae
carinas93622403carinas
carnal83919203_carnal
catena8312483catena_
catenae9311373catenae
catenas9313113catenas
catnap1098383cat_nap
china105022483_china_
chinas115119403_chinas
chiral114614413_chiral
chital114313883_chital
citral81113893_citral
clonal8310913_clonal
coital84117053_coital
cotidal1038463cotidal
datival1135583datival
dentinal939503dentinal
dictional1268613dictional
doctrinal1243913doctrinal
ecotonal1046253ecotonal
ectypal1442773ectypal
encinal949243encinal
estival1036323estival
facial113615633fac_i_al
factoidal1543333factoidal
factual1246723fact_ual
fetial95716193feti_al
fictional1477803fictional
final83922033__final
fractional1547133fractional
geminal10109903geminal
haptical1547343haptical
hectical1547933hectical
intimal9109943intimal
kachina1637663kachina_
kachinas1736343kachinas
katcina1345153katcina_
katcinas1434513katcinas
lacrimal1244443lacrimal
lacteal966813lact_eal
lacunal9136553lac_unal
laminal94113633laminal
latina65621143latina_
latinas74416463latinas
liminal93810673liminal
luminal93711003luminal
mackinaw1943103mackinaw
marginal1137603marginal
martial92415413marti_al
martingal1244063martingal
matutinal1143183matutinal
metical11315363metical
motional1058673motional
national8311533national
nautical1057703nautical
nitinol745143nitinol
nominal92712373nominal
notional849403notional
octal71214723oct__al
octanol944743octanol
octantal1044563octantal
octaval1243583octaval
optical1149863optical
optimal1145783optimal
optional1047643optional
ordinal838633ordinal
paginal10269493paginal
partial92616263parti_al
pastina93914593pastina_
pastinas103712153pastinas
patina86022193patina_
patinae95414403patinae
patinas96318523patinas
practical1548843practical
rachial122012173rachi_al
racial83419243rac_i_al
rational8412543rational
reginal84814293reginal
retial64724993reti_al
retina65023383retina_
retinae75517333retinae
retinals85612963retinals
retinas74819353retinas
retinol7469693retinol
rhinal9510193_rhinal
ruminal9289993ruminal
scribal1137963scribal
sectional1149423sectional
seminal91213403seminal
spinal84915313_spinal
suctional1147683suctional
tactual936203tact_ual
tetanal738023tetanal
tical76021493__tical
tidal64516443__tidal
tincal83913363__tincal
tineal66216163__tineal
tonal53724303__tonal
tractional1248053tractional
trinal6516963_trinal
uncinal959963uncinal
urinal6614123_urinal
vaccina1435303vaccina_
vaccinas1544973vaccinas
vaccinial1643133vaccinial
vaginal11288403vaginal
vatical1239983vatical
veinal93812963_veinal
vicinal12268543vicinal
viminal12288823viminal
vinal85725813__vinal

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.186960704.3
2DLD Change Limit1340272277.25318478.8
3Display Results2272270.0762986.8
 (SQL Overall)1786912277.51523777.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.