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

257 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
actual831102(None) 
factual1246721factual
tactual936201tactual
acaudal1045772acaudal
accrual1144552accrual
accusal11136002accusal
acetal84314902acetal
acta69524802act_a_
actinal9312292actinal
actually1366852actually
actuary1245612actuary
actuate9311442actuate
annual64710702annual
antral65719412antral
artal55525472art_al
astral66919282astral
casual81112862casual
lacteal966812lacteal
mutual838502mutual
octal71214722oct_al
ritual6310612ritual
victual1246252victual
aal39058673a___al
abettal946073abettal
aboral8314373aboral
abuttal954553abuttal
accentual1343673accentual
accruals1243703accruals
accusals12145053accusals
accuse103411033accuse
aceta74017353aceta_
acetals93411353acetals
acetum1038463acetu_m
acetyl11396553acetyl
achiral12109183achiral
acicula11228133acicula
acinar8310483acinar
acquit17610323acquit
act59557843act___
actable11313473actable
acted88521733act_ed
actin74922553act_in
acting95920983acting
actins86321103actins
action84719683action
active11313743active
actor71116073act_or
actorly1246413actorly
actors81016753actors
acts66929863act__s
actuality1445803actuality
actualize2046343actualize
actuarial1144973actuarial
actuated1138743actuated
actuates10310303actuates
actuator1046643actuator
acuate8315633ac_uate
acute74720363ac_ute
acutely1246123acutely
acuter84412863acuter
acutes83917723acutes
acyl95314293ac__yl
aecial84817313aecial
aerial64625713aerial
afoul8510193afou_l
agonal7410053agonal
ahull84010313a_hull
algal66518213a_lgal
altar55520643alt_ar
alula5317093a_lula
amoral8314623amoral
ampul91110853ampu_l
amtrac10109123amtrac
anal48037523a__nal
anconal939423anconal
animal85016253animal
annal56520763a_nnal
anneal64812293anneal
annuals7388193annuals
annul55813383annu_l
anodal72512113anodal
anta46839583ant_a_
antae56828293ant_ae
antas55432033ant_as
antiar6317173antiar
antra56521923antra_
anural65714743anural
aortal65217513aortal
apical10913903apical
apneal83411123apneal
apodal9289823apodal
appal95315223a_ppal
appeal103911613appeal
apteral9311523apteral
aqua132813963a_qua_
aquae142212713a_quae
aquas142412613a_quas
areal55928733a_real
argal65023383a_rgal
arousal748633arousal
artel56122743art_el
artful968273artful
arval86017013a_rval
asexual1443973asexual
aspectual1352773aspectual
astrals75515243astrals
astray95615543astray
astute6310763astute
atabal839743atabal
atap66722453a_t_ap
atlas55821583a_tlas
atlatl637873a_tlatl
atma68121773a_tma_
atman75520143a_tman
atmas75721013a_tmas
atoll57913923a_toll
atonal6514023atonal
atrial65418943atrial
attar56516693a_ttar
attune637983attune
audial7312993audial
augural856403augural
aural54428963a_ural
austral73411513austral
autumn836013autumn
autumnal1042393autumnal
avowal1246323avowal
awful1178143awfu_l
axal116520493a__xal
axial124515193a_xial
axonal1347653axonal
azonal1568273azonal
bacula103112673bac_ula
bracteal1245563bracteal
brutal859383brutal
cabal95222153_cabal
cactus104912233cactu_s
caecal103713733caecal
canal75428043_canal
cantal84122033cantal
canthal12410053canthal
canula8312963canula
carnal83919203carnal
carpal103716253carpal
casuals91410523casuals
catalo8314853cat_alo
catcall1139153catcall
catfall1237393catfall
catnap1098383catnap
cattail939173cattail
cattalo938423cattalo
catwalk1645323catwalk
caudal91611483caudal
caul65630003_cau_l
causal81413203causal
cecal94619113_cecal
churl105913883_churl
citral81113883citral
coal66939253_c_oal
comal95125133_comal
copal95621783_copal
coral76033453_coral
coxal146116673_coxal
craal74117753_craal
cruel74815903_cruel
crural8610633_crural
cull65929643_c_ull
curl66035053_c_url
dactyl1234983dact_yl
dotal64919623dot_al
dual55928173__dual
ductal938993duct_al
ectypal1442773ectypal
equal1449823_equal
estral64716513estral
estrual7367933estrual
facial113615633fac_ial
factful1536373factful
factually1744663factually
facture12108923facture
facula112912233fac_ula
fatal84819373fat_al
fetal85623373fet_al
fetial95716193fetial
fractal1237623fract_al
fractural1444553fractural
futural1037283futural
gastral8329553gastral
habitual1343493habitual
hartal9415473hart_al
ictus7249693ictu_s
jacal14313703jac__al
jackal1937613jac_kal
joual12311653_joual
lactam10310943lact_am
lacteals1095663lacteals
lactean956473lactean
lacunal9136553lacunal
lethal939803lethal
luteal64411483luteal
macrural1244953macrural
macula103013673mac_ula
mantua84412023mantua_
mantuas93410993mantuas
manual8313463manual
martial92415413martial
metal75427383met_al
mitral81314323mitral
mutuals937123mutuals
mutuel837823mutuel
natal53921493nat_al
natural739513natural
notal55221353not_al
octad81510653oct_ad
octan71313483oct_an
octaval1243583octaval
octuple1153993octuple
octuply1443133octuply
octyl10136063oct_yl
osteal6312953osteal
partial92616263partial
pastural1038413pastural
petal76526893pet_al
punctual1243903punctual
rachial122012173rachial
racial83419243rac_ial
ratal55025113rat_al
rectal84418133rect_al
retial64724993retial
retral64419743retral
rictal83113173rict_al
rituals738353rituals
sacral83414413sac_ral
schul102510413schu_l
scull75315763sc_ull
scuta75815753scuta_
setal56430903set_al
sexual1338413sexual
steal56125473_steal
stull54916273_stull
sutural7310223sutural
tactful1236163tactful
tactical1248843tactical
tactually1445003tactually
teal45546503__teal
tectal83713253tect_al
textual1444603textual
total55321823tot_al
tubal75517203__tubal
ungual738183ungual
usual5310183_usual
vacua10510463vac_ua_
victuals1344773victuals
virtual1045913virtual
visual938803visual
vital84819673vit_al
withal1238933withal

Search took 7 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162576.29617902.8
3Display Results2572570.1701511.8
 (SQL Overall)1786912576.60927037.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.