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

197 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
aphotic14291312(None) 
aphetic142912851aphetic
aphonic142713391aphonic
aprotic112715241aprotic
photic133316441_photic
abiotic11510462abiotic
acrotic112515542acrotic
aphasic142810062aphasic
aphonia122711882aphonia
aphonics15259522aphonics
aplitic11311742aplitic
apnoeic1147612apnoeic
argotic10310282argotic
azotic172711632a_zotic
euphotic15117522euphotic
kyphotic2245772kyphotic
ophitic1439212ophitic
parotic112518042parotic
phatic133014412_phatic
phobic153010072_phobic
phonic133315212_phonic
photics142810482_photics
ptotic102713372_ptotic
rhotic112711232_rhotic
acetic10314503a_cetic
acholia1239973acholia
achromic1747613achromic
acidotic1355983acidotic
acmatic13311703acmatic
acronic112814693acronic
acrostic1239943acrostic
aeonic83517043a_eonic
aerobic11310213aerobic
agnatic10310973agnatic
agnostic1146713agnostic
agonic93515143a_gonic
albitic1139133albitic
aliphatic1645343aliphatic
aloetic9313183aloetic
alphosis1347273alphosis
amitotic1247013amitotic
ammonic1349163ammonic
amniotic1246403amniotic
amphoteric1953593amphoteric
anaphoric1646253anaphoric
anionic9312873anionic
anodic92813133a_nodic
anomic102516303a_nomic
anoxic152610673a_noxic
antic75728863a__ntic
aortic8316613a_ortic
apagogic1443893apagogic
apatetic1258593apatetic
apathetic1647863apathetic
aphagia13247663aphagia
aphanitic1646013aphanitic
aphasia122510873aphasia
aphasiac15286593aphasiac
aphasics15257243aphasics
aphelia1249423aphelia
apheretic1687413apheretic
aphesis12610513aphesis
aphid115515393aph__id
aphis105917133aph__is
aphonias132611143aphonias
aphorise1339983aphorise
aphorism1548643aphorism
aphorist13412513aphorist
aphoristic1746363aphoristic
aphorize2249043aphorize
aphtha1444483aph_tha
aplastic1249243aplastic
apneic1078623ap_neic
apocopic1645823apocopic
apogeic1246603apogeic
apomict1349053ap_omict
apoptotic1545073apoptotic
aporia8315863ap_oria
apostil947903apostil
apractic1448303apractic
apraxic1846293apraxic
apyretic1546843apyretic
aquatic1838113aquatic
arctic10313513a_rctic
arkosic1346063arkosic
ascetic11310063ascetic
ascitic1139323ascitic
aseptic1137373aseptic
asphaltic1644603asphaltic
aspheric1547983aspheric
astatic9514193astatic
atactic11410083atactic
athetotic1455403athetotic
athletic13118653athletic
atomic104115603a_tomic
atonic83420473a_tonic
atopic103514143a_topic
atretic9313923atretic
attic75618353a__ttic
augitic1038283augitic
auxetic1637143auxetic
aviatic1239243aviatic
avionic1237693avionic
axonic154312723a_xonic
azoic162912063a_zo_ic
azonic175513153a_zonic
bathetic1548583bathetic
biotic103816613_biotic
camphoric2045493camphoric
cathodic16126753cathodic
catholic15158383catholic
cerotic11415063cerotic
chaotic14310043chaotic
choric133515903_choric
demotic12412353demotic
dhoti9310123_dhoti_
dhotis1038973_dhotis
dichotic1647663dichotic
diprotic1348553diprotic
echoic1339043echo_ic
emphatic1747863emphatic
ephebic1646513ephebic
ephori1139603ephori_
epidotic1346883epidotic
ergotic1049723ergotic
erotic82620273_erotic
euphonic15117813euphonic
euphoric15107043euphoric
exotic153112653_exotic
graphitic1744793graphitic
haplontic1643943haplontic
haptic13511893hap__tic
hypnotic1846623hypnotic
idiotic1037463idiotic
kathodic18114573kathodic
kenotic1359713kenotic
ketotic1348643ketotic
leprotic1248583leprotic
litotic939243litotic
lotic76420673__lotic
meiotic11410933meiotic
mephitic1747143mephitic
miotic103715753_miotic
mitotic1139713mitotic
mycotic1647713mycotic
myotic133112313_myotic
narcotic1277913narcotic
nephrotic1646293nephrotic
nepotic11310563nepotic
oophytic1865953oophytic
opsonic1137253opsonic
optic93715183op__tic
orthotic1348213orthotic
osmotic11127613osmotic
otic66624823___otic
panoptic1447183panoptic
papistic1448733papistic
paretic113016673paretic
parodic122311723parodic
parotid102915513parotid
pathetic15410963pathetic
pectic122913873_pectic
peptic122113153_peptic
phasic133612053_phasic
phimotic1747153_phimotic
phobia13278603_phobia
phobics16286703_phobics
phonetic15310323_phonetic
phonics143110723_phonics
phot95534363_phot__
photo104417233_phot_o
photog12379813_photog
photon1111514833_photon
photonic15312103_photonic
photopic17411093_photopic
photos113316643_photos
phots105418503_phot_s
phylic16279553_phylic
physic16288473_physic
phytin14459013_phytin
pionic103515953_pionic
poetic10416843_poetic
psoatic1139303_psoatic
rachitic1547593rachitic
rhodic12227233_rhodic
robotic1139223robotic
saprobic1445263saprobic
siphonic1547983siphonic
spastic11310383spastic
sphenic1449093sphenic
spheric14510073spheric
thetic11412893_thetic
thoric114314043_thoric
typhonic1847173typhonic
xerotic16410863xerotic
zygotic2254663zygotic
zymotic2345713zymotic

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 Limit1340271976.70319995.1
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.18524870.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.