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 “ephebic” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
ephebic164651(None) 
ephebi1345081ephebi_
aphetic142912852aphetic
ephebe1336062epheb_e
ephebes1436152ephebes
epheboi1442982epheboi
ephebos1444112ephebos
ephebus1443282ephebus
etheric12311782etheric
euphenic1557202euphenic
phobic153010072_phobic
sphenic1449092sphenic
spheric14510072spheric
aetheric13410163aetheric
amebic1239113_amebic
amoebic1346153amoebic
aphasic142810063aphasic
aphelia1249423aphelia
aphesis12610513aphesis
aphonic142713393aphonic
aphotic142913123aphotic
apneic1078623apne_ic
aspheric1547983aspheric
cephalic1777903cephalic
cepheid1545433cephe_id
chebec1536963_chebec
chemic153012093_chemic
ecesic10369223e_cesic
echoic1339043ech_oic
edenic9310223e_denic
eidetic1039743eidetic
eirenic939003eirenic
emetic10614453e_metic
emphatic1747863emphatic
empyemic1943313empyemic
endemic1237893endemic
enteric9314213enteric
enthetic131110613enthetic
epeiric1145313epeiric
ephedra1344213ephedra
ephedrin1444703ephedrin
ephori1139603ephori_
epic86921303ep___ic
epidemic1545303epidemic
epigeic1245983epigeic
epigenic1347483epigenic
epimeric1476763epimeric
epithetic1666413epithetic
epizoic2045193epizoic
esthetic13119773esthetic
ethic101511223eth__ic
ethnic1148853eth_nic
ethylic1546323ethylic
eugenic1038603eugenic
euphenics16115363euphenics
euphonic15117813euphonic
euphoric15107043euphoric
euphotic15117523euphotic
eupneic1144483eupne_ic
exhibit1945253exhibit
hemic125718623__hemic
hyphenic2147013hyphenic
mephitic1747143mephitic
nephric1446213neph_ric
ophitic1439213ophitic
phasic133612053_phasic
phatic133014413_phatic
phenix1837133_phenix
phobia13278603_phobia
phobics16286703_phobics
phonic133315213_phonic
photic133316443_photic
phrenic1438773_phrenic
phylic16279553_phylic
physic16288473_physic
poetic10416843_poetic
prebid113512843_prebid
pubic114513723_p_ubic
pyemic1537893_pyemic
spherics1537073spherics
splenic1148663splenic
sthenic1268903sthenic
terebic1137983terebic
thetic11412893_thetic

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 Filter1786911340270.423422437.4
2DLD Change Limit134027845.67323625.4
3Display Results84840.0302800.0
 (SQL Overall)178691846.12629169.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.