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

115 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
ephebes143615(None) 
ephebe1336061ephebe_
ephebos1444111ephebos
ephebus1443281ephebus
apheses12610702apheses
epees75219832ep_e_es
ephebi1345082epheb_i
ephebic1646512ephebic
epheboi1442982epheboi
ethenes103313872ethenes
hebes105521672__hebes
phoebes1435812_phoebes
plebes104313622_plebes
sphenes123013162sphenes
spheres123114352spheres
thebes115914492_thebes
achenes12313493achenes
adheres11310163adheres
apexes1539133ap_exes
aphesis12610513aphesis
aphides134711203aphides
cepheids1644243cepheids
chebec1536963_chebec
chebecs1635013_chebecs
coheres122917693coheres
depletes112810643depletes
echelles1346673echelles
eches106322163ech__es
echoes114715523ech_oes
ekpweles1741903ekpweles
emcees1037813emce_es
emeses86114963e_meses
emphases1568353emphases
enrobes92211113enrobes
enspheres1486083enspheres
epee64628503ep_e_e_
ephahs1435503eph_ahs
ephas10311543eph__as
ephedra1344213ephedra
ephedras1444413ephedras
ephemera1554213ephemera
ephemeras1653573ephemeras
ephemeris1654633ephemeris
ephods1238363eph_ods
ephors11311403eph_ors
epicenes1249253epicenes
epimeres12117653epimeres
epodes94315563ep_odes
epopees1137233epopees
eposes84418783ep_oses
epoxies1637753epoxies
estheses1137783estheses
esthetes1147743esthetes
ethanes103713513ethanes
ethene93312923ethene_
ethers94518413ethe_rs
ethoses10311763ethoses
ethynes13377573ethynes
etwees9348793etwe_es
euphroes1345993euphroes
exhales1737143exhales
exhumes1934323exhumes
ghees95215553_ghe_es
glebes95512243_glebes
grebes93813613_grebes
hebe96424703__hebe_
hemes105031083__hemes
heres86245903__heres
hexes155123043__hexes
imphees1436693imphe_es
inheres10315173inheres
nephews1533323nephe_ws
ophites12310103ophites
pedes85327293_p_edes
pees65257373_p_e_es
peeves113814873_peeves
pekes114623563_p_ekes
peles75738083_p_eles
penes75839223_p_enes
peres76246643_p_eres
pewees11311393pewe_es
phages125213513_phages
phases114618403_phases
phizes20389133_phizes
phoebe1335003_phoebe_
phoebus1443823_phoebus
phones114121213_phones
physes14399783_physes
pieces104217273_pieces
plebe95014873_plebe_
plebs95814583_pleb_s
plexes155313543_plexes
prees75937173_pre_es
prexes154915953_prexes
prezes173614693_prezes
probes104119453_probes
pubes94423403_p_ubes
repletes102812473repletes
reprobes121910293reprobes
rhemes115913183_rhemes
schemes1489663schemes
spahees1238263spahe_es
sphene113412403sphene_
sphere113313663sphere_
sphered133512313sphered
sprees85620643spre_es
tepees84215243tep_e_es
thebe107515433_thebe_
themes115319253_themes
theres96525473_theres
theses96517973_theses
upheaps1494233upheaps
upheaves1643913upheaves
uphroes1236303uphroes
wheres125917433_wheres

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 Limit1340271156.79619721.5
3Display Results1151150.0502300.0
 (SQL Overall)1786911157.25224640.2
 
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.