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

238 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
acetals9341135(None) 
acetal84314901acetal_
acetyls12285351acetyls
abettals1054722abettals
aceta74017352aceta__
acetate92514752acetate
acetates102013062acetates
acetins9313172acetins
acetous9410362acetous
acetyl11396552acetyl_
apetaly1237252apetaly
cantals93919572cantals
centals94317052_centals
lacteals1095662lacteals
metals84520882_metals
petals84719812_petals
aals49941143a___als
abets75621673abet__s
abettal946073abettal_
abuttals1043923abuttals
accruals1243703accruals
accusals12145053accusals
acedias1039773acedias
acerate92818913acerate
acerola947823acerola
acerolas1048053acerolas
acerous9513333acerous
aces67645093ace___s
acetabula1351833acetabula
acetamid1344793acetamid
acetamids1443443acetamids
acetated112010683acetated
acetic10314503acet_ic
acetify1545003acetify
acetin8314693acet_in
acetone9310793acetone
acetones10310033acetones
acetose938843acetose
acetoxyls2151913acetoxyls
acetum1038463acet_um
acetylic1543573acetylic
acta69524803ac_ta__
actable11313473ac_table
actins86321103ac_tins
actors81016763ac_tors
acts66929863ac_t__s
actual8311023actual_
acutely1246123acutely
acutes83917723acut_es
acyls104211523ac__yls
adenyls1143923adenyls
adrenals946303adrenals
aecial84817313aecial_
aerials74017553aerials
agitas7310593agita_s
akelas10311193akela_s
alegars838933alegars
altars64518153a_ltars
amatols938183amatols
amebas10311453ameba_s
anears63717183ane_ars
anethols1145843anethols
animals94111703animals
annals66415923a_nnals
anneals7449943anneals
annuals7388193annuals
antas55432033a_nta_s
aortal65217513aortal_
aortas65417783aorta_s
apetalies1148003apetalies
apetalous1144583apetalous
apicals1159923apicals
appals104812943a_ppals
appeals11378673appeals
areal55928733are_al_
areas55935773are_a_s
arecas84817443areca_s
arenas65021993arena_s
areolas71013863areolas
arepas85515703arepa_s
aretes64425353aret_es
argals75517713a_rgals
arsenals847733arsenals
artal55525473a_rtal_
artels66216233a_rtels
ascetics1247073ascetics
astrals75515243astrals
atabals938413atabals
ataps76414833a__taps
atlas55821583a__tlas
atlatls744773atlatls
attars64515313a_ttars
australs8359533australs
avatars1036443avatars
aventails1244993aventails
avowals1335013avowals
axels126313633axe__ls
betas75528763_beta_s
betels84515063_betels
biacetyls1651923biacetyls
bimetals1246943bimetals
buttals938503buttals
cabals104020153_cabals
caecal103713733caecal_
caesars9410733caesars
caftans12179443caftans
canals84421663_canals
cantal84122033cantal_
cantala94114673cantala
cantalas104013523cantalas
capitals12209443capitals
captans111612053captans
carpals113414623carpals
cartels94618123cartels
casuals91410523casuals
catalo8314853_catalo
catalos9414163_catalos
cattails1038553cattails
cattalo938423cattalo
cattalos1037933cattalos
causals91411183causals
cecal94619113_cecal_
cedars93312833_cedars
ceils75019403_ce_ils
cells75428063_ce_lls
cels65534973_ce__ls
cental84420963_cental_
centas85020703_centa_s
centrals102712033_centrals
ceorls848163_ceorls
cereals9313173_cereals
cestas85018543_cesta_s
cetane8315283_cetane
cetanes9315133_cetanes
cetes75731103_cet_es
chetahs15347073chetahs
citrals91111673_citrals
coals76129603_c_oals
coevals1237873coevals
copals105018943_copals
corals85325143_corals
cotans81317923_cotans
craals84113303_craals
curtals93111623curtals
cutlas8313103_cutlas
dactyls1333913dac_tyls
deals65435343_de_als
decals93717713_decals
decretals1245093decretals
dentals83915393dentals
details84214043_details
diacetyls1542253diacetyls
etas46432273__eta_s
facetely1643853facetely
facets116316653facet__s
facials123310743fac_ials
fecials123510333fecials
ferals94216643_ferals
fetal85623373_fetal_
fetas85624403_feta_s
fetials103711743_fetials
foetal9311883foetal_
fractals1346133frac_tals
gametal1037603gametal_
getas65421483_geta_s
hartals10313023hartals
heals85733453_he_als
hyetal1236543hyetal_
icecaps1343863icecaps
icefall1254303icefall
icefalls1344253icefalls
ideals75012503ide_als
instals7611713instals
jacals1539873jac__als
jackals2036893jac_kals
ketols104210763_ketols
lactams1136953lac_tams
lacteal966813lacteal_
lanitals837723lanitals
laterals8312753laterals
legals73412733_legals
lethals1038113_lethals
meals75933373_me_als
medals94218053_medals
metal75427383_metal_
metols84115773_metols
mortals93914003mortals
nametags1143093nametags
nectars938463nectars
oceans81211003oce_ans
octads987333oc_tads
octal71214723oc_tal_
octans81411143oc_tans
octyls11135323oc_tyls
palatals1037773palatals
parietals1146863parietals
peals75235493_pe_als
pedals94316033_pedals
petal76526893_petal_
pietas84516503pieta_s
placentals1443523placentals
portals94015563portals
postals93716373postals
quetzals2642583quetzals
quezals2544253quezals
racewalk1744063racewalk
racewalks1843533racewalks
raceways1645233raceways
ratals64219583_ratals
reals55038653_re_als
recitals1039763recitals
recoals94214623recoals
rectal84418133rectal_
rentals74017473rentals
retags73414303_retags
retails74718973_retails
sacrals93311793sac_rals
scenas84114703scena_s
seals54839693_se_als
sepals85217373_sepals
setal56430903_setal_
sheals94420643she_als
spitals93011593spitals
steals64020063ste_als
tapetal938273tapetal_
teals56234133_te_als
tectal83713253tectal_
tepals85415043_tepals
thetas93011573theta_s
totals63115163_totals
varietals1244443varietals
veals84926193_ve_als
vestals104612333vestals
vitals94514303_vitals
weals85428743_we_als
wheals124512523whe_als
zeals145320853_ze_als
zetas145018163_zeta_s

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.1561145455.1
2DLD Change Limit1340272387.70317399.3
3Display Results2382380.0802975.0
 (SQL Overall)1786912387.93922508.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.